private void btnATransactionSave_Click(object sender, EventArgs e)
{
try
{
if (ValidateTransactionFields())
{
accountTransactionService = new AccountTransactionService();
var firId = comboFirm.SelectedValue;
int firmId = Convert.ToInt32(firId);
var accId = comboAccount.SelectedValue;
int accountId = Convert.ToInt32(accId);
string paymetMode = "";
string transactionType = "";
if (rbtnDebit.Checked)
{
transactionType = "Dr";
}
else
{
transactionType = "Cr";
}
if (rbtnCash.Checked)
{
paymetMode = rbtnCash.Text;
}
else
{
paymetMode = rbtnCheque.Text;
if (bankName == "" || chequeNo == "")
{
MessageBox.Show("Bank details is required", Comman.Product_Name, MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
Data.Models.AccountTransaction data = new Data.Models.AccountTransaction();
data.Id = transactionId;
data.TransactionDate = dtTransactionDate.Value;
data.FirmId = firmId;
data.AccountId = accountId;
data.Amount = Convert.ToDecimal(txtAmount.Text);
data.TransactionsType = transactionType;
data.PaymentType = paymetMode;
data.Remarks = txtTransactionRemarks.Text;
Data.Models.ChequeDetail chequeData = new Data.Models.ChequeDetail();
chequeData.BankName = bankName;
//chequeData.IFSCCode = ifscCode;
chequeData.ChequeNo = chequeNo;
chequeData.ChequeDate = chequeDate;
accountTransactionService.SaveTransaction(data, chequeData);
ClearTransactionFieldsData();
GetGirdViewData();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Comman.Product_Name, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void AssignFormFieldsValues(Data.Models.AccountTransaction transactionData)
{
try
{
if (comboFirm.DataSource == null)
{
BindFirmCombo();
}
transactionId = transactionData.Id;
comboFirm.SelectedValue = transactionData.FirmId;
comboAccount.SelectedValue = transactionData.AccountId;
if (transactionData.TransactionsType == "Cr")
{
rbtnCredit.Checked = true;
}
else
{
rbtnDebit.Checked = true;
}
if (transactionData.PaymentType == "Cash")
{
rbtnCash.Checked = true;
}
else
{
IsEditable = true;
ChequeForm frmCheuqe = new ChequeForm();
frmCheuqe.Close();
rbtnCheque.Checked = true;
GetBankDetailsByTransactionById(transactionId);
}
IsPostBack = true;
txtTransactionRemarks.Text = transactionData.Remarks;
dtTransactionDate.Value = transactionData.TransactionDate;
txtAmount.Text = transactionData.Amount.ToString();
gridAccountTransactions.DataSource = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, Comman.Product_Name, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void SaveTransaction(Data.Models.AccountTransaction datamodel, Data.Models.ChequeDetail chequeData)
{
try
{
using (Data.Models.ProAccountContext db = new Data.Models.ProAccountContext())
{
if (datamodel.Id > 0)
{
var existingdata = db.AccountTransactions.FirstOrDefault(W => W.Id == datamodel.Id);
if (existingdata != null)
{
existingdata.FirmId = datamodel.FirmId;
existingdata.AccountId = datamodel.AccountId;
existingdata.TransactionDate = datamodel.TransactionDate;
existingdata.TransactionsType = datamodel.TransactionsType;
existingdata.Amount = datamodel.Amount;
existingdata.PaymentType = datamodel.PaymentType;
existingdata.Remarks = datamodel.Remarks;
}
db.SaveChanges();
if (chequeData != null && datamodel.PaymentType == "Cheque")
{
db.ChequeDetails.Add(new Data.Models.ChequeDetail
{
TransactionId = datamodel.Id,
BankName = chequeData.BankName,
ChequeNo = chequeData.ChequeNo,
IFSCCode = chequeData.IFSCCode,
ChequeDate = chequeData.ChequeDate
});
db.SaveChanges();
}
}
else
{
if (datamodel != null)
{
var transaction = db.AccountTransactions.Add(new Data.Models.AccountTransaction
{
TransactionDate = datamodel.TransactionDate,
FirmId = datamodel.FirmId,
AccountId = datamodel.AccountId,
TransactionsType = datamodel.TransactionsType,
Amount = datamodel.Amount,
PaymentType = datamodel.PaymentType,
Remarks = datamodel.Remarks
});
db.SaveChanges();
if (chequeData != null && datamodel.PaymentType == "Cheque")
{
db.ChequeDetails.Add(new Data.Models.ChequeDetail
{
TransactionId = transaction.Id,
BankName = chequeData.BankName,
ChequeNo = chequeData.ChequeNo,
IFSCCode = chequeData.IFSCCode,
ChequeDate = chequeData.ChequeDate
});
db.SaveChanges();
}
}
}
}
}
catch (SqlException ex)
{
}
}
