private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validation())
{
try
{
dataAcess.BeginTransaction();
VM.DeleteVoucharDetailByMasterId(this.VoucherMasterId, dataAcess);
VM.UpdateVoucharMaster(this.VoucherMasterId, Convert.ToDateTime(dtpVoucher.Value), this.VoucherType, "H", txtNaration.Text, Convert.ToDecimal(txtTotalDebit.Text), Convert.ToDecimal(txtTotalCredit.Text), MainForm.User_Id, DateTime.Now, "", dataAcess);
foreach (DataRow dr in dsMain.Tables["VoucherDetail"].Rows)
{
if (dr.RowState != DataRowState.Deleted)
{
VM.InsertVoucherDetail(VoucherMasterId, "", "", Convert.ToInt32(dr["COAId"]), dr["AccountCode"].ToString(), dr["FlagDC"].ToString(), Convert.ToDecimal(dr["Amount"]), dr["Remarks"].ToString(), dataAcess);
}
}
manageBank.InsertUpdateBankVoucherDetail(BankVoucherDetailId, dtpVoucher.Value, string.Empty, string.Empty, -1, -1, (string.IsNullOrEmpty(txtChequeAmount.Text) ? 0 : Convert.ToDecimal(txtChequeAmount.Text)), dtpCheque.Value, (cmbChequeBank.SelectedIndex > 0 ? Convert.ToInt32(cmbChequeBank.SelectedValue) : -1), txtChequeNumber.Text, ((this.VoucherType == "BR") ? "Receipt" : "Payment"), VoucherMasterId, this.VoucherType, txtBillNo.Text, dtpBillDate.Value, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Voucher Update Successfull", "Record Updated.", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
dataAcess.ConnectionClose();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validation())
{
try
{
int CashCOAId, VendorCOAId = -1;
VendorCOAId = manageAccount.GetCOAIdByCode(txtAccCode.Text); // yeh Creadit hoga yani "C"
CashCOAId = manageAccount.GetCOAIdByCode(txtCashAcc.Text); //yeh Debit hoga yani "D"
if (VendorCOAId <= 0 || CashCOAId <= 0)
{
MessageBox.Show("Error While Save Cash Payment. Account Code or Cash Account is missing", "Account Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (VendorCOAId == CashCOAId)
{
MessageBox.Show("Account Code and Cash Account should not be Same.", "Same Account Restriction", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
VM.DeleteVoucharDetailByMasterId(this.VoucherMasterId, dataAcess);
VM.UpdateVoucharMaster(this.VoucherMasterId, Convert.ToDateTime(dtpVoucher.Value), "CP", "K", txtNaration.Text, Convert.ToDecimal(txtAmount.Text), Convert.ToDecimal(txtAmount.Text), MainForm.User_Id, DateTime.Now.Date, "", dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", "", VendorCOAId, txtAccCode.Text, "C", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", "", CashCOAId, txtCashAcc.Text, "D", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
//int VendorId = Vendor.GetVendorIdByCode(txtVendorCode.Text);
//int VendorLedgerId = Convert.ToInt32(Vendor.GetVendorLedgerByCashPayment(txtCashPaymentCode.Text).Rows[0]["LedgerId"]);
//Vendor.UpdateVendorLedger(VendorLedgerId, VendorId, Convert.ToDateTime(dtpVoucher.Value), "", -1, 0, txtCashPaymentCode.Text, this.VoucherMasterId, Convert.ToDecimal(txtAmount.Text), dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Cash Payment Record Update Successfull.", "Record Updated.", MessageBoxButtons.OK, MessageBoxIcon.Information);
//if (VoucherMasterId > 0)
//{
// LoadVoucher(VoucherMasterId);
//}
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validation())
{
try
{
int BankCOAId, VendorCOAId = -1;
VendorCOAId = manageAccount.GetCOAIdByCode(txtAccCode.Text); // yeh Debit hoga yani "C"
BankCOAId = manageAccount.GetCOAIdByCode(txtBankAcc.Text); //yeh Credit hoga yani "D"
if (VendorCOAId <= 0 || BankCOAId <= 0)
{
MessageBox.Show("Error While Save Bank Payment. Vendor Account or Bank Account is missing", "Account Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (VendorCOAId == BankCOAId)
{
MessageBox.Show("Vendor Account and Bank Account should not be Same.", "Same Account Restriction", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
VM.DeleteVoucharDetailByMasterId(this.VoucherMasterId, dataAcess);
VM.UpdateVoucharMaster(this.VoucherMasterId, Convert.ToDateTime(dtpVoucher.Value), "BP", "H", txtNaration.Text, Convert.ToDecimal(txtAmount.Text), Convert.ToDecimal(txtAmount.Text), MainForm.User_Id, DateTime.Now.Date, "", dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", txtVendorCode.Text, VendorCOAId, txtAccCode.Text, "C", Convert.ToDecimal(txtAmount.Text), "", dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", "", BankCOAId, txtBankAcc.Text, "D", Convert.ToDecimal(txtAmount.Text), "", dataAcess);
manageBank.InsertUpdateBankVoucherDetail(BankVoucherDetailId, dtpVoucher.Value, txtVendorCode.Text, string.Empty, BankId, BankACId, Convert.ToDecimal(txtAmount.Text), dtpCheque.Value, (cmbChequeBank.SelectedIndex > 0 ? Convert.ToInt32(cmbChequeBank.SelectedValue) : -1), txtChequeNumber.Text, "Payment", VoucherMasterId, "BP", "", DateTime.Now, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Bank Payment Updated Successfull", "Record Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (Validation())
{
try
{
int CashCOAId, CustomerCOAId = -1;
CustomerCOAId = manageAccount.GetCOAIdByCode(txtAccCode.Text); // yeh Debit hoga yani "D"
CashCOAId = manageAccount.GetCOAIdByCode(txtCashAcc.Text); //yeh Credit hoga yani "C"
if (CustomerCOAId <= 0 || CashCOAId <= 0)
{
MessageBox.Show("Error While Save Cash Receipt. Customer Account or Cash Account is missing", "Account Missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (CustomerCOAId == CashCOAId)
{
MessageBox.Show("Account Code and Cash Account should not be Same.", "Same Account Restriction", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
dataAcess.BeginTransaction();
if (dataAcess.getDBCommand().Transaction == null)
{
dataAcess.SetDBTransaction();
}
VM.DeleteVoucharDetailByMasterId(this.VoucherMasterId, dataAcess);
VM.UpdateVoucharMaster(this.VoucherMasterId, Convert.ToDateTime(dtpVoucher.Value), "CR", "K", txtNaration.Text, Convert.ToDecimal(txtAmount.Text), Convert.ToDecimal(txtAmount.Text), MainForm.User_Id, DateTime.Now.Date, "", dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", "", CustomerCOAId, txtAccCode.Text, "D", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
VM.InsertVoucherDetail(this.VoucherMasterId, "", "", CashCOAId, txtCashAcc.Text, "C", Convert.ToDecimal(txtAmount.Text), txtRemarks.Text, dataAcess);
dataAcess.TransCommit();
MessageBox.Show("Cash Receipt Updated Successfull", "Record Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearFeilds();
}
catch (SqlException sqlex)
{
dataAcess.TransRollback();
}
catch (Exception ex)
{
}
finally
{
dataAcess.ConnectionClose();
}
}
}
