C# DataLayer.Update方法代码示例

 public void ApproveDoctor(String docUsername, string connString)
 {
     SqlParameter dUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
     dUsername.Value = docUsername;
     SqlCommand cmdSql = new SqlCommand();
     cmdSql.CommandType = CommandType.StoredProcedure;
     cmdSql.CommandText = "usp_ApproveDoctor";
     cmdSql.Parameters.Add(dUsername);
     DataLayer datalayerObj = new DataLayer();
     cmdSql = datalayerObj.Update(cmdSql, connString);
 }

        //update query status to needs more info
        public void UpdateQueryStatus(int queryId, string connString)
        {
            SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.Int);
            SqlParameter pQueryStatus = new SqlParameter("@Status", SqlDbType.VarChar, 30);
            pQueryId.Value = queryId;
            pQueryStatus.Value = "Needs More Info";

            SqlCommand cmdSql = new SqlCommand();

            cmdSql.CommandType = CommandType.StoredProcedure;
            cmdSql.CommandText = "usp_UpdateQueryStatus";

            cmdSql.Parameters.Add(pQueryId);

            DataLayer dataLayerObj = new DataLayer();
            dataLayerObj.Update(cmdSql, connString);
        }

        public void UpdateQuery(Query queryObj, string connString)
        {
            SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.Int);
            SqlParameter pUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
            SqlParameter pQueryAreaOfInterest = new SqlParameter("@QueryAreaOfInterest", SqlDbType.NVarChar, 100);
            SqlParameter pSymptoms = new SqlParameter("@Symptoms", SqlDbType.NVarChar, 200);
            SqlParameter pMedicalHistory = new SqlParameter("@MedicalHistory", SqlDbType.NVarChar, 500);
            SqlParameter pStatus = new SqlParameter("@Status", SqlDbType.NVarChar, 20);
            SqlParameter pIsAttendedTo = new SqlParameter("@IsAttendedTo", SqlDbType.Bit);
            SqlParameter pPostedDateTime = new SqlParameter("@PostedDateTime", SqlDbType.DateTime);

            pQueryId.Direction = ParameterDirection.Output;
            pQueryAreaOfInterest.Value = queryObj.QueryAreaOfInterest;
            pUsername.Value = queryObj.Username;
            pSymptoms.Value = queryObj.Symptoms;
            pMedicalHistory.Value = queryObj.MedicalHistory;
            pStatus.Value = queryObj.Status;

            //the boolean value
            pIsAttendedTo.Value = queryObj.IsAttendedTo;

            //the date time value
            pPostedDateTime.Value = queryObj.PostedDatetime;

            //adding params to query
            SqlCommand cmdSql = new SqlCommand();
            cmdSql.CommandType = CommandType.StoredProcedure;
            cmdSql.CommandText = "usp_UpdateQuery";

            cmdSql.Parameters.Add(pQueryAreaOfInterest);
            cmdSql.Parameters.Add(pUsername);
            cmdSql.Parameters.Add(pSymptoms);
            cmdSql.Parameters.Add(pMedicalHistory);
            cmdSql.Parameters.Add(pStatus);
            cmdSql.Parameters.Add(pIsAttendedTo);
            cmdSql.Parameters.Add(pPostedDateTime);
            cmdSql.Parameters.Add(pQueryId);

            DataLayer datalayerObj = new DataLayer();
            datalayerObj.Update(cmdSql, connString);
            queryObj.QueryId = int.Parse(pQueryId.Value.ToString());
        }

 public void UpdateComment(Comments commentObj, string connectionString)
 {
     SqlParameter pCommentId = new SqlParameter("@CommentId", SqlDbType.Int, 0);
     SqlParameter pCommentField = new SqlParameter("@CommentsField", SqlDbType.NVarChar, 100);
     pCommentId.Value = commentObj.CommentId;
     pCommentField.Value = commentObj.CommentsField;
     SqlCommand cmd = new SqlCommand();
     cmd.CommandType = CommandType.StoredProcedure;
     cmd.CommandText = "usp_UpdateUserSubmittedComment";
     cmd.Parameters.Add(pCommentId);
     cmd.Parameters.Add(pCommentField);
     DataLayer dataLayerObj = new DataLayer();
     cmd = dataLayerObj.Update(cmd, connectionString);
 }

        public Advice InsertAdvice(Advice adviceObj, string connString)
        {
            //declaration of parameters
            string errorMessage;

            if (isValidAdvice(adviceObj, out errorMessage))
            {
                SqlParameter pQueryId = new SqlParameter("@QueryId", SqlDbType.Int);
                SqlParameter pUsername = new SqlParameter("@Username", SqlDbType.NVarChar, 50);
                SqlParameter pLikes = new SqlParameter("@Likes", SqlDbType.Int);
                SqlParameter pDislikes = new SqlParameter("@Dislikes", SqlDbType.Int);
                SqlParameter pAdviceDescription = new SqlParameter("@AdviceDescription", SqlDbType.NVarChar, 400);
                SqlParameter pAdviceTitle = new SqlParameter("@AdviceTitle", SqlDbType.NVarChar, 50);
                SqlParameter pAdviceDateTime = new SqlParameter("@AdviceDateTime", SqlDbType.DateTime);

                //initialization
                pQueryId.Value = adviceObj.QueryId;
                pUsername.Value = adviceObj.Username;
                pLikes.Value = adviceObj.Likes;
                pDislikes.Value = adviceObj.Dislikes;
                pAdviceDescription.Value = adviceObj.AdviceDescription;
                pAdviceTitle.Value = adviceObj.AdviceTitle;
                pAdviceDateTime.Value = adviceObj.AdviceDateTime;

                //adding params to query
                SqlCommand cmdSql = new SqlCommand();
                cmdSql.CommandType = CommandType.StoredProcedure;
                cmdSql.CommandText = "usp_InsertAdvice";

                cmdSql.Parameters.Add(pQueryId);
                cmdSql.Parameters.Add(pUsername);
                cmdSql.Parameters.Add(pLikes);
                cmdSql.Parameters.Add(pDislikes);
                cmdSql.Parameters.Add(pAdviceDescription);
                cmdSql.Parameters.Add(pAdviceTitle);
                cmdSql.Parameters.Add(pAdviceDateTime);

                //storage in data layer
                DataLayer datalayerObj = new DataLayer();
                cmdSql = datalayerObj.Insert(cmdSql, connString);

                //updating query status 'IsAttendedTo'
                SqlParameter pIsAttendedTo = new SqlParameter("@IsAttendedTo", SqlDbType.Bit);
                SqlParameter pStatus = new SqlParameter("@Status", SqlDbType.VarChar, 30);
                SqlParameter pQuery1 = new SqlParameter("@QueryId", SqlDbType.Int);
                pQuery1.Value = pQueryId.Value;
                pIsAttendedTo.Value = true;
                pStatus.Value = "Answered";

                //first command
                SqlCommand cmdSql1 = new SqlCommand();

                cmdSql1.CommandType = CommandType.StoredProcedure;
                cmdSql1.CommandText = "usp_UpdateQueryAttended";

                cmdSql1.Parameters.Add(pQuery1);
                cmdSql1.Parameters.Add(pIsAttendedTo);

                datalayerObj = new DataLayer();
                cmdSql1 = datalayerObj.Update(cmdSql1, connString);

                //second command
                SqlCommand cmdSql2 = new SqlCommand();
                cmdSql2.CommandType = CommandType.StoredProcedure;
                cmdSql2.CommandText = "usp_UpdateQueryStatus";

                cmdSql2.Parameters.Add(pStatus);

                datalayerObj = new DataLayer();
                cmdSql2 = datalayerObj.Update(cmdSql2, connString);
            }

            else
            {
                throw new Exception(errorMessage);
            }
            return adviceObj;
        }