public void UpdateRecord(Objects.Companies obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_CompaniesUpdate"; cmd.Parameters.AddWithValue("@CompanyID", obj.CompanyID); cmd.Parameters.AddWithValue("@CompanyName", obj.CompanyName); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void CmdSave_Click(object sender, EventArgs e) { try { if (TxtName.Text.Trim() == string.Empty) { MessageBox.Show("Please Enter Company Name", "Company Name"); TxtName.Focus(); return; } Objects.Companies obj = new Objects.Companies(); obj.CompanyID = txtID.Text.ToString(); obj.CompanyName = TxtName.Text.Trim(); if (!vOpenMode) { obj.CompanyID = objDAL.getNextNo().ToString(); objDAL.InsertRecord(obj); } else { // UPdate obj.CompanyID = TxtName.Tag.ToString(); objDAL.UpdateRecord(obj); } CmdClear_Click(sender, e); LoadGrid(); MessageBox.Show("Record Saved Succesfully", "Save"); } catch (Exception exc) { MessageBox.Show(exc.Message); } }