public LoanApproval UpdateLoanApproval(LoanApproval LoanApp, LoanApplication LoanApplication) { try { var original = (from a in uvDb.LoanApprovals where a.ID == LoanApp.ID select a).FirstOrDefault(); if (original != null) { //original.LoanComment = LoanApp.LoanComment; original.ApplicationStatus_FK = LoanApp.ApplicationStatus_FK; uvDb.SaveChanges(); } return(original); } catch (Exception ex) { WebLog.Log(ex.Message.ToString()); return(null); } }
public int UpdateLoanApp(LoanApplication LoanApp) { try { var original = (from a in uvDb.LoanApplications where a.LoanRefNumber == LoanApp.LoanRefNumber select a).FirstOrDefault(); if (original != null) { original.LoanComment = LoanApp.LoanComment; original.ApplicationStatus_FK = LoanApp.ApplicationStatus_FK; original.DateModified = LoanApp.DateModified; uvDb.SaveChanges(); } return(original.ID); } catch (Exception ex) { WebLog.Log(ex.Message.ToString()); return(ex.StackTrace.Count()); } }
public int UpdateMyLoanApplication(LoanApplication LoanApp) { try { var original = uvDb.LoanApplications.Find(LoanApp.LoanRefNumber); if (original != null) { original.ApplicationStatus_FK = LoanApp.ApplicationStatus_FK; // original.LoanComment = LoanApp.LoanComment; original.DateModified = LoanApp.DateModified; original.Institution_FK = LoanApp.Institution_FK; //LoanApps.MeansOfIDFilePath = LoanApp.ValueTime; original.AccomodationType_FK = LoanApp.AccomodationType_FK; original.AccountName = LoanApp.AccountName; original.AccountNumber = LoanApp.AccountNumber; original.ApplicantID = LoanApp.ApplicantID; original.ApplicationStatus_FK = LoanApp.ApplicationStatus_FK; original.BankCode = Convert.ToString(LoanApp.BankCode); original.BVN = LoanApp.BVN; original.ClosestBusStop = LoanApp.ClosestBusStop; original.ContactAddress = LoanApp.ContactAddress; //LoanApps.CreatedBy = LoanApp.CreatedBy; //Change To User ID original.DateCreated = LoanApp.DateCreated; original.DateModified = LoanApp.DateModified; original.DateOfBirth = Convert.ToString(LoanApp.DateOfBirth); original.EmailAddress = LoanApp.EmailAddress; original.ExistingLoan = LoanApp.ExistingLoan; original.ExistingLoan_NoOfMonthsLeft = LoanApp.ExistingLoan_NoOfMonthsLeft; original.ExistingLoan_OutstandingAmount = LoanApp.ExistingLoan_OutstandingAmount; original.Firstname = LoanApp.Firstname; original.Gender_FK = LoanApp.Gender_FK; original.IdentficationNumber = LoanApp.IdentficationNumber; original.Landmark = LoanApp.Landmark; original.LGA_FK = LoanApp.LGA_FK; original.LoanAmount = LoanApp.LoanAmount; original.LoanComment = ""; original.LoanRefNumber = LoanApp.LoanRefNumber; original.LoanTenure = LoanApp.LoanTenure; original.MaritalStatus_FK = LoanApp.MaritalStatus_FK; original.MeansOfID_FK = LoanApp.MeansOfID_FK; original.NOK_EmailAddress = LoanApp.NOK_EmailAddress; original.NOK_FullName = LoanApp.NOK_FullName; original.NOK_HomeAddress = LoanApp.NOK_HomeAddress; original.NOK_PhoneNumber = LoanApp.NOK_PhoneNumber; original.NOK_Relationship = LoanApp.NOK_Relationship; original.Organization = LoanApp.Organization; original.Othernames = LoanApp.Othernames; original.PhoneNumber = LoanApp.PhoneNumber; original.RepaymentMethod_FK = LoanApp.RepaymentMethod_FK; original.StateofResidence_FK = LoanApp.StateofResidence_FK; original.Surname = LoanApp.Surname; original.Title_FK = LoanApp.Title_FK; original.IsVisible = 1; original.ValueDate = LoanApp.ValueDate; //MyUtility.getCurrentLocalDateTime().ToString("yyyy/MM/dd"), original.ValueTime = LoanApp.ValueTime; // original.ApplicationStatus_FK = LoanApp.ApplicationStatus_FK; uvDb.SaveChanges(); } return(original.ID); } catch (Exception ex) { WebLog.Log(ex.Message.ToString()); return(0); } }