public IActionResult UomNewSave(Uom uom)
{
System.Console.WriteLine("-----------------------------------UomNewSave--------------------------------------");
bool isValid = ModelState.IsValid;
if (isValid)
{
var uomIdInDb = dbContext.Uom.FirstOrDefault(u => u.UomId == uom.UomId);
if (uomIdInDb != null)
{
ModelState.AddModelError("UomId", "Uom Id already exists.");
isValid = false;
}
else
{
var uomNameInDb = dbContext.Uom.FirstOrDefault(u => u.UomName == uom.UomName);
if (uomNameInDb != null)
{
ModelState.AddModelError("UomName", "Uom Name already exists.");
isValid = false;
}
}
}
if (isValid)
{
// Add new Uom
DateTime now = DateTime.Now;
uom.CreatedAt = now;
uom.UpdatedAt = now;
dbContext.Add(uom);
dbContext.SaveChanges();
// Add the 1-1 Uom Conversion row for the new Uom
var uomInDb = dbContext.Uom.FirstOrDefault(u => u.UomId == uom.UomId);
UomConversion uomConversion = new UomConversion {
UomTypeSk = uomInDb.UomTypeSk, ConvertFromUomSk = uomInDb.UomSk, ConvertToUomSk = uomInDb.UomSk, ConversionFactor = 1, CreatedAt = now, UpdatedAt = now
};
dbContext.Add(uomConversion);
dbContext.SaveChanges();
return(RedirectToAction("UomNewListView"));
}
else
{
// New was invalid, route back to Uom New / List view
setLayoutViewBag();
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
return(View("UomNewListView", uom));
}
}
public IActionResult UomConversionNewSave(UomConversion uomConversion)
{
System.Console.WriteLine("-----------------------------------UomConversionNewSave(UomConversion uomConversion):1--------------------------------------");
bool isValid = ModelState.IsValid;
if (isValid)
{
var uomConversionInDb = (from u in dbContext.UomConversion
where u.ConvertFromUomSk == uomConversion.ConvertFromUomSk
where u.ConvertToUomSk == uomConversion.ConvertToUomSk
select u).FirstOrDefault();
if (uomConversionInDb != null)
{
ModelState.AddModelError("ConvertFromUomSK", "From / To Uom conversion already exists.");
isValid = false;
}
}
if (isValid)
{
// Add new UomConversion
DateTime now = DateTime.Now;
uomConversion.CreatedAt = now;
uomConversion.UpdatedAt = now;
dbContext.Add(uomConversion);
dbContext.SaveChanges();
dbContext.SaveChanges();
return(RedirectToAction("UomConversionNewListview"));
}
else
{
System.Console.WriteLine("-----------------------------------UomConversionNewSave(UomConversion uomConversion):2--------------------------------------");
System.Console.WriteLine($"{uomConversion.UomTypeSk}");
// New was invalid, route back to UomConversion New / List view
setLayoutViewBag();
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
UomType uomType = uomTypeHelper.GetUomTypeBySk(uomConversion.UomTypeSk);
System.Console.WriteLine($"{uomType.UomTypeName}");
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(uomType.UomTypeName);
return(View("UomConversionNewListView", uomConversion));
}
}
public IActionResult PaymentTermNewSave(PaymentTerm paymentTerm)
{
System.Console.WriteLine("-----------------------------------PaymentTermNewSave--------------------------------------");
bool isValid = ModelState.IsValid;
if (isValid)
{
var nameInDb = dbContext.PaymentTerm.FirstOrDefault(p => p.Name == paymentTerm.Name);
if (nameInDb != null)
{
ModelState.AddModelError("Name", "Name already exists.");
isValid = false;
}
}
if (isValid)
{
// Add new PaymentTerm
DateTime now = DateTime.Now;
paymentTerm.CreatedAt = now;
paymentTerm.UpdatedAt = now;
dbContext.Add(paymentTerm);
dbContext.SaveChanges();
return(RedirectToAction("PaymentTermNewListView"));
}
else
{
// New was invalid, route back to PaymentTerm New / List view
setLayoutViewBag();
ViewBag.AllPaymentTerms = paymentTermHelper.GetAllPaymentTermsByNameAsc();
return(View("PaymentTermNewListView", paymentTerm));
}
}
