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); } }