public ActionResult UploadedFiles()
{
UploadedFilesViewModel model = new UploadedFilesViewModel();
string studentId = User.Identity.GetUserId();
IEnumerable <StudentFile> studentFiles = context.StudentFiles.Where(m => m.StudentId == studentId).ToList();
model.StudentFiles = studentFiles;
return(View(model));
}
public async Task <ActionResult> Files()
{
string folderPath = System.IO.Path.Combine(Directory.GetCurrentDirectory(), "UploadedInvoices");
UploadedFilesViewModel model = new UploadedFilesViewModel();
model.InvoiceFiles = new List <InvoiceFile>();
var invoicesInSystem = Directory.GetFiles(folderPath);
foreach (string invoiceFile in invoicesInSystem)
{
InvoiceFile newInvoiceFile = new InvoiceFile();
string textInvoice = ReadOrderPDFInvoice(invoiceFile);
var invoiceLines = textInvoice.Split("\n");
newInvoiceFile.FileName = invoiceFile;
newInvoiceFile.InvoiceNumber = invoiceLines.Where(l => l.Contains("Invoice Numbers")).FirstOrDefault();
newInvoiceFile.OrderIds = invoiceLines.Where(l => l.Contains("Order:")).FirstOrDefault();
model.InvoiceFiles.Add(newInvoiceFile);
}
return(View(model));
}
public ActionResult ValidateUploadFile()
{
UploadedFilesViewModel uploadedFilesVM = new UploadedFilesViewModel();
UploadedFiles uploadFilesObj = new UploadedFiles();
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
try
{
AppUA appUA = Session["AppUA"] as AppUA;
// Checking no of files injected in Request object
if (Request.Files.Count > 0)
{
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
if (ValidateFileName(fname) != "success")
{
return(Json(new { Result = "WARNING", Message = "Invalid File, Either filename or filetype mismatch !" }));
}
if (System.IO.File.Exists(Path.Combine(Server.MapPath("~/Content/Uploads/ImportedFiles/"), fname)) == false)
{
uploadedFilesVM.FilePath = ChangeFilePath(fname);
}
else
{
return(Json(new { Result = "ERROR", Message = "File uploaded recently" }));
}
uploadedFilesVM.CommonObj = new CommonViewModel();
uploadedFilesVM.CommonObj.CreatedBy = appUA.UserName;
uploadedFilesVM.CommonObj.CreatedDate = common.GetCurrentDateTime();
uploadedFilesVM.CommonObj.UpdatedBy = appUA.UserName;
uploadedFilesVM.CommonObj.UpdatedDate = common.GetCurrentDateTime();
uploadedFilesVM.FileType = "OtherExpenses";
List <UploadedFiles> uploadedFileList = _importOtherExpensesBusiness.GetAllUploadedFile();
object fileExist = (from i in uploadedFileList where uploadedFilesVM.FilePath.Equals("/Content/Uploads/ImportedFiles/" + i.FilePath) && i.FileStatus.Equals("Successfully Imported") select i).FirstOrDefault();
if (fileExist != null)
{
return(Json(new { Result = "ERROR", Message = "File Already Imported!" }));
}
UploadedFiles uploadedFiles = _importOtherExpensesBusiness.InsertAttachment(Mapper.Map <UploadedFilesViewModel, UploadedFiles>(uploadedFilesVM));
fname = Path.Combine(Server.MapPath("~/Content/Uploads/ImportedFiles/"), fname);
file.SaveAs(fname);
uploadFilesObj = _importOtherExpensesBusiness.ValidateImportData(uploadedFiles, fname);
System.IO.File.Delete(fname);
}
else
{
return(Json(new { Result = "WARNING", Message = "No files selected. Select one and upload" }));
}
int Count = uploadFilesObj.ImportExpenseList != null ? uploadFilesObj.RecordCount - uploadFilesObj.ImportExpenseList.Count : uploadFilesObj.RecordCount;
return(Json(new
{
Result = "OK",
Message = "File Validated Successfully!",
ImportExpenseList = JsonConvert.SerializeObject(uploadFilesObj.ImportExpenseList),
TotalCount = uploadFilesObj.RecordCount,
RemovedCount = uploadFilesObj.RemovedDataCount,
filename = Path.GetFileName(uploadFilesObj.FilePath)
}));
}
catch (Exception ex)
{
System.IO.File.Delete(Server.MapPath("~/Content/Uploads/ImportedFiles/" + file.FileName));
return(Json(new { Result = "EXCEPTION", Message = ex.Message }));
}
}
public ActionResult UploadFile()
{
UploadedFilesViewModel uploadedFilesVM = new UploadedFilesViewModel();
UploadedFiles uploadedFilesObj = new UploadedFiles();
// Get all files from Request object
HttpFileCollectionBase files = Request.Files;
HttpPostedFileBase file = files[0];
try
{
AppUA appUA = Session["AppUA"] as AppUA;
// Checking no of files injected in Request object
if (Request.Files.Count > 0)
{
string fname;
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = file.FileName;
}
if (ValidateFileName(fname) != "success")
{
return(Json(new { Result = "WARNING", Message = "Invalid Filename!" }));
}
if (System.IO.File.Exists(Path.Combine(Server.MapPath("~/Content/Uploads/ImportedFiles/"), fname)) == false)
{
uploadedFilesVM.FilePath = ChangeFilePath(fname);
}
else
{
return(Json(new { Result = "ERROR", Message = "File uploaded recently" }));
}
UploadedFilesViewModel uploadedFiles = Mapper.Map <UploadedFiles, UploadedFilesViewModel>((
from i in _importOtherExpensesBusiness.GetAllUploadedFile()
where uploadedFilesVM.FilePath.Equals("/Content/Uploads/ImportedFiles/" + i.FilePath)
select i).ToArray()[0]
);
uploadedFiles.CommonObj = new CommonViewModel();
uploadedFiles.CommonObj.CreatedBy = appUA.UserName;
uploadedFiles.CommonObj.CreatedDate = common.GetCurrentDateTime();
uploadedFiles.CommonObj.UpdatedBy = appUA.UserName;
uploadedFiles.CommonObj.UpdatedDate = common.GetCurrentDateTime();
fname = Path.Combine(Server.MapPath("~/Content/Uploads/ImportedFiles/"), fname);
file.SaveAs(fname);
uploadedFilesObj = _importOtherExpensesBusiness.ImportDataToDB(Mapper.Map <UploadedFilesViewModel, UploadedFiles>(uploadedFiles), fname);
}
else
{
return(Json(new { Result = "WARNING", Message = "No files selected." }));
}
return(Json(new { Result = "OK",
Message = "File Uploaded Successfully!",
ImportExpenseList = JsonConvert.SerializeObject(uploadedFilesObj.ImportExpenseList),
TotalCount = uploadedFilesObj.RecordCount,
RemovedCount = uploadedFilesObj.RemovedDataCount,
FileName = Path.GetFileName(uploadedFilesObj.FilePath),
TotalAmount = uploadedFilesObj.TotalAmount }));
}
catch (Exception ex)
{
return(Json(new { Result = "EXCEPTION", Message = ex.Message }));
}
}
