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);
}
}
