public ViewResult Upload(DocumentUploadViewModel model)
{
if (ModelState.IsValid)
{
string fileFullName = System.IO.Path.GetFileName(model.uploadFile.FileName);
string relativePath = DirectoryPathHelper.GetRelativePath(fileFullName, Server.MapPath);
string absolutePath = Server.MapPath(relativePath);
model.uploadFile.SaveAs(absolutePath);
DocxToPdfHelper.Convert(absolutePath);
Author author = repository.Authors.Single(a => a.Login == UserName);
Document doc = new Document()
{
Author = author, Date = DateTime.Now, Name = model.Name, Url = relativePath
};
repository.AddDocument(doc);
return(View("Message", doc));
}
else
{
return(View());
}
}
public ActionResult Insert(DocumentUploadViewModel objViewModel)
{
try
{
ModelState.Remove("Id");
if (objViewModel.ID == 0)
{
if (InsertData(objViewModel))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
}
else
{
if (InsertData(objViewModel))
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
}
objViewModel.DocumentUploadList = new List <DocumentUploadViewModel>();
ViewBag.DocumentTypeList = new SelectList(dd._context.Mst_DocumentType.ToList(), "Id", "Name");
ViewBag.DocumentList = new SelectList(dd._context.Mst_DocumentMaster.ToList(), "Doc_Id", "Doc_DocumentName");
return(View("DocumentUpload", objViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public DocumentUploadViewModel ToViewModelDocUpload(DocumentUploadViewModel model)
{
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 == model.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 DocumentUploadViewModel ToViewModelDocUpload(List <Trn_DocumentUpload> DocUploadTrnList)
{
var model = new DocumentUploadViewModel
{
TransactionNumber = DocUploadTrnList[0].TransactionNumber,
DocDate = Convert.ToDateTime(DocUploadTrnList[0].DocDate).ToShortDateString(),
CustomerId = DocUploadTrnList[0].CustomerId,
ApplicationNo = DocUploadTrnList[0].ApplicationNo,
LoanAccountNo = DocUploadTrnList[0].LoanAccountNo,
ID = DocUploadTrnList[0].TransactionId,
};
List <DocumentUploadViewModel> DocTrnViewModelList = new List <DocumentUploadViewModel>();
foreach (var c in DocUploadTrnList)
{
var TrnViewModel = new DocumentUploadViewModel
{
DocumentTypeId = (int)c.DocumentTypeId,
DocumentTypeName = dd._context.Mst_DocumentType.Where(x => x.Id == c.DocumentTypeId).Select(x => x.Name).FirstOrDefault(),
DocumentName = dd._context.Mst_DocumentMaster.Where(x => x.Doc_Id == c.DocumentId).Select(x => x.Doc_DocumentName).FirstOrDefault(),
DocumentId = (int)c.DocumentId,
ExpiryDate = Convert.ToDateTime(c.ExpiryDate).ToShortDateString(),
UploadDocName = c.FileName,
};
DocTrnViewModelList.Add(TrnViewModel);
}
model.DocumentUploadList = DocTrnViewModelList;
return(model);
}
public ActionResult Insert(DocumentUploadViewModel objViewModel)
{
try
{
ModelState.Remove("Id");
if (objViewModel.ID == 0)
{
if (InsertData(objViewModel))
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(3, JsonRequestBehavior.AllowGet));
}
}
objViewModel.DocumentUploadList = new List <DocumentUploadDetailsVM>();
ViewBag.StatusList = new SelectList(StatusListMethod(), "Value", "Text");
return(View("DocumentVerification", objViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveDocumentInsert_FailDeliverableIDDoesNotExist()
{
bool exceptionCaught = false;
string errorMsg = string.Empty;
string deliverableIdPartialErrorMsg = "Deliverable Id";
//Arrange
DocumentUploadViewModel testDocViewModel = new DocumentUploadViewModel()
{
FileExtension = "1234567890123456789012345", // > 25 chars
DocumentAccessTypeId = 1 //DEPT
};
//Act
try
{
var docManager = new DocumentsManager(mockDocumentService.Object, mockUserService.Object, mockDropDownListService.Object);
docManager.Save(testDocViewModel);
}
catch (Exception ex)
{
exceptionCaught = true;
errorMsg = ex.Message;
}
//Assert
Assert.IsTrue(exceptionCaught);
Assert.IsTrue(errorMsg.Contains(deliverableIdPartialErrorMsg));
}
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;
}
}
// GET: DocumentVerification
public ActionResult DocumentVerification()
{
ButtonVisiblity("Index");
var model = new DocumentUploadViewModel();
model.DocumentUploadList = new List <DocumentUploadDetailsVM>();
ViewBag.StatusList = new SelectList(StatusListMethod(), "Value", "Text");
return(View(model));
}
public async Task <IActionResult> Index(DocumentUploadViewModel model)
{
ViewBag.OcrResult = await _opticalCharacterRecognitionService.AnalyzeImageAsync(model.File);
ViewBag.HandwrittenRecognitionResult = await _handwrittenRecognitionService.AnalyzeImageAsync(model.File);
ViewBag.ResultImages = await _tagAndAnalyzeService.AnalyzeImageAsync(model.File, model.PredictionPercentage);
return(View(model));
}
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 GetAllDocumentUpload()
{
var model = new DocumentUploadViewModel();
model.DocumentUploadList = new List <DocumentUploadDetailsVM>();
var transactionid = _context.Trn_DocumentUpload.Any() ? _context.Trn_DocumentUpload.Max(x => x.TransactionId) + 1 : 1;
model.TransactionNumber = "D0000" + transactionid;
model.DocDate = DateTime.Now.ToShortDateString();
return(model);
}
// GET: DocumentUpload
public ActionResult DocumentUpload()
{
ButtonVisiblity("Index");
var model = new DocumentUploadViewModel();
model.DocumentUploadList = new List <DocumentUploadViewModel>();
ViewBag.DocumentTypeList = new SelectList(dd._context.Mst_DocumentType.ToList(), "Id", "Name");
ViewBag.DocumentList = new SelectList(dd._context.Mst_DocumentMaster.ToList(), "Doc_Id", "Doc_DocumentName");
var transactionid = dd._context.Trn_DocumentUpload.Any() ? dd._context.Trn_DocumentUpload.Max(x => x.TransactionId) + 1 : 1;
model.TransactionNumber = "D0000" + transactionid;
model.DocDate = DateTime.Now.ToShortDateString();
return(View(model));
}
public DocumentUploadViewModel GetCustomerById(int id)
{
//var tblkyc = _context.TGLKYC_BasicDetails.Where(x => x.KYCID == id).FirstOrDefault();
var tblkyc = _context.Database.SqlQuery <DocumentUploadViewModel>("GetKYCDetailsForDocumentById @id", new SqlParameter("@id", id)).FirstOrDefault();
var model = new DocumentUploadViewModel();
model.CustomerId = tblkyc.CustomerId;
model.ApplicationNo = tblkyc.ApplicationNo;
model.LoanAccountNo = tblkyc.LoanAccountNo;
model.DocumentUploadList = new List <DocumentUploadDetailsVM>();
var transactionid = _context.Trn_DocumentUpload.Any() ? _context.Trn_DocumentUpload.Max(x => x.TransactionId) + 1 : 1;
model.TransactionNumber = "D0000" + transactionid;
model.DocDate = DateTime.Now.ToShortDateString();
return(model);
}
public DocumentUploadViewModel SetRecordinEdit(int id)
{
DocumentUploadViewModel documentUploadViewModel = new DocumentUploadViewModel();
//get document upload table
int branchid = Convert.ToInt32(HttpContext.Current.Session["BranchId"]);
int fyid = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]);
var docupload = _context.Trn_DocumentUpload.
Where(x => x.DocId == id &&
x.BranchId == branchid &&
x.FinancialYearId == fyid
).FirstOrDefault();
documentUploadViewModel = ToViewModelDocUpload(docupload);
return(documentUploadViewModel);
}
public bool InsertData(DocumentUploadViewModel DocUploadViewModel)
{
bool retVal = false;
DocUploadViewModel.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
DocUploadViewModel.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
try
{
_documentVerificationService.SaveUpdateRecord(DocUploadViewModel);
retVal = true;
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public DocumentUploadViewModel GetDoumentUploadById(int id)
{
DocumentUploadViewModel documentUploadViewModel = new DocumentUploadViewModel();
int branchid = Convert.ToInt32(HttpContext.Current.Session["BranchId"]);
int fyid = Convert.ToInt32(HttpContext.Current.Session["FinancialYearId"]);
//get document upload table
var docupload = _context.Database.SqlQuery <DocumentUploadViewModel>("GetDocumentUploadById @id,@BranchId,@FYID",
new SqlParameter("@id", id),
new SqlParameter("@BranchId", branchid),
new SqlParameter("@FYID", fyid)
).FirstOrDefault();
documentUploadViewModel = ToViewModelDocUpload(docupload);
return(documentUploadViewModel);
}
public bool InsertData(DocumentUploadViewModel DocUploadViewModel)
{
bool retVal = false;
DocUploadViewModel.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
DocUploadViewModel.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
try
{
DocUploadViewModel.DocumentUploadList = (List <DocumentUploadDetailsVM>)Session["documentupload"];
_documentUploadService.SaveRecord(DocUploadViewModel);
retVal = true;
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ActionResult GetDocUploadDetailsById(int ID)
{
try
{
DocumentUploadViewModel documentUploadViewModel = new DocumentUploadViewModel();
string operation = Session["Operation"].ToString();
//get document upload table
var purchasetrndatalist = dd._context.Trn_DocumentUpload.Where(x => x.TransactionId == ID).ToList();
documentUploadViewModel = ToViewModelDocUpload(purchasetrndatalist);
documentUploadViewModel.operation = operation;
ViewBag.DocumentTypeList = new SelectList(dd._context.Mst_DocumentType.ToList(), "Id", "Name");
ViewBag.DocumentList = new SelectList(dd._context.Mst_DocumentMaster.ToList(), "Doc_Id", "Doc_DocumentName");
return(View("DocumentUpload", documentUploadViewModel));
}
catch (Exception ex)
{
throw ex;
}
}
public List <DocumentUploadViewModel> SetModalList()
{
List <DocumentUploadViewModel> list = new List <DocumentUploadViewModel>();
var model = new DocumentUploadViewModel();
var tablelist = _context.Trn_DocumentUpload.ToList();
foreach (var item in tablelist)
{
model = new DocumentUploadViewModel();
model.KycId = item.KycId;
model.ID = item.DocId;
model.TransactionId = item.TransactionId;
model.TransactionNumber = item.TransactionNumber;
model.DocDate = Convert.ToDateTime(item.DocDate).ToShortDateString();
model.ApplicationNo = item.ApplicationNo;
model.CustomerId = item.CustomerId;
model.LoanAccountNo = item.LoanAccountNo;
list.Add(model);
}
return(list);
}
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 ActionResult GetDocUploadTable(string Operation)
{
Session["Operation"] = Operation;
ButtonVisiblity(Operation);
List <DocumentUploadViewModel> list = new List <DocumentUploadViewModel>();
var model = new DocumentUploadViewModel();
var tablelist = dd._context.Trn_DocumentUpload.ToList().Select(x => x);
foreach (var item in tablelist)
{
model = new DocumentUploadViewModel();
model.ID = item.TransactionId;
model.TransactionId = item.TransactionId;
model.TransactionNumber = item.TransactionNumber;
model.DocDate = Convert.ToDateTime(item.DocDate).ToShortDateString();
model.ApplicationNo = item.ApplicationNo;
model.CustomerId = item.CustomerId;
model.LoanAccountNo = item.LoanAccountNo;
list.Add(model);
}
return(PartialView("_DocumentUploadList", list));
}
public ActionResult GetCustomerById(int KycId)
{
try
{
ButtonVisiblity("Index");
var tblkyc = dd._context.Trans_KYCDetails.Where(x => x.ID == KycId).FirstOrDefault();
var model = new DocumentUploadViewModel();
model.CustomerId = tblkyc.CustomerID;
model.ApplicationNo = tblkyc.ApplicationNo;
model.LoanAccountNo = "1";
ViewBag.DocumentTypeList = new SelectList(dd._context.Mst_DocumentType.ToList(), "Id", "Name");
ViewBag.DocumentList = new SelectList(dd._context.Mst_DocumentMaster.ToList(), "Doc_Id", "Doc_DocumentName");
model.DocumentUploadList = new List <DocumentUploadViewModel>();
var transactionid = dd._context.Trn_DocumentUpload.Any() ? dd._context.Trn_DocumentUpload.Max(x => x.TransactionId) + 1 : 1;
model.TransactionNumber = "D0000" + transactionid;
model.DocDate = DateTime.Now.ToShortDateString();
return(View("DocumentUpload", model));
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> DocumentUpload(DocumentUploadViewModel model)
{
if (!ModelState.IsValid)
{
ViewBag.DocumentTemplates = new SelectList(await unitOfWork.DocumentsTemplateService.GetAllTemplates(), nameof(DocumentTemplate.IdDocumentTemplate), nameof(DocumentTemplate.Name));
return(View(model));
}
var user = await userManager.GetUserAsync(HttpContext.User);
string fileName;
if (model.IsTemplate)
{
var itemsDict = model.Items.ToDictionary(it => it.IdDocumentTemplateItem, it => it.Value);
fileName = model.DocumentName;
await unitOfWork.DocumentsService.AddDocumentFromTemplate(user.Id, model.IdTemplate.Value, fileName, model.Abstract, model.Tags, itemsDict);
}
else
{
var fileData = await fileManager.GetFileBytes(model.File);
fileName = model.File.FileName;
await unitOfWork.DocumentsService.AddDocument(user.Id, fileName, model.Abstract, fileData, model.Tags);
}
unitOfWork.LogsService.Add(user.Id, $"Incarcat document: {fileName}");
await unitOfWork.Commit();
TempData[Notifications.DOCUMENT_UPLOADED] = "Document adaugat cu success.";
return(RedirectToAction("Index", "Home"));
}
public ActionResult Create_HazardousWasteTankClosureCertificate_Document(int organizationId, int CERSID, int fseID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.HazardousWasteTankClosureCertification, ResourceType.HazardousWasteTankClosureCertificate_Document, viewModel, fseID, fserID: 0));
}
public ActionResult Edit_HazardousWasteTankClosureCertificationLocallyRequired_Document(int organizationId, int CERSID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.HazardousWasteTankClosureCertification, ResourceType.HazardousWasteTankClosureCertificationLocallyRequired_Document, viewModel));
}
public ActionResult Edit_AbovegroundPetroleumStorageActDocumentation_Document(int organizationId, int CERSID, int FSEID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.AbovegroundPetroleumStorageTanks, ResourceType.AbovegroundPetroleumStorageActDocumentation_Document, viewModel));
}
public ActionResult Create_AbovegroundPetroleumStorageTanksLocallyRequired_Document(int organizationId, int CERSID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.AbovegroundPetroleumStorageTanks, ResourceType.AbovegroundPetroleumStorageTanksLocallyRequired_Document, viewModel));
}
public ActionResult Edit_FacilityInformationMiscellaneousStateRequired_Document(int organizationId, int CERSID, int FSEID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.FacilityInformation, ResourceType.FacilityInformationMiscellaneousStateRequired_Document, viewModel));
}
public ActionResult Create_FacilityInformationLocallyRequired_Document(int organizationId, int CERSID, DocumentUploadViewModel viewModel)
{
return(Handle_DocumentUploadPost(organizationId, CERSID, SubmittalElementType.FacilityInformation, ResourceType.FacilityInformationLocallyRequired_Document, viewModel));
}
public void SaveUpdateRecord(DocumentUploadViewModel DocUploadViewModel)
{
_documentVerificationRepository.SaveUpdateRecord(DocUploadViewModel);
}
