public ActionResult Get(int?id) { CertificateOfAnalysis cofa = _uow.CofARepository.Get(id); MemoryStream ms = new MemoryStream(cofa.Content, 0, 0, true, true); Response.ContentType = cofa.ContentType; Response.AddHeader("content-disposition", "attachment;filename=" + cofa.FileName); Response.Buffer = true; Response.Clear(); Response.OutputStream.Write(ms.GetBuffer(), 0, ms.GetBuffer().Length); Response.OutputStream.Flush(); Response.End(); return(new FileStreamResult(Response.OutputStream, cofa.ContentType)); }
public ActionResult ViewPDF(int?id, string type) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } CertificateOfAnalysis cofa = null; MSDS msds = null; byte[] fileBuffer = null; switch (type) { case "CofA": cofa = _uow.CofARepository.Get(id); fileBuffer = cofa.Content; if (fileBuffer != null) { Response.ContentType = cofa.ContentType; Response.AddHeader("content-length", fileBuffer.Length.ToString()); Response.BinaryWrite(fileBuffer); } break; case "MSDS": msds = _uow.MSDSRepository.Get(id); fileBuffer = msds.Content; if (fileBuffer != null) { Response.ContentType = msds.ContentType; Response.AddHeader("content-length", fileBuffer.Length.ToString()); Response.BinaryWrite(fileBuffer); } break; default: return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError)); } return(View()); }
public ActionResult Edit([Bind(Include = "ReagentId,LotNumber,ExpiryDate,SupplierName,ReagentName,IdCode,Grade,GradeAdditionalNotes")] StockReagentEditViewModel stockreagent, HttpPostedFileBase uploadCofA, HttpPostedFileBase uploadMSDS) { var errors = ModelState.Values.SelectMany(v => v.Errors); if (ModelState.IsValid) { var user = _uow.GetCurrentUser(); var invRepo = _uow.InventoryItemRepository; InventoryItem invItem = invRepo.Get() .Where(item => item.StockReagent != null && item.StockReagent.ReagentId == stockreagent.ReagentId) .FirstOrDefault(); StockReagent updateReagent = invItem.StockReagent; updateReagent.LotNumber = stockreagent.LotNumber; updateReagent.LastModifiedBy = user.UserName; updateReagent.Grade = stockreagent.Grade; updateReagent.GradeAdditionalNotes = stockreagent.GradeAdditionalNotes; updateReagent.ExpiryDate = stockreagent.ExpiryDate; updateReagent.DateModified = DateTime.Today; updateReagent.ReagentName = stockreagent.ReagentName; _uow.StockReagentRepository.Update(updateReagent); //_uow.Commit(); if (uploadCofA != null) { var cofa = new CertificateOfAnalysis() { FileName = uploadCofA.FileName, ContentType = uploadCofA.ContentType, DateAdded = DateTime.Today }; using (var reader = new System.IO.BinaryReader(uploadCofA.InputStream)) { cofa.Content = reader.ReadBytes(uploadCofA.ContentLength); } stockreagent.CertificateOfAnalysis = cofa; //add certificate analysis invItem.CertificatesOfAnalysis.Add(cofa); } if (uploadMSDS != null) { var msds = new MSDS() { FileName = uploadMSDS.FileName, ContentType = uploadMSDS.ContentType, DateAdded = DateTime.Today }; using (var reader = new System.IO.BinaryReader(uploadMSDS.InputStream)) { msds.Content = reader.ReadBytes(uploadMSDS.ContentLength); } stockreagent.MSDS = msds; var msdsRepo = new MSDSRepository(); var oldSDS = msdsRepo.Get() .Where(item => item.InventoryItem.StockReagent != null && item.InventoryItem.StockReagent.ReagentId == stockreagent.ReagentId) .First(); oldSDS.Content = msds.Content; oldSDS.FileName = msds.FileName; oldSDS.ContentType = msds.ContentType; oldSDS.DateAdded = DateTime.Today; msdsRepo.Update(oldSDS); } invItem.SupplierName = stockreagent.SupplierName; invRepo.Update(invItem); _uow.Commit(); return(RedirectToAction("Details", new { id = stockreagent.ReagentId })); } return(View(stockreagent)); }
public ActionResult Topup([Bind(Include = "ReagentId,NewMSDSNotes,NewLotNumber,NewExpiryDate,NewDateReceived,IsExpiryDateBasedOnDays,DaysUntilExpired,CatalogueCode")] StockReagentTopUpViewModel model, HttpPostedFileBase uploadCofA, HttpPostedFileBase uploadMSDS) { var reagent = _uow.StockReagentRepository.Get(model.ReagentId); if (reagent == null) { return(HttpNotFound()); } if (!ModelState.IsValid) { //handle error var errors = ModelState.Values.SelectMany(v => v.Errors); return(View(SetTopupReagent(model, reagent))); } var user = _uow.GetCurrentUser(); var invRepo = _uow.InventoryItemRepository; var department = user.Department; var numOfItems = invRepo.Get().Count(); model.NumberOfBottles = reagent.InventoryItems.Where(item => item.CatalogueCode.Equals(reagent.CatalogueCode)).First().NumberOfBottles; //upload CofA and MSDS if (uploadCofA != null) { var cofa = new CertificateOfAnalysis() { FileName = uploadCofA.FileName, ContentType = uploadCofA.ContentType, DateAdded = DateTime.Today }; using (var reader = new System.IO.BinaryReader(uploadCofA.InputStream)) { cofa.Content = reader.ReadBytes(uploadCofA.ContentLength); } //model.CertificateOfAnalysis = cofa; reagent.InventoryItems.Where(item => item.CatalogueCode.Equals(reagent.CatalogueCode)).First().CertificatesOfAnalysis.Add(cofa); } if (uploadMSDS != null) { var msds = new MSDS() { FileName = uploadMSDS.FileName, ContentType = uploadMSDS.ContentType, DateAdded = DateTime.Today, MSDSNotes = model.MSDSNotes }; using (var reader = new System.IO.BinaryReader(uploadMSDS.InputStream)) { msds.Content = reader.ReadBytes(uploadMSDS.ContentLength); } //model.MSDS = msds; //reagent.InventoryItems.Where(item => item.CatalogueCode.Equals(model.CatalogueCode)).First().MSDS.Add(msds); var msdsRepo = _uow.MSDSRepository; var oldSDS = msdsRepo.Get() .Where(item => item.InventoryItem.StockReagent != null && item.InventoryItem.StockReagent.CatalogueCode == reagent.CatalogueCode) .First(); oldSDS.Content = msds.Content; oldSDS.FileName = msds.FileName; oldSDS.ContentType = msds.ContentType; oldSDS.DateAdded = DateTime.Today; msdsRepo.Update(oldSDS); } //write record(s) to the db var result = CheckModelState.Invalid;//default to invalid to expect the worst //set new propeties to create new entity based on old StockReagent newReagent = null; if (model.NumberOfBottles > 1) { for (int i = 1; i <= model.NumberOfBottles; i++) { newReagent = new StockReagent() { ExpiryDate = model.NewExpiryDate, IdCode = department.Location.LocationCode + "-" + (numOfItems + 1) + "-" + model.NewLotNumber + "/" + i,//append number of bottles LotNumber = model.NewLotNumber, DateCreated = DateTime.Today, CreatedBy = user.UserName, CatalogueCode = reagent.CatalogueCode, Grade = reagent.Grade, GradeAdditionalNotes = reagent.GradeAdditionalNotes, DateModified = null, DaysUntilExpired = model.DaysUntilExpired, LastModifiedBy = null, ReagentName = reagent.ReagentName, //InventoryItems = reagent.InventoryItems, DateOpened = null, DateReceived = model.NewDateReceived }; //reagent.InventoryItems.Add(reagent.InventoryItems.Where(x => x.CatalogueCode.Equals(model.CatalogueCode)).First()); _uow.StockReagentRepository.Create(newReagent); result = _uow.Commit(); //creation wasn't successful - break from loop and let switch statement handle the problem if (result != CheckModelState.Valid) { break; } } } else { newReagent = new StockReagent() { ExpiryDate = model.NewExpiryDate, IdCode = department.Location.LocationCode + "-" + (numOfItems + 1) + "-" + model.NewLotNumber,//only 1 bottle, no need to concatenate LotNumber = model.NewLotNumber, DateCreated = DateTime.Today, CreatedBy = user.UserName, CatalogueCode = reagent.CatalogueCode, Grade = reagent.Grade, GradeAdditionalNotes = reagent.GradeAdditionalNotes, DateModified = null, DaysUntilExpired = model.DaysUntilExpired, LastModifiedBy = null, ReagentName = reagent.ReagentName, InventoryItems = reagent.InventoryItems, DateOpened = null, DateReceived = model.NewDateReceived }; //reagent.InventoryItems.Add(inventoryItem); _uow.StockReagentRepository.Create(newReagent); result = _uow.Commit(); } switch (result) { case CheckModelState.Invalid: ModelState.AddModelError("", "The creation of " + reagent.ReagentName + " failed. Please double check all inputs and try again."); return(View(SetTopupReagent(model, reagent))); case CheckModelState.DataError: ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists please contact your system administrator."); return(View(SetTopupReagent(model, reagent))); case CheckModelState.Error: ModelState.AddModelError("", "There was an error. Please try again."); return(View(SetTopupReagent(model, reagent))); case CheckModelState.Valid: //save pressed return(RedirectToAction("Index")); default: ModelState.AddModelError("", "An unknown error occurred."); return(View(SetTopupReagent(model, reagent))); } }
public ActionResult Create([Bind(Include = "CatalogueCode,MSDSNotes,SupplierName,ReagentName,StorageRequirements,Grade,UsedFor,LotNumber,GradeAdditionalNotes,NumberOfBottles,ExpiryDate,InitialAmount,DateReceived,IsExpiryDateBasedOnDays,DaysUntilExpired,OtherUnitExplained")] StockReagentCreateViewModel model, string[] Unit, HttpPostedFileBase uploadCofA, HttpPostedFileBase uploadMSDS, string submit) { //model isn't valid, return to the form if (!ModelState.IsValid) { return(View(SetStockReagent(model))); } var invRepo = _uow.InventoryItemRepository; //catalogue code must be unique - let's verify bool doesCatalogueCodeExist = invRepo.Get() .Any(item => item.CatalogueCode != null && item.CatalogueCode.Equals(model.CatalogueCode)); if (doesCatalogueCodeExist) { ModelState.AddModelError("", "The Catalogue Code provided is not unique. If the Catalogue Code provided is in fact correct, add the item as a new Lot Number under the existing Catalogue Code."); return(View(SetStockReagent(model))); } //last line of defense for number of bottles if (model.NumberOfBottles == 0) { model.NumberOfBottles = 1; } model.InitialAmountUnits = Unit[0]; if (Unit.Length > 1) { model.InitialAmountUnits += "/" + Unit[1]; } var devicesUsed = Request.Form["Devices"]; var deviceRepo = _uow.DeviceRepository; if (devicesUsed == null) { ModelState.AddModelError("", "You must select a device that was used."); return(View(SetStockReagent(model))); } if (devicesUsed.Contains(",")) { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); model.DeviceTwo = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[1])).FirstOrDefault(); } else { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); } var user = _uow.GetCurrentUser(); var numOfItems = invRepo.Get().Count(); if (uploadCofA != null) { var cofa = new CertificateOfAnalysis() { FileName = uploadCofA.FileName, ContentType = uploadCofA.ContentType, DateAdded = DateTime.Today }; using (var reader = new System.IO.BinaryReader(uploadCofA.InputStream)) { cofa.Content = reader.ReadBytes(uploadCofA.ContentLength); } model.CertificateOfAnalysis = cofa; } if (uploadMSDS != null) { var msds = new MSDS() { FileName = uploadMSDS.FileName, ContentType = uploadMSDS.ContentType, DateAdded = DateTime.Today, MSDSNotes = model.MSDSNotes }; using (var reader = new System.IO.BinaryReader(uploadMSDS.InputStream)) { msds.Content = reader.ReadBytes(uploadMSDS.ContentLength); } model.MSDS = msds; } InventoryItem inventoryItem = new InventoryItem() { CatalogueCode = model.CatalogueCode.ToUpper(), Department = user.Department, UsedFor = model.UsedFor, Type = "Reagent", StorageRequirements = model.StorageRequirements, SupplierName = model.SupplierName, NumberOfBottles = model.NumberOfBottles, InitialAmount = model.InitialAmount.ToString() + " " + model.InitialAmountUnits, OtherUnitExplained = model.OtherUnitExplained, FirstDeviceUsed = model.DeviceOne, SecondDeviceUsed = model.DeviceTwo }; inventoryItem.MSDS.Add(model.MSDS); inventoryItem.CertificatesOfAnalysis.Add(model.CertificateOfAnalysis); //getting the enum result //CheckModelState result = CheckModelState.Invalid;//default to invalid to expect the worst StockReagent reagent = new StockReagent() { LotNumber = model.LotNumber, IdCode = user.Department.Location.LocationCode + "-" + (numOfItems + 1) + "-" + model.LotNumber + "/" + model.NumberOfBottles,//append number of bottles ReagentName = model.ReagentName, Grade = model.Grade, GradeAdditionalNotes = model.GradeAdditionalNotes, DateReceived = model.DateReceived, DateOpened = null, DaysUntilExpired = model.DaysUntilExpired, ExpiryDate = model.ExpiryDate, DateCreated = DateTime.Today, CreatedBy = user.UserName, DateModified = null, CatalogueCode = model.CatalogueCode.ToUpper() }; reagent.InventoryItems.Add(inventoryItem); _uow.StockReagentRepository.Create(reagent); var result = _uow.Commit(); //if (model.NumberOfBottles > 1) { // for (int i = 1; i <= model.NumberOfBottles; i++) { // reagent = new StockReagent() { // LotNumber = model.LotNumber, // IdCode = department.Location.LocationCode + "-" + (numOfItems + 1) + "-" + model.LotNumber + "/" + i,//append number of bottles // ReagentName = model.ReagentName, // Grade = model.Grade, // GradeAdditionalNotes = model.GradeAdditionalNotes, // DateReceived = model.DateReceived, // DateOpened = null, // DaysUntilExpired = model.DaysUntilExpired, // ExpiryDate = model.ExpiryDate, // DateCreated = DateTime.Today, // CreatedBy = user.UserName, // DateModified = null, // CatalogueCode = model.CatalogueCode // }; // reagent.InventoryItems.Add(inventoryItem); // result = repo.Create(reagent); // //creation wasn't successful - break from loop and let switch statement handle the problem // if (result != CheckModelState.Valid) { break; } // } //} else { // reagent = new StockReagent() { // LotNumber = model.LotNumber, // IdCode = department.Location.LocationCode + "-" + (numOfItems + 1) + "-" + model.LotNumber,//only 1 bottle, no need to concatenate // ReagentName = model.ReagentName, // Grade = model.Grade, // GradeAdditionalNotes = model.GradeAdditionalNotes, // DateReceived = model.DateReceived, // DateOpened = null, // DaysUntilExpired = model.DaysUntilExpired, // ExpiryDate = model.ExpiryDate, // DateCreated = DateTime.Today, // CreatedBy = user.UserName, // DateModified = null, // CatalogueCode = model.CatalogueCode // }; // reagent.InventoryItems.Add(inventoryItem); // result = repo.Create(reagent); //} switch (result) { case CheckModelState.Invalid: ModelState.AddModelError("", "The creation of " + reagent.ReagentName + " failed. Please double check all inputs and try again."); return(View(SetStockReagent(model))); case CheckModelState.DataError: ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists please contact your system administrator."); return(View(SetStockReagent(model))); case CheckModelState.Error: ModelState.AddModelError("", "There was an error. Please try again."); return(View(SetStockReagent(model))); case CheckModelState.Valid: if (!string.IsNullOrEmpty(submit) && submit.Equals("Save")) { //save pressed return(RedirectToAction("Index")); } else { //save & new pressed return(RedirectToAction("Create")); } default: ModelState.AddModelError("", "An unknown error occurred."); return(View(SetStockReagent(model))); } }
/* Standard Code */ public static StockStandardCreateViewModel BuildStandard(StockStandardCreateViewModel model, string devicesUsed, string[] AmountUnit, string[] ConcentrationUnit, HttpPostedFileBase uploadCofA, HttpPostedFileBase uploadMSDS, UnitOfWork _uow) { var deviceRepo = _uow.BalanceDeviceRepository; if (model.NumberOfBottles == 0) { model.NumberOfBottles = 1; } if (devicesUsed.Contains(",")) { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); model.DeviceTwo = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[1])).FirstOrDefault(); } else { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); } model.InitialAmountUnits = AmountUnit[0]; model.InitialConcentrationUnits = ConcentrationUnit[0]; if (AmountUnit.Length > 1) { model.InitialAmountUnits += "/" + AmountUnit[1]; } if (ConcentrationUnit.Length > 1) { model.InitialConcentrationUnits += "/" + ConcentrationUnit[1]; } if (uploadCofA != null) { var cofa = new CertificateOfAnalysis() { FileName = uploadCofA.FileName, ContentType = uploadCofA.ContentType, DateAdded = DateTime.Today }; using (var reader = new System.IO.BinaryReader(uploadCofA.InputStream)) { cofa.Content = reader.ReadBytes(uploadCofA.ContentLength); } model.CertificateOfAnalysis = cofa; } if (uploadMSDS != null) { var msds = new MSDS() { FileName = uploadMSDS.FileName, ContentType = uploadMSDS.ContentType, DateAdded = DateTime.Today, MSDSNotes = model.MSDSNotes }; using (var reader = new System.IO.BinaryReader(uploadMSDS.InputStream)) { msds.Content = reader.ReadBytes(uploadMSDS.ContentLength); } model.MSDS = msds; } return(model); }