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