private List <StatementDTO> GetEmployeeStatement()
{
try
{
decimal _empContrib = int.Parse(rep.SettingLookup("EMPNSSF"));
List <StatementDTO> lst = new List <StatementDTO>();
List <StatementDTO> _ItemTransactions = rep.GetStatementDTOfromvwPayslipDet(employee.EmpNo, _payrollitem.Id);
foreach (StatementDTO item in _ItemTransactions)
{
StatementDTO sDTO = new StatementDTO();
sDTO.date = item.date;
sDTO.Amountin = item.Amountin > 0 ? item.Amountin : 0; //cr
sDTO.Amountout = item.Amountout > 0 ? 0 : item.Amountout; //dr
sDTO.Description = item.Description;
sDTO.Balance = item.Balance;
if (_empContrib != null)
{
sDTO.EmpNSSFContrib = _empContrib;
sDTO.TotalContribs = sDTO.Amountin + sDTO.EmpNSSFContrib;
}
lst.Add(sDTO);
}
return(lst);
}
catch (Exception ex)
{
Utils.ShowError(ex);
return(null);
}
}
public void Create(StatementDTO statementDTO)
{
_database.StatementRepository.Create(new Statement
{
EnrolleeId = statementDTO.EnrolleeId,
SpecialtyId = statementDTO.SpecialtyId,
Priority = statementDTO.Priority
});
_database.Save();
}
public int UpDateStatement(StatementDTO data)
{
try
{
var A = new StatementRepository();
return(A.Update(data));
}
catch (Exception e)
{
throw new FaultException <Exception>(e);
}
}
//table Body details
private void AddTableBodyDetails(StatementDTO det, ref int row, ref int col)
{
row++; col = 1;
string cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, det.date.ToString("dd-MMM-yyyy"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, det.Amountin.ToString("#,##0"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
col++;
cellrangeaddr1 = document.IntAlpha(col) + row;
document.createHeaders(row, col, det.Balance.ToString("#,##0"), cellrangeaddr1, cellrangeaddr1, 0, "WHITE", true, 10, "n");
}
public IHttpActionResult Get(int id)
{
var Statement = _unitOfWork.StatementRepository.GetById(id);
_unitOfWork.Dispose();
if (Statement == null)
{
return(NotFound());
}
StatementDTO Data = Mapper.Map <Statement, StatementDTO>(Statement);
return(Ok(Data));
}
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(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;
}
}
