public ActionResult Exception(int?page) { const int pageSize = 10; int pageNumber = (page ?? 1); //ExceptionViewModel model = new ExceptionViewModel(); List <M_CustomException> model = new List <M_CustomException>(); model = M_CustomException.GetExceptionData(); return(PartialView(model.ToPagedList(pageNumber, pageSize))); }
/// <summary> /// gets number of campaigns,lists,subscribers for perticular user to display on dashboared /// </summary> /// <returns></returns> public ActionResult Index() { string uid = User.Identity.GetUserId(); DashboardViewModel model = new DashboardViewModel(); //listIDs = dbContext.UsersList.Where(u => u.UsersID == uid).Select(l => l.ListID).ToList(); try { cnt = (from sub in dbContext.M_Subscribers join users in dbContext.UsersList on sub.ListID equals users.ListID where (users.UsersID == uid && sub.Unsubscribe == false) select sub).Count(); cnt1 = (from sub in dbContext.M_Subscribers join users in dbContext.UsersList on sub.ListID equals users.ListID where (users.UsersID == uid && sub.Unsubscribe == true) select sub).Count(); } catch (DataException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } catch (SqlException ex) { obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); throw obj; } //foreach (var item in listIDs) //{ // cnt += dbContext.Subscribers.Where(l => l.ListID == item && l.Unsubscribe==false).Count(); // cnt1 += dbContext.Subscribers.Where(l => l.ListID == item && l.Unsubscribe == true).Count(); //} model.NoOfLists = dbContext.UsersList.Where(u => u.UsersID == uid).Count(); model.NoOfSubscribers = cnt; model.NoOfUnSubscribers = cnt1; model.NoOfCampaigns = dbContext.UsersCampaigns.Where(u => u.UsersID == uid).Count(); return(View(model)); // return View(); }
public ActionResult editCampaign(int?id) { userID = GetUser(); UpdateCampModel campaign = new UpdateCampModel(); try { // campaign.Campaigns = dbContext.M_Campaigns.Find(id); campaign.Campaigns = M_Campaigns.FindCampaign(id); //campaign.Subscribers = dbContext.NewLists.Find(campaign.Campaigns.ListId).Subscribers.ToList(); campaign.Subscribers = M_Campaigns.subscribersToCampaign(campaign.Campaigns.ListId); //WebUtility.HtmlDecode(campaign.Campaigns.EmailContent); ViewBag.campTypes = new SelectList(S_CampaignTypes.GetCampTypes(), "CTId", "Name"); ViewBag.List = new SelectList(M_List.GetLists(userID), "ListID", "ListName"); TempData["emailContent"] = campaign.Campaigns.EmailContent; return(View("UpdateCamp", campaign)); } catch (M_CustomException ex) { if (ex.ErrorCode == 100) { ModelState.AddModelError("error", ex.message); return(RedirectToAction("Campaign")); } else if (ex.ErrorCode == 101) { ModelState.AddModelError("Error", "logical exception"); return(RedirectToAction("Campaign")); } } catch (InvalidOperationException ex) { M_CustomException obj = new M_CustomException((int)ErorrTypes.others, ex.Message, ex.StackTrace, ErorrTypes.others.ToString(), Utlities.GetURL()); obj.LogException(); ModelState.AddModelError("Error", "Invalid operation"); return(RedirectToAction("Campaign")); } return(RedirectToAction("Campaign")); }