public int Add(TransactionDTO data) { try { var Context = new DB_SYSBANKEntities(); var oi = new Tbl_Transaction(); oi.IBAN = data.IBAN; oi.FullMoney = data.FullMoney; oi.Fee = data.Fee; oi.Deposit = data.Deposit; oi.Withdraw = data.Withdraw; oi.Balance = data.Balance; oi.PrevBalance = data.PrevBalance; oi.CreateDate = data.CreateDate; oi.CreateBy = data.CreateBy; oi.Req_No = data.Req_No; Context.Tbl_Transaction.Add(oi); int result = Context.SaveChanges(); return(result); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }
public int Update(StatementDTO data) { try { var Context = new DB_SYSBANKEntities(); var oi = Context.Tbl_Statement.FirstOrDefault(i => i.ID == data.ID); if (oi != null) { oi.IBANFrom = data.IBANFrom; oi.IBANTo = data.IBANTo; oi.FullMoney = data.FullMoney; oi.Fee = data.Fee; oi.Deposit = data.Deposit; oi.Withdraw = data.Withdraw; oi.Channel = data.Channel; oi.CreateDate = data.CreateDate; oi.CreateBy = data.CreateBy; oi.Req_No = data.Req_No; } return(Context.SaveChanges()); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }
public int Add(UserDTO data) { try { var Context = new DB_SYSBANKEntities(); var oi = new Tbl_User(); oi.FirstName = data.FirstName; oi.LastName = data.LastName; oi.CitizenID = data.CitizenID; oi.PassportID = data.PassportID; oi.MobileNo = data.MobileNo; oi.EmailAddress = data.EmailAddress; oi.IsActive = data.IsActive; Context.Tbl_User.Add(oi); int result = Context.SaveChanges(); return(result); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }
public int Update(AccountDTO data) { try { var Context = new DB_SYSBANKEntities(); var oi = Context.Tbl_Account.FirstOrDefault(i => i.ID == data.ID); if (oi != null) { oi.User_ID = data.User_ID; oi.IBAN = data.IBAN; oi.TotalBalance = data.TotalBalance; oi.UpdateDate = data.UpdateDate; oi.UpdateBy = data.UpdateBy; oi.IsActive = data.IsActive; } return(Context.SaveChanges()); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }
public int Add(AccountDTO data) { try { var Context = new DB_SYSBANKEntities(); var STM = new Tbl_Statement(); var TRS = new Tbl_Transaction(); var oi = new Tbl_Account(); oi.User_ID = data.User_ID; oi.IBAN = data.IBAN; oi.TotalBalance = data.TotalBalance; oi.UpdateDate = data.UpdateDate; oi.UpdateBy = data.UpdateBy; oi.IsActive = data.IsActive; if (data.TotalBalance != 0 && data.TotalBalance != null) { STM.IBANTo = data.IBAN; STM.FullMoney = data.TotalBalance; STM.Fee = data.TotalBalance * Convert.ToDecimal(0.01); STM.Deposit = data.TotalBalance - STM.Fee; STM.Channel = "Website"; STM.CreateDate = DateTime.Now; string ReqNo = Guid.NewGuid().ToString(); STM.Req_No = ReqNo; TRS.IBAN = data.IBAN; TRS.FullMoney = data.TotalBalance; TRS.Fee = data.TotalBalance * Convert.ToDecimal(0.01); TRS.Deposit = data.TotalBalance - STM.Fee; TRS.Balance = STM.Deposit; TRS.PrevBalance = 0; TRS.CreateDate = DateTime.Now; TRS.Req_No = ReqNo; oi.TotalBalance = data.TotalBalance - STM.Fee; } Context.Tbl_Account.Add(oi); if (data.TotalBalance != 0 && data.TotalBalance != null) { Context.Tbl_Statement.Add(STM); Context.Tbl_Transaction.Add(TRS); } int result = Context.SaveChanges(); return(result); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }
public int Add(StatementDTO data) { try { string ReqNo = Guid.NewGuid().ToString(); var Context = new DB_SYSBANKEntities(); var oi = new Tbl_Statement(); oi.IBANFrom = data.IBANFrom; oi.IBANTo = data.IBANTo; oi.FullMoney = data.FullMoney; oi.Fee = data.Fee; oi.Deposit = data.Deposit; oi.Withdraw = data.Withdraw; oi.Channel = data.Channel; oi.CreateDate = data.CreateDate; oi.CreateBy = data.CreateBy; oi.Req_No = ReqNo; Context.Tbl_Statement.Add(oi); var oiAcc = new Tbl_Account(); var TRST = new Tbl_Transaction(); var TRS = new Tbl_Transaction(); var oiAcc2 = new Tbl_Account(); if (data.IBANFrom != null) { TRS.IBAN = data.IBANFrom; TRS.FullMoney = data.FullMoney; TRS.Withdraw = data.FullMoney; TRS.PrevBalance = data.PrevBalanceFrom; TRS.Balance = TRS.PrevBalance - TRS.FullMoney; TRS.CreateDate = DateTime.Now; TRS.CreateBy = data.CreateBy; TRS.Req_No = ReqNo; Context.Tbl_Transaction.Add(TRS); oiAcc2 = Context.Tbl_Account.FirstOrDefault(i => i.IBAN == data.IBANFrom); if (oiAcc2 != null) { if (oiAcc2.TotalBalance != null) { oiAcc2.TotalBalance = oiAcc2.TotalBalance - TRS.FullMoney; } else { oiAcc2.TotalBalance = TRS.FullMoney; } oiAcc2.UpdateBy = data.CreateBy; oiAcc2.UpdateDate = DateTime.Now; } } if (data.IBANTo != null) { TRST.IBAN = data.IBANTo; TRST.FullMoney = data.FullMoney; TRST.Fee = data.FullMoney * Convert.ToDecimal(0.01); TRST.Deposit = data.FullMoney - TRST.Fee; TRST.PrevBalance = data.PrevBalanceTo; TRST.Balance = TRST.PrevBalance + TRST.Deposit; TRST.CreateBy = data.CreateBy; TRST.CreateDate = DateTime.Now; TRST.Req_No = ReqNo; Context.Tbl_Transaction.Add(TRST); oiAcc = Context.Tbl_Account.FirstOrDefault(i => i.IBAN == data.IBANTo); if (oiAcc != null) { if (oiAcc.TotalBalance != null) { oiAcc.TotalBalance = oiAcc.TotalBalance + TRST.Deposit; } else { oiAcc.TotalBalance = TRST.Deposit; } oiAcc.UpdateBy = data.CreateBy; oiAcc.UpdateDate = DateTime.Now; } } int result = Context.SaveChanges(); return(result); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { var _Name = eve.Entry.Entity.GetType().Name; var State = eve.Entry.State; foreach (var ve in eve.ValidationErrors) { var pName = ve.PropertyName; var Msg = ve.ErrorMessage; } } throw; } catch (Exception ex) { throw; } }