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"));
}
