public bool InsertData(DocumentUploadViewModel DocUploadViewModel)
{
bool retVal = false;
DocUploadViewModel.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
DocUploadViewModel.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
Trn_DocumentUpload tblDocUpload = new Trn_DocumentUpload();
try
{
//chargeViewModel.DocumentUploadList =(List<DocumentUploadViewModel>)Session["DocumentUploadList"];
//save the data in Document Upload Details table
foreach (var p in DocUploadViewModel.DocumentUploadList)
{
//Stream fs = p.UploadedFile.InputStream;
//BinaryReader br = new BinaryReader(fs);
//Byte[] bytes = br.ReadBytes((Int32)fs.Length);
//string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
//Image1.ImageUrl = "data:image/png;base64," + base64String;
int trnasid = Convert.ToInt32(DocUploadViewModel.TransactionNumber);
var docuptrn = new Trn_DocumentUpload
{
TransactionId = 1,
TransactionNumber = DocUploadViewModel.TransactionNumber,
DocDate = Convert.ToDateTime(DocUploadViewModel.DocDate),
CustomerId = DocUploadViewModel.CustomerId,
ApplicationNo = DocUploadViewModel.ApplicationNo,
LoanAccountNo = DocUploadViewModel.LoanAccountNo,
DocumentTypeId = p.DocumentTypeId,
DocumentId = p.DocumentId,
ExpiryDate = Convert.ToDateTime(p.ExpiryDate),
//UploadDocName= bytes,
Comments = DocUploadViewModel.Comments,
BranchId = 1,
FinancialYearId = 1,
CompId = 1,
Status = "P",
RecordCreatedBy = Convert.ToInt32(Session["UserLoginId"]),
RecordCreated = DateTime.Now,
RecordUpdatedBy = Convert.ToInt32(Session["UserLoginId"]),
RecordUpdated = DateTime.Now,
};
dd._context.Trn_DocumentUpload.Add(docuptrn);
dd._context.SaveChanges();
}
retVal = true;
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public DocumentUploadViewModel ToViewModelDocUpload(Trn_DocumentUpload docupload)
{
var model = new DocumentUploadViewModel
{
KycId = docupload.KycId,
TransactionNumber = docupload.TransactionNumber,
DocDate = Convert.ToDateTime(docupload.DocDate).ToShortDateString(),
CustomerId = docupload.CustomerId,
ApplicationNo = docupload.ApplicationNo,
LoanAccountNo = docupload.LoanAccountNo,
TransactionId = docupload.TransactionId,
ID = docupload.DocId,
Comments = docupload.Comments
};
var docuploaddetails = (from a in _context.Trn_DocUploadDetails
join b in _context.Mst_DocumentType on a.DocumentTypeId equals b.Id
join c in _context.tblDocumentMasters on a.DocumentId equals c.DocumentID
where a.KycId == docupload.KycId && a.Status != "Rejected"
select new DocumentUploadDetailsVM()
{
ID = a.Id,
DocumentTypeId = a.DocumentTypeId,
DocumentTypeName = b.Name,
DocumentName = c.DocumentName,
DocumentId = a.DocumentId,
ExpiryDate = a.ExpiryDate,
FileName = a.FileName,
FileExtension = a.ContentType,
KycId = a.KycId,
Status = a.Status,
VerifiedBy = a.VerifiedBy,
SpecifyOther = a.SpecifyOther,
NameonDocument = a.NameonDocument,
ReasonForRejection = a.ReasonForRejection
}).ToList();
model.DocumentUploadList = docuploaddetails;
return(model);
}
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;
}
}
