public ActionResult Create([Bind(Include = "CatID,BusinessType,BusinessCategory")] BusinessCategoryType businessCategoryType) { if (ModelState.IsValid) { db.BusinessCategoryTypes.Add(businessCategoryType); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(businessCategoryType)); }
public ActionResult Create([Bind(Include = "Date,MLRQ1, MLRQ2, MLRQ3, MLRQ4, MLRQ5,PremisesRef,Officer,GeneralHygieneStatus")] InspectionDetails inspectionDetails) { if (ModelState.IsValid) { db.InspectionDetails.Add(inspectionDetails); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(inspectionDetails)); }
public ActionResult Create([Bind(Include = "Reference,Area,SubArea,Name,SubBuildingNumber,BuildingNumber,BuildingName,StreetName,Townland,Locality,CityTown,County,Postcode,FoodBusinessOperators,BusinessCategory,BusinessType,RiskCategory,Foodofficer")] NationalPremisesRegister nationalPremisesRegister) { if (ModelState.IsValid) { db.NationalPremisesRegister.Add(nationalPremisesRegister); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(nationalPremisesRegister)); }
public ActionResult Create([Bind(Include = "Account,Name,hid")] GLaccounts gLaccounts, int?page, string ipp) { int pageNumber = (page ?? 1); ipp = ipp ?? (string)Session["DefaultItemsPerPage"]; if (ModelState.IsValid) { var mae = Session["itemSelecionado"] as String; hidServices <GLaccounts> hs = new hidServices <GLaccounts>(db); gLaccounts.hid = hs.GetNextSonHid(mae); db.GLaccounts.Add(gLaccounts); db.SaveChanges(); //gLaccounts.InsertNewConta(gLaccounts.Name, mae); ArrayList recolhidas = (ArrayList)Session["ContasCollapsedList"]; var result = db.GLaccounts.OrderBy(c => c.hid).ToList().Where(c => c.IsNotCollapsed(hs, recolhidas)); return(View("Index", result.ToPagedList(pageNumber, int.Parse(ipp)))); } return(View(gLaccounts)); }
public ActionResult Create([Bind(Include = "LeglislationID, Name, ClauseText, NonComplianceText, RemedialActionText, hid")] GLLeglislation gLaccounts, int?page, string ipp) { int pageNumber = (page ?? 1); ipp = ipp ?? (string)Session["DefaultItemsPerPage"]; if (ModelState.IsValid) { var mae = Session["itemSelecionado"] as String; hidServices <GLLeglislation> hs = new hidServices <GLLeglislation>(db); gLaccounts.hid = hs.GetNextSonHid(mae); db.GLLeglislation.Add(gLaccounts); db.SaveChanges(); //gLaccounts.InsertNewConta(gLaccounts.Name, mae); ArrayList recolhidas = (ArrayList)Session["ContasCollapsedList"]; string wc = hs.WhereClause(recolhidas); var result = db.Database.SqlQuery <GLLeglislation>("select * from GLLeglislation where " + wc + " order by hid").ToList(); // Sql server only //var result = db.GLaccounts.OrderBy(c => c.hid).ToList().Where(c => c.IsNotCollapsed(hs, recolhidas)); return(View("Index", result.ToPagedList(pageNumber, int.Parse(ipp)))); } return(View(gLaccounts)); }