public bool Insert(LoanRequestVM loanrequestVM) { var push = new LoanRequest(loanrequestVM); if (push != null) { var getUser = applicationcontext.Users.SingleOrDefault(x => x.IsDelete == false && x.Id == loanrequestVM.UserId); push.User = getUser; applicationcontext.LoanRequests.Add(push); var result = applicationcontext.SaveChanges(); return(result > 0); } else { return(false); } }
public bool Update(int id, LoanRequestVM loanrequestVM) { var get = Get(id); if (get != null) { var getUser = applicationcontext.Users.SingleOrDefault(x => x.IsDelete == false && x.Id == loanrequestVM.UserId); get.User = getUser; get.Update(loanrequestVM); applicationcontext.Entry(get).State = EntityState.Modified; var result = applicationcontext.SaveChanges(); return(result > 0); } else { return(false); } }
public bool Update(int id, LoanRequestVM loanrequestVM) { return(iloanrequestrepository.Update(id, loanrequestVM)); }
// categoryVM adalah object public bool Insert(LoanRequestVM loanrequestVM) { return(iloanrequestrepository.Insert(loanrequestVM)); }
public void Update(LoanRequestVM loanrequestVM) { this.Date = loanrequestVM.Date; this.Status = loanrequestVM.Status; this.UpdateDate = DateTimeOffset.Now.LocalDateTime; }
public LoanRequest(LoanRequestVM loanrequestVM) { this.Date = loanrequestVM.Date; this.Status = loanrequestVM.Status; this.CreateDate = DateTimeOffset.Now.LocalDateTime; }
public async Task <IActionResult> AssignLoan([FromForm] LoanRequestVM loanrequest) { List <CustomerLoanDocumentDtl> lstLoanDocument = new List <CustomerLoanDocumentDtl>(); string folderName = "CustomerDoc"; var currentUser = HttpContext.User; Int32 userId = Convert.ToInt32(currentUser.Claims.FirstOrDefault(c => c.Type == "user_id").Value); try { CustomerLoan objCustomerLoan = new CustomerLoan(); var loan = JsonConvert.DeserializeObject <LoadDetailVM>(loanrequest.loandetail); if (loan != null) { objCustomerLoan = _mapper.Map <CustomerLoan>(loan); objCustomerLoan.CreatedBy = userId; objCustomerLoan.AgentId = userId; objCustomerLoan.CreatedDate = DateTime.Now; _context.CustomerLoan.Add(objCustomerLoan); _context.SaveChanges(); #region CustomerLoanTxn if (loan.lsttenure != null && loan.lsttenure.Count > 0) { if (objCustomerLoan.CustomerLoanId > 0) { List <CustomerLoanTxn> lstCustomerLoanTxn = new List <CustomerLoanTxn>(); lstCustomerLoanTxn = _mapper.Map <List <CustomerLoanTxn> >(loan.lsttenure); foreach (var tenure in lstCustomerLoanTxn) { tenure.CreatedBy = userId; tenure.CreatedDate = DateTime.Now; tenure.CustomerLoanId = objCustomerLoan.CustomerLoanId; _context.CustomerLoanTxn.Add(tenure); _context.SaveChanges(); } } } #endregion #region AgentBalanceMst AgentBalanceMst objAgentBalanceMst = _context.AgentBalanceMst.FirstOrDefault(x => x.AgentId == userId); if (objAgentBalanceMst != null) { objAgentBalanceMst.Lb = objAgentBalanceMst.Lb - loan.LoanAmount; objAgentBalanceMst.UpdatedBy = userId; objAgentBalanceMst.UpdatedDate = DateTime.Now; _context.Entry(objAgentBalanceMst).State = EntityState.Modified; _context.SaveChanges(); } #endregion #region Upload Customer Loan Doc if (loanrequest.uploadDoc != null) { foreach (var file in loanrequest.uploadDoc) { CustomerLoanDocumentDtl docDtl = new CustomerLoanDocumentDtl(); if (file.filedata == null && !string.IsNullOrEmpty(file.Filename)) { //return BadRequest("Empty File"); docDtl.CustomerLoanId = objCustomerLoan.CustomerLoanId; docDtl.DocumentTypeId = file.DocType; docDtl.FileName = file.Filename; docDtl.UploadedDate = DateTime.Now; docDtl.UploadedBy = userId; lstLoanDocument.Add(docDtl); } else if (file.filedata != null) { //if (file.Length > 2 * 1024 * 1024) return BadRequest("Max file size exceeded."); string webRootPath = _hostingEnvironment.WebRootPath; string uploadFilesPath = Path.Combine(webRootPath, folderName); if (!Directory.Exists(uploadFilesPath)) { Directory.CreateDirectory(uploadFilesPath); } var fileName = Path.GetFileNameWithoutExtension(file.filedata.FileName) + "-" + Guid.NewGuid().ToString() + Path.GetExtension(file.filedata.FileName); var filePath = Path.Combine(uploadFilesPath, fileName); using (var stream = new FileStream(filePath, FileMode.Create)) { await file.filedata.CopyToAsync(stream); } docDtl.CustomerLoanId = objCustomerLoan.CustomerLoanId; docDtl.DocumentTypeId = file.DocType; docDtl.FileName = fileName; docDtl.UploadedDate = DateTime.Now; docDtl.UploadedBy = userId; lstLoanDocument.Add(docDtl); } else { break; } } _context.CustomerLoanDocumentDtl.AddRange(lstLoanDocument); _context.SaveChanges(); } #endregion } } catch (Exception ex) { return(StatusCode((int)HttpStatusCode.ExpectationFailed)); } return(Ok(new { success = true })); }