public void Update(ExecutiveDetailBL oExecutiveBL, SqlConnection Con) { SqlCommand cmd; try { cmd = new SqlCommand("UpdateExec", Con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Flag", oExecutiveBL.Flag); if (oExecutiveBL.ExecId == 0) { cmd.Parameters.AddWithValue("@ExecId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ExecId", oExecutiveBL.ExecId); } cmd.Parameters.AddWithValue("@ExecName", oExecutiveBL.ExecName); cmd.Parameters.AddWithValue("@DesigId", oExecutiveBL.DesigId); cmd.Parameters.AddWithValue("@PhoneRes", oExecutiveBL.PhoneRes); cmd.Parameters.AddWithValue("@Mobile", oExecutiveBL.Mobile); cmd.Parameters.AddWithValue("@Email", oExecutiveBL.Email); cmd.Parameters.AddWithValue("@Address", oExecutiveBL.Address); cmd.Parameters.AddWithValue("@EduQual", oExecutiveBL.EduQual); cmd.Parameters.AddWithValue("@DOB ", oExecutiveBL.DOB); cmd.Parameters.AddWithValue("@Fathername ", oExecutiveBL.Fathername); cmd.Parameters.AddWithValue("@DOJ", oExecutiveBL.DOJ); cmd.Parameters.AddWithValue("@Remarks", oExecutiveBL.Remarks); cmd.ExecuteNonQuery(); } catch (Exception ex) { BsfGlobal.CustomException(ex.Message, ex.StackTrace); } }
public frmDesignation() { InitializeComponent(); oExecutiveDetailBL = new ExecutiveDetailBL(); }
public void UpdateData(ExecutiveDetailBL OExecUpdate, SqlConnection Con) { SqlCommand cmd = new SqlCommand(); }