public bool SP_PERSON_RETIRE_UPD ( string ppr_person_code , string ptitle_code , string pperson_thai_name , string pperson_thai_surname , string pperson_id , string pc_active , string pc_updated_by , string pperson_password , string pperson_email , ref string strMessage ) { bool blnResult = false; SqlConnection oConn = new SqlConnection(); SqlCommand oCommand = new SqlCommand(); SqlDataAdapter oAdapter = new SqlDataAdapter(); try { oConn.ConnectionString = _strConn; oConn.Open(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "sp_PERSON_RETIRE_UPD"; oCommand.Parameters.Add("pr_person_code", SqlDbType.VarChar).Value = ppr_person_code; oCommand.Parameters.Add("title_code", SqlDbType.VarChar).Value = ptitle_code; oCommand.Parameters.Add("person_thai_name", SqlDbType.VarChar).Value = pperson_thai_name; oCommand.Parameters.Add("person_thai_surname", SqlDbType.VarChar).Value = pperson_thai_surname; oCommand.Parameters.Add("person_id", SqlDbType.VarChar).Value = pperson_id; oCommand.Parameters.Add("c_active", SqlDbType.VarChar).Value = pc_active; oCommand.Parameters.Add("c_updated_by", SqlDbType.VarChar).Value = pc_updated_by; oCommand.Parameters.Add("person_password", SqlDbType.VarChar).Value = Cryptorengine.Encrypt(pperson_password, true); oCommand.Parameters.Add("person_email", SqlDbType.VarChar).Value = pperson_email; // - - - - - - - - - - - - oCommand.ExecuteNonQuery(); blnResult = true; } catch (Exception ex) { strMessage = ex.Message.ToString(); } finally { oConn.Close(); oCommand.Dispose(); oConn.Dispose(); } return(blnResult); }
public bool SP_USER_UPD( string pUserID, string pperson_code, string pLoginName, string pPassword, string pEmail, string puser_group_code, string pStatus, string pRemark, string pc_updated_by, string pbudget_type, ref string strMessage) { bool blnResult = false; SqlConnection oConn = new SqlConnection(); SqlCommand oCommand = new SqlCommand(); SqlDataAdapter oAdapter = new SqlDataAdapter(); try { oConn.ConnectionString = _strConn; oConn.Open(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "sp_USER_UPD"; oCommand.Parameters.Add("puserID", SqlDbType.Int).Value = pUserID; oCommand.Parameters.Add("pperson_code", SqlDbType.VarChar).Value = pperson_code; oCommand.Parameters.Add("ploginname", SqlDbType.VarChar).Value = pLoginName; oCommand.Parameters.Add("ppassword", SqlDbType.VarChar).Value = Cryptorengine.Encrypt(pPassword, true); oCommand.Parameters.Add("pemail", SqlDbType.VarChar).Value = pEmail; oCommand.Parameters.Add("puser_group_code", SqlDbType.VarChar).Value = puser_group_code; oCommand.Parameters.Add("pStatus", SqlDbType.VarChar).Value = pStatus; oCommand.Parameters.Add("pRemark", SqlDbType.VarChar).Value = pRemark; oCommand.Parameters.Add("pUpdatedBy", SqlDbType.VarChar).Value = pc_updated_by; oCommand.Parameters.Add("budget_type", SqlDbType.VarChar).Value = pbudget_type; // - - - - - - - - - - - - oCommand.ExecuteNonQuery(); blnResult = true; } catch (Exception ex) { strMessage = ex.Message.ToString(); } finally { oConn.Close(); oCommand.Dispose(); oConn.Dispose(); } return(blnResult); }