private StockReagentCreateViewModel SetStockReagent(StockReagentCreateViewModel model)
{
var units = _uow.UnitRepository.Get();
var devices = _uow.DeviceRepository.Get().ToList();
var userDepartment = _uow.GetUserDepartment();
model.WeightUnits = units.Where(item => item.UnitType.Equals("Weight")).ToList();
model.VolumetricUnits = units.Where(item => item.UnitType.Equals("Volume")).ToList();
model.BalanceDevices = devices.Where(item => item.DeviceType.Equals("Balance") && item.Department == userDepartment && !item.IsArchived).ToList();
model.VolumetricDevices = devices.Where(item => item.DeviceType.Equals("Volumetric") && item.Department == userDepartment && !item.IsArchived).ToList();
model.Department = userDepartment;
return(model);
}
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)));
}
}
