public ActionResult ViewJBR() { var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; SearchReportsBillingStatementModels srchBS = new SearchReportsBillingStatementModels(); //srchBS.BillingPeriodList = db.BillingPeriod.SqlQuery("Select * from BillingPeriods").ToList(); var billp = db.BillingPeriod.Where(m => m.groupCode == ZoneGroup).ToList().OrderByDescending(m => m.BillingPeriodId); srchBS.BillingPeriodList = billp.ToList(); return(View("ViewJBR", srchBS)); }
public ActionResult ViewBillingStatement() { SearchReportsBillingStatementModels srchBS = new SearchReportsBillingStatementModels(); srchBS.ZoneGroupList = db.ZoneGroup.SqlQuery("SELECT * FROM ZoneGroups EXCEPT SELECT * FROM ZoneGroups WHERE ZoneGroupName = 'Super User'").ToList(); //srchBS.ZoneList = db.Zone.SqlQuery("Select * from Zones").ToList(); var userid = User.Identity.GetUserId(); string ZoneGroup = context.Users.SingleOrDefault(m => m.Id == userid).ZoneGroup; srchBS.BillingPeriodList = db.BillingPeriod.Where(m => m.groupCode == ZoneGroup).ToList(); srchBS.EnterpriseTypeList = db.Database.SqlQuery <EnterpriseTypes>("SELECT DISTINCT EnterpriseType FROM Companies ORDER BY EnterpriseType ASC").ToList(); srchBS.Companylist = db.Company.SqlQuery("Select * from Companies").ToList(); srchBS.ZoneList = db.Zone.SqlQuery("Select * from Zones").ToList(); return(View("ViewBillingStatement", srchBS)); }