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);
        }
Beispiel #3
0
        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();
        }