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