public IActionResult DeleteNotification(Models.Notifications obj)
{
int uid = Convert.ToInt32(HttpContext.Session.GetString("uid"));
if (uid == 0)
{
return(RedirectToAction("Login", "Home"));
}
if (repObj.GetRoleId(uid) != "F")
{
if (repObj.GetRoleId(uid) == "E")
{
return(RedirectToAction("EmployeeHome", "User"));
}
if (repObj.GetRoleId(uid) == "C")
{
return(RedirectToAction("CustomerHome", "User"));
}
}
int cidn = Convert.ToInt32(HttpContext.Session.GetString("uid"));
int nid = obj.Nid;
bool query = repObj.DeleteNotification(nid);
if (query)
{
return(RedirectToAction("GetNotifications", "Farmer"));
}
return(View("Error"));
}
// 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"));
}
}
public Models.Notifications Get()
{
Models.Notifications notifications;
using (var db = new EntiTreesEntities())
{
var query = db.SelectAdminHomeNotifications().FirstOrDefault();
notifications = new Models.Notifications
{
activeItems = query.ActiveItems.HasValue ? query.ActiveItems.Value : 0,
allItems = query.AllItems.HasValue ? query.AllItems.Value : 0,
allContacts = query.AllContacts.HasValue ? query.AllContacts.Value : 0,
openContacts = query.OpenContacts.HasValue ? query.OpenContacts.Value : 0,
openOrders = query.OpenOrders.HasValue ? query.OpenOrders.Value : 0,
allOrders = query.AllOrders.HasValue ? query.AllOrders.Value : 0,
customersCount = query.CustomersCount.HasValue ? query.CustomersCount.Value : 0
};
return(notifications);
}
}