public void UpdateRecord(Objects.Packings obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_PackingsUpdate"; cmd.Parameters.AddWithValue("@PackingId", obj.PackingId); cmd.Parameters.AddWithValue("@PackingName", obj.PackingName); cmd.Parameters.AddWithValue("@Abbrevation", obj.Abbrevation); 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 Packing Name", "Packing Name"); TxtName.Focus(); return; } Objects.Packings obj = new Objects.Packings(); obj.PackingId = Int32.Parse(txtID.Text); obj.PackingName = TxtName.Text.Trim(); obj.Abbrevation = txtAbbrevation.Text.Trim(); if (!vOpenMode) { obj.PackingId = objDAL.getNextNo(); objDAL.InsertRecord(obj); } else { // UPdate obj.PackingId = Int32.Parse(txtID.Text); objDAL.UpdateRecord(obj); } MessageBox.Show("Record Saved Succesfully", "Save"); CmdClear_Click(sender, e); LoadGrid(); } catch (Exception exc) { MessageBox.Show(exc.Message); } }