public void InsertRecordBody(Objects.VoucherBody obj) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_VoucherBodyInsert"; cmd.Parameters.AddWithValue("@VoucherID", obj.VoucherID); cmd.Parameters.AddWithValue("@VoucherType", obj.VoucherType); cmd.Parameters.AddWithValue("@AccountNo", obj.AccountNo); cmd.Parameters.AddWithValue("@Remarks", obj.Remarks); cmd.Parameters.AddWithValue("@Debit", obj.Debit); cmd.Parameters.AddWithValue("@Credit", obj.Credit); new Database(connectionstring).ExecuteNonQueryOnly(cmd); } catch (Exception exc) { throw exc; } }
private void btnSave_Click(object sender, EventArgs e) { try { string vMessage = string.Empty; if (cboVoucherType.Text == string.Empty) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Select a Voucher Type"); cboVoucherType.Focus(); return; } if (Grid.Rows.Count == 0) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Please Insert Accounts Information"); txtAccountNo.Focus(); return; } if (getVoucherType() == "JV") { if (txtTotalCredit.Text != txtTotalDebit.Text) { Message.ShowMessage(MyMessages.MessageType.MissingInfo, "Total Debit and Credit not Equal!!! "); txtAccountNo.Focus(); return; } } Objects.VoucherHeader BAL = new Objects.VoucherHeader(); BAL.VoucherID = Int32.Parse(txtVoucherNo.Text); BAL.VoucherDate = dtVoucherDate.Value; BAL.VoucherType = getVoucherType(); BAL.Narration = txtNarration.Text; BAL.PrintVoucherType = cboPrintOnVoucher.Text; DAL.Settings obSet = new DAL.Settings(); obSet.connectionstring = objDAL.connectionstring; BAL.IsPosted = Convert.ToBoolean(obSet.GetSettingValue(DAL.Settings.ProSettings.IsAutoPost)); BAL.UserID = vUserID; BAL.EntryDate = DateTime.Now.Date; if (vOpenMode) { objDAL.UpdateRecord(BAL); objDAL.DeleteRecordBody(Int32.Parse(txtVoucherNo.Text), getVoucherType()); } else { objDAL.InsertRecord(BAL); } //Save Detail foreach (DataGridViewRow dr in Grid.Rows) { if (dr.Cells[0].Value != null) { Objects.VoucherBody objBody = new Objects.VoucherBody(); objBody.VoucherID = Int32.Parse(txtVoucherNo.Text); objBody.VoucherType = getVoucherType(); objBody.AccountNo = dr.Cells["AccountNo"].Value.ToString(); objBody.Debit = decimal.Parse(dr.Cells["Debit"].Value.ToString()); objBody.Credit = decimal.Parse(dr.Cells["Credit"].Value.ToString()); objBody.Remarks = dr.Cells["Remarks"].Value.ToString(); objDAL.InsertRecordBody(objBody); } } Message.ShowMessage(MyMessages.MessageType.SaveRecord); PrintVoucher(txtVoucherNo.Text, getVoucherType()); SetMode(false); } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }