public void SaveUpdateRecord(DocumentUploadViewModel DocUploadViewModel)
{
Trn_DocUploadDetails tbldocuploaddetails = new Trn_DocUploadDetails();
try
{
//update the data in Charge Details table
foreach (var p in DocUploadViewModel.DocumentUploadList)
{
var Findobject = _context.Trn_DocUploadDetails.Where(x => x.Id == p.ID && x.KycId == DocUploadViewModel.KycId).FirstOrDefault();
if (Findobject != null)
{
Findobject.VerifiedBy = Convert.ToInt32(HttpContext.Current.Session["UserLoginId"]);
Findobject.Status = p.Status;
Findobject.ReasonForRejection = p.ReasonForRejection;
}
//if (p.Status == "Rejected")
//{
// _context.Trn_DocUploadDetails.Remove(Findobject);
//}
}
_context.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveUpdateRecord(ResidenceVerificationVM model)
{
try
{
tblResidenceVerification residenceVerification = new tblResidenceVerification();
residenceVerification.TransactionId = model.TransactionId;
residenceVerification.TransactionDate = Convert.ToDateTime(model.AppliedDate);
residenceVerification.KycId = model.KycId;
residenceVerification.PreSanctionId = model.PreSanctionId;
residenceVerification.DateofVisit = Convert.ToDateTime(model.DateofVisit);
residenceVerification.TimeofVisit = model.TimeofVisit;
residenceVerification.PersonVisitedName = model.PersonVisitedName;
residenceVerification.RelationWithCustomer = model.RelationWithCustomer;
residenceVerification.FamilyMemberDetails = model.FamilyMemberDetails;
residenceVerification.AddressCategory = "02";
residenceVerification.ResidenceCode = model.ResidenceCode;
residenceVerification.BldgHouseName = model.BldgHouseName;
residenceVerification.BldgPlotNo = model.BldgPlotNo;
residenceVerification.Road = model.Road;
residenceVerification.RoomBlockNo = model.RoomBlockNo;
residenceVerification.Landmark = model.Landmark;
residenceVerification.Distance = model.Distance;
residenceVerification.PinCode = model.PinCode;
residenceVerification.ResidingAtThisAddress_Months = model.ResidingAtThisAddress_Months;
residenceVerification.ResidingAtThisAddress_Years = model.ResidingAtThisAddress_Years;
residenceVerification.UserId = model.UserId;
residenceVerification.CreatedBy = model.CreatedBy;
residenceVerification.CreatedDate = DateTime.Now;
residenceVerification.Comments = model.Comments;
residenceVerification.IsActive = true;
_context.tblResidenceVerifications.Add(residenceVerification);
_context.SaveChanges();
foreach (var p in model.DocumentUploadList)
{
var docuptrn = 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,
Status = "Pending",
SpecifyOther = p.SpecifyOther,
NameonDocument = p.NameonDocument
};
_context.Trn_DocUploadDetails.Add(docuptrn);
_context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public void SaveUpdateRecord(DocumentUploadViewModel DocUploadViewModel)
{
Trn_DocumentUpload tblDocUpload = new Trn_DocumentUpload();
try
{
string output = Regex.Match(DocUploadViewModel.TransactionNumber, @"\d+").Value;
int trnasid = Convert.ToInt32(output);
DocUploadViewModel.TransactionId = trnasid;
if (DocUploadViewModel.ID <= 0)
{
//save the data in Document Upload Details table
tblDocUpload.TransactionId = DocUploadViewModel.TransactionId;
tblDocUpload.KycId = DocUploadViewModel.KycId;
tblDocUpload.TransactionNumber = DocUploadViewModel.TransactionNumber;
tblDocUpload.DocDate = Convert.ToDateTime(DocUploadViewModel.DocDate);
tblDocUpload.CustomerId = DocUploadViewModel.CustomerId;
tblDocUpload.ApplicationNo = DocUploadViewModel.ApplicationNo;
tblDocUpload.LoanAccountNo = DocUploadViewModel.LoanAccountNo;
tblDocUpload.Comments = DocUploadViewModel.Comments;
tblDocUpload.BranchId = Convert.ToInt32(HttpContext.Current.Session["BranchId"]);
tblDocUpload.CompId = Convert.ToInt32(HttpContext.Current.Session["CompanyId"]);
tblDocUpload.FinancialYearId = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]);
tblDocUpload.RecordCreatedBy = DocUploadViewModel.CreatedBy;
tblDocUpload.RecordCreated = DateTime.Now;
tblDocUpload.RecordUpdatedBy = DocUploadViewModel.UpdatedBy;
tblDocUpload.RecordUpdated = DateTime.Now;
_context.Trn_DocumentUpload.Add(tblDocUpload);
_context.SaveChanges();
foreach (var p in DocUploadViewModel.DocumentUploadList)
{
var docuptrn = new Trn_DocUploadDetails
{
KycId = DocUploadViewModel.KycId,
DocumentTypeId = (int)p.DocumentTypeId,
DocumentId = (int)p.DocumentId,
ExpiryDate = p.ExpiryDate,
FileName = p.FileName,
ContentType = p.FileExtension,
UploadFile = p.UploadDocName,
Status = "Pending",
SpecifyOther = p.SpecifyOther,
NameonDocument = p.NameonDocument
};
_context.Trn_DocUploadDetails.Add(docuptrn);
_context.SaveChanges();
}
}
else
{
//update the data in Charge Details table
var tblDocUploadObj = _context.Trn_DocumentUpload.Where(x => x.DocId == DocUploadViewModel.ID).FirstOrDefault();
//update the data in product rate table
tblDocUploadObj.KycId = DocUploadViewModel.KycId;
tblDocUploadObj.TransactionId = DocUploadViewModel.TransactionId;
tblDocUploadObj.TransactionNumber = DocUploadViewModel.TransactionNumber;
tblDocUploadObj.DocDate = Convert.ToDateTime(DocUploadViewModel.DocDate);
tblDocUploadObj.CustomerId = DocUploadViewModel.CustomerId;
tblDocUploadObj.ApplicationNo = DocUploadViewModel.ApplicationNo;
tblDocUploadObj.LoanAccountNo = DocUploadViewModel.LoanAccountNo;
tblDocUploadObj.Comments = DocUploadViewModel.Comments;
tblDocUploadObj.RecordUpdatedBy = DocUploadViewModel.UpdatedBy;
tblDocUploadObj.RecordUpdated = DateTime.Now;
_context.SaveChanges();
List <Trn_DocUploadDetails> NewDocUploadDetails = new List <Trn_DocUploadDetails>();
//update the data in Charge Details table
foreach (var p in DocUploadViewModel.DocumentUploadList)
{
var FindRateobject = _context.Trn_DocUploadDetails.Where(x => x.Id == p.ID && x.KycId == tblDocUploadObj.KycId).FirstOrDefault();
if (FindRateobject == null)
{
var ratetrnnew = new Trn_DocUploadDetails
{
KycId = DocUploadViewModel.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
{
FindRateobject.KycId = tblDocUploadObj.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 = p.UploadDocName;
FindRateobject.SpecifyOther = p.SpecifyOther;
FindRateobject.NameonDocument = p.NameonDocument;
}
NewDocUploadDetails.Add(FindRateobject);
}
#region product rate 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 == DocUploadViewModel.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
}
}
catch (Exception ex)
{
throw ex;
}
}
