public void SaveRecord(RequestFormViewModel model) { try { TGLKYC_BasicDetails tGLKYC_Basic = _context.TGLKYC_BasicDetails.Where(x => x.KYCID == model.KycId).FirstOrDefault(); if (tGLKYC_Basic != null) { tGLKYC_Basic.KYCDate = Convert.ToDateTime(model.KYCDate); tGLKYC_Basic.ApplicationNo = model.ApplicationNo; tGLKYC_Basic.CustomerID = model.CustomerID; tGLKYC_Basic.ResidenceCode = model.ResidenceCode; tGLKYC_Basic.BldgHouseName = model.BldgHouseName; tGLKYC_Basic.Road = model.Road; tGLKYC_Basic.BldgPlotNo = model.BldgPlotNo; tGLKYC_Basic.RoomBlockNo = model.RoomBlockNo; tGLKYC_Basic.Landmark = model.Landmark; tGLKYC_Basic.Distance = model.Distance; tGLKYC_Basic.PinCode = model.PinCode; tGLKYC_Basic.MobileNo = model.MobileNo; tGLKYC_Basic.EmailID = model.EmailID; tGLKYC_Basic.BranchID = Convert.ToInt32(HttpContext.Current.Session["BranchId"]); tGLKYC_Basic.CmpID = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]); tGLKYC_Basic.FYID = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]); tGLKYC_Basic.UpdatedDate = DateTime.Now; tGLKYC_Basic.UpdatedBy = Convert.ToInt32(HttpContext.Current.Session["UserLoginId"]); tGLKYC_Basic.AddressCategory = "02"; _context.SaveChanges(); foreach (var item in model.Trans_KYCAddresses) { Trans_KYCAddresses trans_KYCAddresses = new Trans_KYCAddresses(); trans_KYCAddresses = _context.Trans_KYCAddresses.Where(x => x.KYCID == model.KycId && x.ID == item.ID).FirstOrDefault(); if (trans_KYCAddresses != null) { trans_KYCAddresses.AddressCategory = item.AddressCategory; trans_KYCAddresses.ResidenceCode = item.ResidenceCode; trans_KYCAddresses.BuildingHouseName = item.BuildingHouseName; trans_KYCAddresses.Road = item.Road; trans_KYCAddresses.BuildingPlotNo = item.BuildingPlotNo; trans_KYCAddresses.RoomBlockNo = item.RoomBlockNo; trans_KYCAddresses.NearestLandmark = item.NearestLandmark; trans_KYCAddresses.Distance_km = item.Distance_km; trans_KYCAddresses.PinCode = item.PinCode; trans_KYCAddresses.CreatedDate = DateTime.Now; trans_KYCAddresses.KYCID = tGLKYC_Basic.KYCID; _context.SaveChanges(); } } List <Trn_DocUploadDetails> NewDocUploadDetails = new List <Trn_DocUploadDetails>(); //update the data in Charge Details table foreach (var p in model.DocumentUploadList) { var FindRateobject = _context.Trn_DocUploadDetails.Where(x => x.Id == p.ID && x.KycId == model.KycId).FirstOrDefault(); if (FindRateobject == null) { var ratetrnnew = new Trn_DocUploadDetails { KycId = model.KycId, DocumentTypeId = (int)p.DocumentTypeId, DocumentId = (int)p.DocumentId, ExpiryDate = p.ExpiryDate, FileName = p.FileName, ContentType = p.FileExtension, UploadFile = p.UploadDocName, SpecifyOther = p.SpecifyOther, NameonDocument = p.NameonDocument, Status = "Pending" }; _context.Trn_DocUploadDetails.Add(ratetrnnew); } else { var uploadfile = _context.Trn_DocUploadDetails.Where(x => x.Id == FindRateobject.Id).Select(x => x.UploadFile).FirstOrDefault(); FindRateobject.KycId = model.KycId; FindRateobject.DocumentTypeId = (int)p.DocumentTypeId; FindRateobject.DocumentId = (int)p.DocumentId; FindRateobject.ExpiryDate = p.ExpiryDate; FindRateobject.FileName = p.FileName; FindRateobject.ContentType = p.FileExtension; FindRateobject.UploadFile = uploadfile; FindRateobject.SpecifyOther = p.SpecifyOther; FindRateobject.NameonDocument = p.NameonDocument; } NewDocUploadDetails.Add(FindRateobject); } #region doc details remove //take the loop of table and check from list if found in list then not remove else remove from table itself var trnobjlist = _context.Trn_DocUploadDetails.Where(x => x.KycId == model.KycId).ToList(); if (trnobjlist != null) { foreach (Trn_DocUploadDetails item in trnobjlist) { if (NewDocUploadDetails.Contains(item)) { continue; } else { _context.Trn_DocUploadDetails.Remove(item); } } _context.SaveChanges(); } #endregion product trn remove var requestform = new Trn_RequestForm { KycId = model.KycId, SanctionId = model.SanctionId, creationdate = DateTime.Now }; _context.Trn_RequestForm.Add(requestform); _context.SaveChanges(); } } catch (Exception e) { throw e; } }
/// <summary> /// Save kyc /// </summary> /// <param name="model"></param> public void SaveRecord(KYCBasicDetailsVM model) { try { TGLKYC_BasicDetails tGLKYC_Basic = new TGLKYC_BasicDetails(); if (model != null) { int kycId = _context.TGLKYC_BasicDetails .Where(x => x.CustomerID == model.CustomerID) .OrderByDescending(x => x.AppliedDate) .Select(x => x.KYCID).FirstOrDefault(); if (kycId == 0) { _context.TGLKYC_BasicDetails.Add(tGLKYC_Basic); tGLKYC_Basic.CreatedBy = model.CreatedBy; tGLKYC_Basic.CreatedDate = DateTime.Now; model.KYCID = kycId; } else { tGLKYC_Basic = _context.TGLKYC_BasicDetails.Where(x => x.KYCID == kycId && x.isActive == true).FirstOrDefault(); model.KYCID = tGLKYC_Basic.KYCID; int count = _context.SP_SaveKYCHistory(model.KYCID); } tGLKYC_Basic.AddressCategory = "02"; tGLKYC_Basic.KycType = model.KycType; tGLKYC_Basic.Age = Convert.ToInt32(model.Age); tGLKYC_Basic.AppliedDate = Convert.ToDateTime(model.AppliedDate); tGLKYC_Basic.AppFName = model.AppFName; tGLKYC_Basic.AppMName = model.AppMName; tGLKYC_Basic.AppLName = model.AppLName; tGLKYC_Basic.AppPhoto = model.ApplicantPhoto; tGLKYC_Basic.ImageName = model.ImageName; tGLKYC_Basic.ContentType = model.ContentType; tGLKYC_Basic.BirthDate = Convert.ToDateTime(model.BirthDate); tGLKYC_Basic.BldgHouseName = model.BldgHouseName; tGLKYC_Basic.BldgPlotNo = model.BldgPlotNo; tGLKYC_Basic.BranchID = model.BranchID; tGLKYC_Basic.CmpID = model.CmpID; tGLKYC_Basic.CustomerID = model.CustomerID; tGLKYC_Basic.Designation = model.Designation; tGLKYC_Basic.EmailID = model.EmailID; tGLKYC_Basic.ExistingPLCaseNo = model.ExistingPLCaseNo; tGLKYC_Basic.FYID = model.FYID; tGLKYC_Basic.Gender = model.Gender; tGLKYC_Basic.IndustriesType = model.IndustriesType; tGLKYC_Basic.isActive = true; tGLKYC_Basic.Landmark = model.Landmark; tGLKYC_Basic.MaritalStatus = model.MaritalStatus; tGLKYC_Basic.MobileNo = model.MobileNo; tGLKYC_Basic.NomAddress = model.NomAddress; tGLKYC_Basic.NomFName = model.NomFName; tGLKYC_Basic.NomLName = model.NomLName; tGLKYC_Basic.NomMName = model.NomMName; tGLKYC_Basic.NomRelation = model.NomRelation; tGLKYC_Basic.Occupation = model.Occupation; tGLKYC_Basic.OperatorID = model.CreatedBy; tGLKYC_Basic.OrganizationName = model.OrganizationName; tGLKYC_Basic.PANNo = model.PANNo; tGLKYC_Basic.PresentIncome = model.PresentIncome; tGLKYC_Basic.Road = model.Road; tGLKYC_Basic.RoomBlockNo = model.RoomBlockNo; tGLKYC_Basic.SourceofApplicationID = Convert.ToInt32(model.SourceofApplicationID); tGLKYC_Basic.Spouse = model.Spouse; tGLKYC_Basic.TelephoneNo = model.TelephoneNo; tGLKYC_Basic.UpdatedBy = model.UpdatedBy; tGLKYC_Basic.UpdatedDate = DateTime.Now; tGLKYC_Basic.KYCDate = DateTime.Now; tGLKYC_Basic.AdhaarNo = model.AdhaarNo; tGLKYC_Basic.ApplicationNo = model.ApplicationNo; tGLKYC_Basic.ApplicantPrefix = model.ApplicantPrefix; tGLKYC_Basic.MotherName = model.MotherName; tGLKYC_Basic.Father_Spouse = model.Father_Spouse; tGLKYC_Basic.CKYCNo = model.CKYCNo; tGLKYC_Basic.OccupationOther = model.OccupationOther; tGLKYC_Basic.IndustryOther = model.IndustryOther; tGLKYC_Basic.NomineeMobileNo = model.NomineeMobileNo; tGLKYC_Basic.NomineePanNo = model.NomineePanNo; tGLKYC_Basic.NomineeAdharNo = model.NomineeAdharNo; tGLKYC_Basic.PinCode = model.PinCode; tGLKYC_Basic.Distance = model.Distance; tGLKYC_Basic.ResidenceCode = model.ResidenceCode; tGLKYC_Basic.FatherPrefix = model.FatherPrefix; tGLKYC_Basic.CibilGender = model.Gender == 1 ? "F" : "M"; _context.SaveChanges(); int kycid = _context.TGLKYC_BasicDetails.Max(x => x.KYCID); if (model.KYCID == 0) { model.KYCID = kycid; } foreach (var item in model.Trans_KYCAddresses) { Trans_KYCAddresses trans_KYCAddresses = new Trans_KYCAddresses(); trans_KYCAddresses = _context.Trans_KYCAddresses.Where(x => x.ID == item.ID).FirstOrDefault(); if (trans_KYCAddresses == null) { trans_KYCAddresses = new Trans_KYCAddresses(); _context.Trans_KYCAddresses.Add(trans_KYCAddresses); } trans_KYCAddresses.AddressCategory = item.AddressCategory; trans_KYCAddresses.BuildingHouseName = item.BuildingHouseName; trans_KYCAddresses.BuildingPlotNo = item.BuildingPlotNo; trans_KYCAddresses.CreatedDate = DateTime.Now; trans_KYCAddresses.Distance_km = item.Distance_km; trans_KYCAddresses.KYCID = (int)model.KYCID; trans_KYCAddresses.NearestLandmark = item.NearestLandmark; trans_KYCAddresses.PinCode = item.PinCode; trans_KYCAddresses.ResidenceCode = item.ResidenceCode; trans_KYCAddresses.Road = item.Road; trans_KYCAddresses.RoomBlockNo = item.RoomBlockNo; _context.SaveChanges(); } List <Trn_DocUploadDetails> NewDocUploadDetails = new List <Trn_DocUploadDetails>(); foreach (var p in model.DocumentUploadList) { var Findobject = _context.Trn_DocUploadDetails.Where(x => x.Id == p.ID && x.KycId == model.KYCID).FirstOrDefault(); if (Findobject == null) { var trnnew = new Trn_DocUploadDetails { KycId = (int)model.KYCID, DocumentTypeId = (int)p.DocumentTypeId, DocumentId = (int)p.DocumentId, ExpiryDate = p.ExpiryDate, FileName = p.FileName, ContentType = p.FileExtension, UploadFile = p.UploadDocName, SpecifyOther = p.SpecifyOther, NameonDocument = p.NameonDocument, Status = "Pending" }; _context.Trn_DocUploadDetails.Add(trnnew); } else { Findobject.KycId = (int)model.KYCID; Findobject.DocumentTypeId = (int)p.DocumentTypeId; Findobject.DocumentId = (int)p.DocumentId; Findobject.ExpiryDate = p.ExpiryDate; Findobject.FileName = p.FileName; Findobject.ContentType = p.FileExtension; Findobject.UploadFile = p.UploadDocName; Findobject.SpecifyOther = p.SpecifyOther; Findobject.NameonDocument = p.NameonDocument; } NewDocUploadDetails.Add(Findobject); } #region document details remove //take the loop of table and check from list if found in list then not remove else remove from table itself var trnobjlist = _context.Trn_DocUploadDetails.Where(x => x.KycId == model.KYCID).ToList(); if (trnobjlist != null) { foreach (Trn_DocUploadDetails item in trnobjlist) { if (NewDocUploadDetails.Contains(item)) { continue; } else { _context.Trn_DocUploadDetails.Remove(item); } } _context.SaveChanges(); } #endregion document trn remove } } catch (Exception e) { throw e; } }