public static UN fnGetUN(string id)
{
// fill a json object for View use
using (var db = new EF.CMCSQL03Entities())
{
UN obj = new UN();
var q = (from t in db.tblUN
orderby t.UNID descending
where t.UNNumber == id
select t).FirstOrDefault();
obj.unid = q.UNID;
obj.unnumber = q.UNNumber;
obj.hazardclass = q.HazardClass;
obj.propershippingname = q.ProperShippingName;
obj.nosname = q.NOSName;
obj.labelreq = q.LabelReq;
obj.subclass = q.SubClass;
obj.subsidlabelreq = q.SubSidLabelReq;
obj.packinggroup = q.PackingGroup;
return obj;
}
}
public ActionResult LookupUNSea(string id)
{
UN obj = new UN();
obj = ProductsService.fnGetUN(id);
return Json(obj, JsonRequestBehavior.AllowGet);
}