public string AddRequestAccountAve(Guid loanRequestId, RequestAccountAveDto requestAccountAveDto) { try { string accountCode = requestAccountAveDto.AccountCode; LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.Id == loanRequestId); if (loanRequest == null) { return("this request with this Request no :" + requestAccountAveDto.ReqNo.ToString() + " is not there"); } Account account = repository.ActiveContext.BankAccounts.OfType <Account>().FirstOrDefault(a => a.Code == accountCode); if (account == null) { return("account is not found"); } RequestAccountAve requestAccountAve = (RequestAccountAve) new RequestAccountAve().InjectFrom <UnflatLoopValueInjection>(requestAccountAveDto); requestAccountAve.Id = Guid.NewGuid(); requestAccountAve.LoanRequest = loanRequest; requestAccountAve.Account = account; requestAccountAve.Average = GetAverageType(requestAccountAveDto.AverageId, repository); loanRequest.RequestAccountAves = new Collection <RequestAccountAve>(); loanRequest.RequestAccountAves.Add(requestAccountAve); repository.ActiveContext.SaveChanges(); return("record added successfully"); } catch (Exception exception) { return(exception.Message); } }
public LoanRequestDto GetLoanRequest(int reqNo) { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests .Where(lr => lr.ReqNo == reqNo) .FirstOrDefault(); return(loanRequest != null ? (LoanRequestDto) new LoanRequestDto().InjectFrom <UnflatLoopValueInjection>(loanRequest) : null); }
public string RemoveLoanRequest(int reqNo) { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.ReqNo == reqNo); if (loanRequest == null) { return("record not found to be deleted"); } repository.Remove(loanRequest); return(""); }
private int MakeReqNo(LoanRequestRepository repository, int date) { int no = repository.ActiveContext.LoanRequests.Where(lr => lr.LoanRequestDate == date) .Select(lr => lr.ReqNo) .DefaultIfEmpty(0) .Max() + 1; if (no == 1) { no = date * 1000 + 1; } return(no); }
private Average GetAverageType(int averageId, LoanRequestRepository repository) { switch (averageId) { case 0: return(repository.ActiveContext.Averages.OfType <NormAverage>().FirstOrDefault() != null?repository.ActiveContext.Averages.OfType <NormAverage>().FirstOrDefault() : new NormAverage("NormAverage")); case 1: return(repository.ActiveContext.Averages.OfType <AverageWithMin>().FirstOrDefault() != null?repository.ActiveContext.Averages.OfType <AverageWithMin>().FirstOrDefault() : new AverageWithMin("AverageWithMin")); case 2: return(repository.ActiveContext.Averages.OfType <AverageWithHoliday>().FirstOrDefault() != null?repository.ActiveContext.Averages.OfType <AverageWithHoliday>().FirstOrDefault() : new AverageWithHoliday("AverageWithHoliday")); default: return(null); } }
public string AddOrUpdateLoanRequestOkyAssistant(Guid loanRequestId, LoanRequestOkyDto loanRequestOkyDto) { try { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.Id == loanRequestId); if (loanRequest == null) { return("this request with this Request no :" + loanRequestOkyDto.ReqNo.ToString() + " is not there"); } this.TranslateLoanRequestOkyDto(loanRequestOkyDto, loanRequest); repository.Update(loanRequest); return("requestOkyAss added successfully"); } catch (Exception exception) { return(exception.Message); } }
public string UpdaeLoanRequest(LoanRequestDto loanRequestDto) { try { Guid id = loanRequestDto.Id; LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.Where(lr => lr.Id == id).FirstOrDefault(); if (loanRequest == null) { return("request is not there "); } loanRequest.InjectFrom <UnflatLoopValueInjection>(loanRequestDto); repository.Update(loanRequest); return("updated successfully"); } catch (Exception exception) { return(exception.Message); } }
public string AddLoanRequest(LoanRequestDto loanRequestDto) { try { LoanRequestRepository repository = new LoanRequestRepository(); loanRequestDto.ReqNo = MakeReqNo(repository, loanRequestDto.Date); LoanRequest loanRequest = new LoanRequest(); loanRequest.LoanRequestOkyAsistant = new LoanRequestOkyAssistant(); Account account = repository.ActiveContext.BankAccounts.OfType<Account>() .FirstOrDefault(a => a.Code == loanRequestDto.AccountCode); loanRequestDto.Id = Guid.NewGuid(); loanRequest.InjectFrom<UnflatLoopValueInjection>(loanRequestDto); loanRequest.Account = account; repository.Add(loanRequest); return "request added successfully"; } catch (Exception exception) { return exception.Message; } }
public string AddLoanRequest(LoanRequestDto loanRequestDto) { try { LoanRequestRepository repository = new LoanRequestRepository(); loanRequestDto.ReqNo = MakeReqNo(repository, loanRequestDto.Date); LoanRequest loanRequest = new LoanRequest(); loanRequest.LoanRequestOkyAsistant = new LoanRequestOkyAssistant(); Account account = repository.ActiveContext.BankAccounts.OfType <Account>() .FirstOrDefault(a => a.Code == loanRequestDto.AccountCode); loanRequestDto.Id = Guid.NewGuid(); loanRequest.InjectFrom <UnflatLoopValueInjection>(loanRequestDto); loanRequest.Account = account; repository.Add(loanRequest); return("request added successfully"); } catch (Exception exception) { return(exception.Message); } }
public string AddOrUpdateLoanRequestOkyAssistant(Guid loanRequestId, LoanRequestOkyDto loanRequestOkyDto) { try { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.Id == loanRequestId); if (loanRequest == null) return "this request with this Request no :" + loanRequestOkyDto.ReqNo.ToString() + " is not there"; this.TranslateLoanRequestOkyDto(loanRequestOkyDto , loanRequest); repository.Update(loanRequest); return "requestOkyAss added successfully"; } catch (Exception exception) { return exception.Message; } }
private int MakeReqNo(LoanRequestRepository repository, int date) { int no = repository.ActiveContext.LoanRequests.Where(lr => lr.LoanRequestDate == date) .Select(lr => lr.ReqNo) .DefaultIfEmpty(0) .Max() + 1; if (no == 1) no = date * 1000 + 1; return no; }
private Average GetAverageType(int averageId, LoanRequestRepository repository) { switch (averageId) { case 0 : return repository.ActiveContext.Averages.OfType<NormAverage>().FirstOrDefault() != null ? repository.ActiveContext.Averages.OfType<NormAverage>().FirstOrDefault() :new NormAverage("NormAverage"); case 1: return repository.ActiveContext.Averages.OfType<AverageWithMin>().FirstOrDefault() != null ? repository.ActiveContext.Averages.OfType<AverageWithMin>().FirstOrDefault() : new AverageWithMin("AverageWithMin"); case 2: return repository.ActiveContext.Averages.OfType<AverageWithHoliday>().FirstOrDefault() != null ? repository.ActiveContext.Averages.OfType<AverageWithHoliday>().FirstOrDefault() : new AverageWithHoliday("AverageWithHoliday"); default : return null; } }
public string UpdaeLoanRequest(LoanRequestDto loanRequestDto) { try { Guid id = loanRequestDto.Id; LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.Where(lr => lr.Id == id).FirstOrDefault(); if (loanRequest == null) return "request is not there "; loanRequest.InjectFrom<UnflatLoopValueInjection>(loanRequestDto); repository.Update(loanRequest); return "updated successfully"; } catch (Exception exception) { return exception.Message; } }
public string RemoveLoanRequest(int reqNo) { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.ReqNo == reqNo); if (loanRequest == null) return "record not found to be deleted"; repository.Remove(loanRequest); return ""; }
public LoanRequestDto GetLoanRequest(int reqNo) { LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests .Where(lr => lr.ReqNo == reqNo) .FirstOrDefault(); return loanRequest != null ? (LoanRequestDto)new LoanRequestDto().InjectFrom<UnflatLoopValueInjection>(loanRequest) : null; }
public string AddRequestAccountAve(Guid loanRequestId, RequestAccountAveDto requestAccountAveDto) { try { string accountCode = requestAccountAveDto.AccountCode; LoanRequestRepository repository = new LoanRequestRepository(); LoanRequest loanRequest = repository.ActiveContext.LoanRequests.FirstOrDefault(lr => lr.Id == loanRequestId); if (loanRequest == null) return "this request with this Request no :" + requestAccountAveDto.ReqNo.ToString() + " is not there"; Account account = repository.ActiveContext.BankAccounts.OfType<Account>().FirstOrDefault(a => a.Code == accountCode); if (account == null) return "account is not found"; RequestAccountAve requestAccountAve = (RequestAccountAve)new RequestAccountAve().InjectFrom<UnflatLoopValueInjection>(requestAccountAveDto); requestAccountAve.Id = Guid.NewGuid(); requestAccountAve.LoanRequest = loanRequest; requestAccountAve.Account = account; requestAccountAve.Average = GetAverageType(requestAccountAveDto.AverageId ,repository); loanRequest.RequestAccountAves = new Collection<RequestAccountAve>(); loanRequest.RequestAccountAves.Add(requestAccountAve); repository.ActiveContext.SaveChanges(); return "record added successfully"; } catch (Exception exception) { return exception.Message; } }