public PartialViewResult EditSample(int?id) { if (id == null) { ViewBag.Error = "Sample Not found"; } sample_detail editSample = db.sample_detail.Find(id); return(PartialView("_EditSample", editSample)); }
public ActionResult DeleteSample(int id) { try { sample_detail sampleToDelete = db.sample_detail.Find(id); db.sample_detail.Remove(sampleToDelete); db.SaveChanges(); }catch (Exception e) { ViewBag.Error = "Error occured. Sample Not found"; } return(View("Samples")); }
public PartialViewResult DeleteSample(int?id) { sample_detail deleteSample = new sample_detail(); if (id == null) { ViewBag.Error = "Sample Not found"; } try { deleteSample = db.sample_detail.Find(id); }catch (Exception e) { ViewBag.Error = "Error occured. Sample Not found"; } return(PartialView("_DeleteSample", deleteSample)); }
public ActionResult EditSample(sample_detail sample) { try { if (ModelState.IsValid) { db.Entry(sample).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { ViewBag.Error = "Check Sample Details.\nGCL ID must be unique values."; } return(View("Samples")); }
public ActionResult UploadFile(HttpPostedFileBase fileIn) { try { if (Request != null) { HttpPostedFileBase file = Request.Files["UploadedFile"]; DataSet ds = new DataSet(); if ((file != null) && (file.ContentLength > 0)) { string fileExtension = System.IO.Path.GetExtension(file.FileName); if (fileExtension == ".xls" || fileExtension == ".xlsx") { string fileName = file.FileName; string fileContentType = file.ContentType; byte[] fileBytes = new byte[file.ContentLength]; var data = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength)); var sampleList = new List <sample_detail>(); using (var package = new ExcelPackage(file.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { var sample = new sample_detail(); sample.project_id = int.Parse(workSheet.Cells[rowIterator, 1].Value.ToString()); sample.gcl_id = workSheet.Cells[rowIterator, 2].Value.ToString(); sample.sample_id = workSheet.Cells[rowIterator, 3].Value.ToString(); sampleList.Add(sample); } foreach (var i in sampleList) { if (ModelState.IsValid) { using (pimsEntitiesNew db = new pimsEntitiesNew()) { sample_detail newsample = new sample_detail(); newsample.project_id = i.project_id; newsample.gcl_id = i.gcl_id; newsample.sample_id = i.sample_id; db.sample_detail.Add(newsample); db.SaveChanges(); } } } ModelState.Clear(); ViewBag.Message = "File data successfully updated!"; } } } } } catch (Exception ex) { ViewBag.Error = "Make sure that GCL ID for samples are unique.\nAll Fields must have values and correct Datatypes."; } return(View("UploadFile")); }