Esempio n. 1
0
 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);
     }
 }
Esempio n. 2
0
        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);
        }
Esempio n. 3
0
        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("");
        }
Esempio n. 4
0
        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);
        }
Esempio n. 5
0
        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);
            }
        }
Esempio n. 6
0
 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);
     }
 }
Esempio n. 7
0
 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);
     }
 }
Esempio n. 8
0
 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;
     }
 }
Esempio n. 9
0
 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);
     }
 }
Esempio n. 10
0
 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;
     }
 }
Esempio n. 11
0
 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;
 }
Esempio n. 12
0
 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;
     }
 }
Esempio n. 13
0
 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;
     }
 }
Esempio n. 14
0
 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 "";
 }
Esempio n. 15
0
 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;
 }
Esempio n. 16
0
 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;
     }
 }