//--------------------------------------------------------------
// Select and return one UomType related to the passed uomTypeSk
public UomType GetUomTypeBySk(int uomTypeSk)
{
System.Console.WriteLine("--------------------------------GetUomTypeBySk(1)--------------------------------");
UomType uomType = (from u in dbContext.UomType
where u.UomTypeSk == uomTypeSk
select u)
.FirstOrDefault();
return(uomType);
}
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 UomConversionNewListView(UomConversion uomConversion)
{
System.Console.WriteLine("-----------------------------------Post:UomConversionNewListView(UomConversion uomConversion):1--------------------------------------");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
System.Console.WriteLine("-----------------------------------Post:UomConversionNewListView(UomConversion uomConversion):2--------------------------------------");
UomType uomType = uomTypeHelper.GetUomTypeBySk(uomConversion.UomTypeSk);
string filterText = uomType.UomTypeName;
setLayoutViewBag();
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(filterText);
return(View("UomConversionNewListView", uomConversion));
}
public static Func <string, string, string, Uom> ByAbbrDescrAndTypeName(ISession session)
{
return((abbr, descr, typename) =>
{
using (var tr = session.BeginTransaction())
{
if (abbr.IsNullOrEmpty() || descr.IsNullOrEmpty() || typename.IsNullOrEmpty())
{
return null;
}
UomType type = null;
var q = session.QueryOver <Uom>()
.AndRestrictionOn(w => w.Abbr).IsInsensitiveLike(abbr, MatchMode.Exact)
.AndRestrictionOn(w => w.Description).IsInsensitiveLike(descr, MatchMode.Exact)
.JoinAlias(x => x.Type, () => type)
.AndRestrictionOn(() => type.Title).IsInsensitiveLike(typename, MatchMode.Exact);
return q.SingleOrDefault();
}
});
}
public IActionResult UomConversionNewListView()
{
System.Console.WriteLine("-----------------------------------Get:UomConversionNewListView():1--------------------------------------");
if (HttpContext.Session.GetInt32("LoggedIn") != 1)
{
return(RedirectToAction("Login", "Login"));
}
setLayoutViewBag();
UomConversion uomConversion = new UomConversion {
UomTypeSk = 2, ConversionFactor = 1
};
ViewBag.AllUomConversions = uomConversionHelper.GetUomConversionsByTypeFromToAsc();
ViewBag.AllUomTypes = uomTypeHelper.GetAllUomTypes();
UomType uomType = uomTypeHelper.GetUomTypeBySk(2);
ViewBag.AllUoms = uomHelper.GetAllUomsByUomIdAsc(uomType.UomTypeName);
return(View("UomConversionNewListView", uomConversion));
}
public Uom(Guid id, string name, UomType uomType) : base(id, name)
{
Type = uomType;
}
