public PartialViewResult ShowPreview(string PlantId, string FARId) { string globalimagepath = ConfigurationManager.AppSettings["globalImagePath"]; FARImageModel obj = new FARImageModel(); if (!string.IsNullOrEmpty(PlantId) && !string.IsNullOrEmpty(FARId)) { PlantAreaMaster master = _dbRepositoryPlant.SelectById(PlantId); FARToBeVerified masterFAR = _dbRepositoryFAR.SelectById(FARId); if (master != null && masterFAR != null) { obj.PlantName = master.PLANT; obj.ImageName = masterFAR.AssetImage; obj.BarcodeImageName = masterFAR.BarCodeImage; if (!string.IsNullOrEmpty(masterFAR.AssetImage)) { string imagePath = string.Format(globalimagepath + "{0}/ComponentImage/{1}", master.PLANT, masterFAR.AssetImage); obj.ImagePath = imagePath; string barcodeImagePath = string.Format(globalimagepath + "{0}/ComponentImage/{1}", master.PLANT, masterFAR.BarCodeImage); obj.BarcodeImagePath = barcodeImagePath; } } } return(PartialView("_Preview", obj)); }
public ActionResult ImportItems(IEnumerable <HttpPostedFileBase> fileImport) { foreach (var item in fileImport) { if (item != null) { var package = new ExcelPackage(item.InputStream); ExcelWorksheet workSheet = package.Workbook.Worksheets[1]; workSheet.TrimLastEmptyRows(); IEnumerable <ExcelImportModel> listFromExcel = GetDataFromExcelStockCheck(workSheet, true); try { foreach (var obj in listFromExcel) { if (!string.IsNullOrEmpty(obj.BA)) { PlantAreaMaster plantAreaMaster = _dbRepositoryPlant.GetEntities().Where(m => m.BA == obj.BA).FirstOrDefault(); if (plantAreaMaster != null) { string plantId = plantAreaMaster.ID; FARToBeVerified farObj = new FARToBeVerified(); farObj.ID = Guid.NewGuid().ToString(); farObj.PlantID = plantId; farObj.AssetIDSubNo = obj.AssetId; farObj.Process = obj.Process; farObj.Product = obj.Product; farObj.Pack = obj.Pack; farObj.EquipmentDetails = obj.EquipmentDetails; farObj.AssetDescription = obj.AssetDescription; farObj.InstallationStatus = obj.InstallationStatus; farObj.Status = "Pending"; farObj.CreatedBy = "2dfadc7a-2026-4976-8161-900cf3eafae5"; farObj.CreatedDate = System.DateTime.Now; farObj.ModifiedBy = "2dfadc7a-2026-4976-8161-900cf3eafae5"; farObj.ModifiedDate = System.DateTime.Now; farObj.EnteredOnMachineID = "DESKTOP-RVA968U"; farObj.ExeVersionNo = "v 1.0.1 22-Oct-2019"; farObj.APSyncModifiedBy = "G"; farObj.SysCreatedDateTime = System.DateTime.Now; farObj.SysModifiedDateTime = System.DateTime.Now; _dbRepositoryFAR.Insert(farObj); } } } } catch (DbEntityValidationException dbEx) { string messages = String.Empty; foreach (DbEntityValidationResult entityErr in dbEx.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { //Console.WriteLine("Error Property Name {0} : Error Message: {1}", // error.PropertyName, error.ErrorMessage); messages = messages + "<br/>" + string.Join("<br/>", error.ErrorMessage); } } } } else { return(RedirectToAction("Index", "ImportData")); } } return(RedirectToAction("Index", "ImportData")); }