public ActionResult UploadNsPartNos(UpldNsPartsImpIModel model, IEnumerable<HttpPostedFileBase> uploadedFiles) { HttpPostedFileBase file = uploadedFiles.IfNotNull(f => f.First()); if (file == null) { ModelState.AddModelError("", "No file was uploaded"); } if (ModelState.IsValid) { model.FileName = file.FileName; model.QtyLoaded = 0; Stream stream = file.InputStream; StreamReader sr = new StreamReader(stream); int partCount = 0; if (model.SkipFirstRow) { sr.ReadLine(); } //PS_TO_NS_PARTNO newPart = new PS_TO_NS_PARTNO(); //newPart.INTERNALID = "1"; //newPart.NS_NAME = "One"; //UtilDBContext.PS_TO_NS_PARTNOS.AddObject(newPart); //UtilDBContext.SaveChanges(); string sql = "DELETE FROM PS_TO_NS_PARTNO"; UtilDBContext.ExecuteStoreCommand(sql); //UtilDBContext.SaveChanges(); int insertCount = 0; insertCount = ReadFileLoadParts(sr); while (insertCount != 0) { partCount = partCount + insertCount; insertCount = ReadFileLoadParts(sr); } //UtilDBContext.SaveChanges(); model.QtyLoaded = partCount; } return View(model); }
public ActionResult UploadNsPartNos() { UpldNsPartsImpIModel model = new UpldNsPartsImpIModel(); return View(model); }