public void UpdateRecord(Objects.UnitsInfo obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_UnitsInfoUpdate"; cmd.Parameters.AddWithValue("@UnitID", obj.UnitID); cmd.Parameters.AddWithValue("@UnitTitle", obj.UnitTitle); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == string.Empty) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Enter Unit Title."); txtName.Focus(); return; } Objects.UnitsInfo obj = new Objects.UnitsInfo(); obj.UnitID = Int32.Parse(txtID.Text); obj.UnitTitle = txtName.Text.Trim(); if (!vOpenMode) { //Insert obj.UnitID = objDAL.getNextNo(); //obj.AccountID = objAcc.AccountNo; objDAL.InsertRecord(obj); } else { // UPdate objDAL.UpdateRecord(obj); } Message.ShowMessage(MyMessages.MessageType.SaveRecord); LoadGrid(); btnClear_Click(sender, e); } catch (Exception exc) { Message.ShowMessage(MyMessages.MessageType.Error, exc.Message); } }