// GET: Notifications
public ActionResult Index()
{
if (Session["User"] != null)
{
Session["CurrentController"] = "Notifications";
User user = (User)Session["User"];
var sl = new SortedList <string, object>()
{
{ "SiteID", Convert.ToInt32(Session["SiteId"]) },
{ "UserID", user.UserID }
};
var loDataTable = DataRepositoryControl.ExecuteTable("VMS_GetAllNotificationsDotNet", sl);
Models.Notifications ViewModel = new Models.Notifications();
ViewModel.Notification_Tables = loDataTable;
int SiteID = Convert.ToInt32(Session["SiteId"]);
var result = db.Database
.SqlQuery <AllNotificationsVM>("VMS_GetAllNotificationsDotNet @SiteID, @UserID",
new SqlParameter("@SiteID", SiteID),
new SqlParameter("@UserID", user.UserID)
).ToList();
Session["Notifications"] = result;
return(View());
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
// GET: Dashboard
public ActionResult Index()
{
if (Session["User"] != null)
{
Session["CurrentController"] = "Dashboard";
Session["ErrorMessage"] = null;
int siteID = (int)Session["SiteId"];
Site site = db.Site.Find(siteID);
Session["SiteObject"] = site;
var sl = new SortedList <string, object>()
{
{ "SiteID", siteID }
};
var loDataTable = DataRepositoryControl.ExecuteTable("GetDashboardStats", sl);
var sl2 = new SortedList <string, object>()
{
{ "SiteID", siteID }
};
var loDataTable2 = DataRepositoryControl.ExecuteTable("usp_VisitorActivityFeed", sl2);
var sl3 = new SortedList <string, object>()
{
{ "VisitDetailID", 312 }
};
var loDataTable3 = DataRepositoryControl.ExecuteTable("vms_DotNet_GetVisitorDetailByVisitDetailID", sl3);
Models.Dashboard ViewModel = new Models.Dashboard();
ViewModel.Dashboard_Stats_Tables = loDataTable;
ViewModel.Dashboard_VisitorActivity_Tables = loDataTable2;
ViewModel.Dashboard_Tables = loDataTable3;
return(View(ViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
// GET: Sites
public ActionResult Index()
{
if (Session["User"] != null)
{
Session["CurrentController"] = "Sites";
var sl = new SortedList <string, object>()
{
{ "CompanyID", 1 }
};
var loDataTable = DataRepositoryControl.ExecuteTable("usp_GetAllSites", sl);
Models.Sites ViewModel = new Models.Sites();
ViewModel.Sites_Tables = loDataTable;
return(View(ViewModel));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
