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)); }