public int Update(UserDTO data)
{
try
{
var Context = new DB_SYSBANKEntities();
var oi = Context.Tbl_User.FirstOrDefault(i => i.ID == data.ID);
if (oi != null)
{
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;
}
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 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;
}
}
