public int UpdateLedger(string IDS, NYSCLoanLedger LoanLedger)
{
try
{
int ID = Convert.ToInt32(IDS);
// LoanLedger.ID = ID;
// var resp = uvDb.NYSCLoanLedgers.Find(LoanLedger.ID);
var resp = uvDb.NYSCLoanLedgers.Find(ID);
if (resp != null)
{
// resp.Credit = resp.Debit;
resp.Debit = LoanLedger.Credit;
resp.PaymentFlag = LoanLedger.PaymentFlag;
uvDb.SaveChanges();
}
return(resp.ID);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(0);
}
}
public NYSCLoanLedger InsertLedgerTransact(string IDS, NYSCLoanLedger LoanLedger, Repayment Lt, float Ampd)
{
try
{
int ID = Convert.ToInt32(IDS);
LoanLedger.ID = ID;
var resp = uvDb.NYSCLoanLedgers.Find(LoanLedger.ID);
if (resp != null)
{
// Lt.colss = resp.ID;
// Lt.cols = instFk;
if (Ampd == 0)
{
Lt.Amount = resp.Credit;
}
else
{
Lt.Amount = Ampd;
}
Lt.Created = MyUtility.getCurrentLocalDateTime();
Lt.Reference = resp.ReferenceNumber;
Lt.LedgerFlag = resp.ID;
uvDb.Repayments.Add(Lt);
uvDb.SaveChanges();
}
return(resp);
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
