public bool UpdateBankAccountTransaction(BankAccountTransactionDTO baDTO) { var flag = true; try { using (var entities = new ManiMotorsEntities1()) { var bTran = entities.BankAccountTransactions.FirstOrDefault(g => g.BankAccountTransactionID == baDTO.BankAccountTransactionID); bTran.BankAccountTransactionID = baDTO.BankAccountTransactionID; bTran.BankAccountTypeID = baDTO.BankAccountTypeID; bTran.TransactionType = baDTO.TransactionType; bTran.Amount = baDTO.Amount; bTran.TransactionDate = baDTO.TransactionDate; bTran.Description = baDTO.Description; bTran.CreatedDate = baDTO.CreatedDate; bTran.Createdby = baDTO.CreatedBy; bTran.Modifiedby = baDTO.ModifiedBy; bTran.ModifiedDate = baDTO.ModifiedDate; bTran.Type = baDTO.Type; entities.SaveChanges(); flag = true; } } catch (Exception ex) { flag = false; throw ex; } return(flag); }
public bool AddBankAccountTransaction(BankAccountTransactionDTO baDTO) { var flag = true; try { using (var entities = new ManiMotorsEntities1()) { var bTran = new BankAccountTransaction() { BankAccountTypeID = baDTO.BankAccountTypeID, TransactionType = baDTO.TransactionType, Amount = baDTO.Amount, Description = baDTO.Description, TransactionDate = baDTO.TransactionDate, CreatedDate = baDTO.CreatedDate, Createdby = baDTO.CreatedBy, Modifiedby = baDTO.ModifiedBy, ModifiedDate = baDTO.ModifiedDate, Type = baDTO.Type, }; entities.BankAccountTransactions.Add(bTran); entities.SaveChanges(); flag = true; } } catch (Exception ex) { flag = false; throw ex; } return(flag); }
private void btnSave_Click(object sender, EventArgs e) { if (validate()) { //Populate ExpenseTransactionDTO var bnk = (ComboboxItem)ddlBankAccount.SelectedItem; var Amount = txtAmount.Text; var Comments = txtComments.Text; BankAccountTransactionDTO bDTO = new BankAccountTransactionDTO(); bDTO.BankAccountTypeID = Convert.ToInt32(bnk.Value); bDTO.Description = Comments; bDTO.Amount = Convert.ToInt32(Amount); bDTO.TransactionType = ddlTranType.Text; bDTO.TransactionDate = Convert.ToDateTime(dtTranDate.Text); bDTO.CreatedBy = GlobalSetup.Userid; bDTO.CreatedDate = DateTime.Now; bDTO.ModifiedDate = null; bDTO.ModifiedBy = null; bDTO.Type = ddlType.Text; BankTransactionBL obj = new BankTransactionBL(); bool result = false; if (_mode == "EDIT") { bDTO.BankAccountTransactionID = _bankTransactionID; result = obj.UpdateBankAccountTransaction(bDTO); } else { result = obj.AddBankAccountTransaction(bDTO); } if (result) { MyMessageBox.ShowBox("Bank Account Transaction Saved!!!"); } else { MyMessageBox.ShowBox("Bank Account Failed !!!"); } } else { MyMessageBox.ShowBox("Please enter all mandatory fields!!!"); } this.Clear(); }