private SelectList GetAllReceivingEmails() { var _SettingContexts = new Contexts.SettingContexts(); var _EmailsContexts = new Contexts.EmailsContexts(); var receivingEmail = _SettingContexts.GetSettings().Select(x => x.ReceivingEmail).FirstOrDefault().ToArray(); var list = new List <ReceivingEmailModel>(); foreach (var item in receivingEmail) { list = _EmailsContexts.GetEmails().Select(m => new ReceivingEmailModel() { ReceivingEmailID = m.EmailID, ReceivingEmailTxt = m.EmailTxt }).ToList(); } var objSocialMedia = new ReceivingEmailModel(); objSocialMedia.ReceivingEmailTxt = "-- Select Receiving Emails --"; objSocialMedia.ReceivingEmailID = 0; list.Insert(0, objSocialMedia); var objselectlist = new SelectList(list, "ReceivingEmailID", "ReceivingEmailTxt"); return(objselectlist); }
public ActionResult CreateEmail(EmailsModel _Emailmodel, string command, FormCollection fm, int emailtype) { Session["Edit/Delete"] = "Edit"; var EmailContext = new Contexts.EmailsContexts(); var emailTypeName = EmailContext.GetEmailType(emailtype); ViewBag.Title = (_Emailmodel.EmailID > 0 ? "Edit " : "Add ") + emailTypeName; ViewBag.Submit = _Emailmodel.EmailID > 0 ? "Update" : "Save"; if (string.IsNullOrEmpty(command)) { try { if (ViewBag.Submit == "Save") { if (EmailContext.GetEmails().Where(x => x.EmailTxt.ToLower().Trim() == _Emailmodel.EmailTxt.ToLower().Trim() && x.EmailTypeID == emailtype).Count() > 0) { ModelState.AddModelError("EmailTxt", _Emailmodel.EmailTxt + " Email already exists."); return(View(_Emailmodel)); } _Emailmodel.EmailTypeID = emailtype; EmailContext.AddEmail(_Emailmodel); TempData["AlertMessage"] = emailTypeName + " details saved successfully."; } else { if (EmailContext.GetEmails().Where(x => x.EmailTxt.ToLower().Trim() == _Emailmodel.EmailTxt.ToLower().Trim() && x.EmailTypeID == emailtype && x.EmailID != _Emailmodel.EmailID).Count() > 0) { ModelState.AddModelError("EmailTxt", _Emailmodel.EmailTxt + " Email already exists."); return(View(_Emailmodel)); } EmailContext.EditEmails(_Emailmodel); TempData["AlertMessage"] = emailTypeName + " details updated successfully."; } } catch (Exception ex) { TempData["AlertMessage"] = "Some error occured, Please try after some time. " + ex.Message.ToString(); } } var rvd = new RouteValueDictionary(); rvd.Add("Column", Request.QueryString["Column"] != null ? Request.QueryString["Column"].ToString() : "FirstName"); rvd.Add("Direction", Request.QueryString["Direction"] != null ? Request.QueryString["Direction"].ToString() : "Ascending"); rvd.Add("pagesize", Request.QueryString["pagesize"] != null ? Request.QueryString["pagesize"].ToString() : Models.Common._pageSize.ToString()); rvd.Add("page", Request.QueryString["page"] != null ? Request.QueryString["page"].ToString() : Models.Common._currentPage.ToString()); rvd.Add("emailtype", _Emailmodel.EmailTypeID == 0 ? emailtype : _Emailmodel.EmailTypeID); return(RedirectToAction("BlogEmailListing", "Emails", rvd)); }
/// <summary> /// Get all to emails /// </summary> /// <returns></returns> private SelectList GetAllToEmails() { var _emailContext = new Contexts.EmailsContexts(); var list = _emailContext.GetEmails().Where(x => x.EmailTypeID == 2).OrderBy(x => x.EmailTxt).Select(x => new EmailsModel() { EmailID = x.EmailID, EmailTxt = x.EmailTxt }).ToList(); var objEmail = new EmailsModel(); objEmail.EmailTxt = "-- Select To Email --"; objEmail.EmailID = 0; list.Insert(0, objEmail); var objselectlist = new SelectList(list, "EmailID", "EmailTxt"); return(objselectlist); }
public ActionResult CreateEmail(int?Emailid, int emailtype) { var _EmailContext = new Contexts.EmailsContexts(); var _EmailModel = new EmailsModel(); var emailTypeName = _EmailContext.GetEmailType(emailtype); ViewBag.Title = (Emailid.HasValue ? "Edit " : "Add ") + emailTypeName; ViewBag.Submit = Emailid.HasValue && Emailid.Value > 0 ? "Update" : "Save"; if (Emailid.HasValue && Emailid.Value > 0) { if (_EmailModel != null) { _EmailModel = _EmailContext.GetEmails().Where(x => x.EmailID == Emailid).FirstOrDefault(); } } return(View(_EmailModel)); }
public ActionResult Setting(int?SettingID, int ContentType) { var _settingContext = new Contexts.SettingContexts(); var _emailContext = new Contexts.EmailsContexts(); var _settingModel = new SettingModel(); var settingType = string.Empty; settingType = (ContentType == 3 ? "Basic" : (ContentType == 5 ? "Theme" : (ContentType == 4 ? "Email" : ""))); ViewBag.Title = (SettingID.HasValue ? "Edit " : "Add ") + settingType + " Setting Details "; ViewBag.Submit = SettingID.HasValue && SettingID.Value > 0 ? "Update" : "Save"; bool isSearchEnabled = true; bool isCommentEnabled = true; bool isSocialSharingEnabled = true; string fontSize = string.Empty; ViewBag.FromEmails = new SelectList(_emailContext.GetEmails().Where(x => x.EmailTypeID == 1).ToList().OrderBy(x => x.EmailTxt), "EmailID", "EmailTxt"); ViewBag.ToEmails = new SelectList(_emailContext.GetEmails().Where(x => x.EmailTypeID == 2).ToList().OrderBy(x => x.EmailTxt), "EmailID", "EmailTxt"); _settingModel.ReceivingEmailList = GetAllReceivingEmails(); if (SettingID.HasValue && SettingID.Value > 0) { if (_settingModel != null) { _settingModel.ReceivingEmailList = GetAllToEmails();//Receiving Emails var array_ReceivingEmailID = new string[] { }; var receiveEmailTxt = _settingContext.GetSettings().Select(x => x.ReceivingEmail).FirstOrDefault(); _settingModel.SendingEmail = _settingContext.GetSettings().Select(x => x.SendingEmail).FirstOrDefault(); if (receiveEmailTxt.Contains(',')) { array_ReceivingEmailID = _settingContext.GetSettings().Select(x => x.ReceivingEmail).FirstOrDefault().Split(','); } else { array_ReceivingEmailID = _settingContext.GetSettings().Select(x => x.ReceivingEmail).ToArray(); } var selecetdReceivingEmailsarray = Array.ConvertAll <int, string>(_emailContext.GetEmails().Where(x => array_ReceivingEmailID.Contains(x.EmailID.ToString())).Select(x => x.EmailID).ToArray(), delegate(int i) { return((string)i.ToString()); }); isSearchEnabled = _settingContext.GetSettings().Select(x => x.IsSearchEnabled).FirstOrDefault(); isCommentEnabled = _settingContext.GetSettings().Select(x => x.IsCommentEnabled).FirstOrDefault(); isSocialSharingEnabled = _settingContext.GetSettings().Select(x => x.IsSocialSharingEnabled).FirstOrDefault(); _settingModel.SelectedReceivingEmail = selecetdReceivingEmailsarray; } } else { ViewBag.Submit = "Save"; string[] ToEmailarr = new string[] { "0" }; _settingModel.SelectedToEmails = ToEmailarr; } #region Fill Values var settinglist = _settingContext.GetSettings().FirstOrDefault(); _settingModel.PagingColor = !string.IsNullOrEmpty(settinglist.PagingColor) ? settinglist.PagingColor : ""; _settingModel.PagingActiveColor = !string.IsNullOrEmpty(settinglist.PagingActiveColor) ? settinglist.PagingActiveColor : ""; _settingModel.PagingHoverColor = !string.IsNullOrEmpty(settinglist.PagingHoverColor) ? settinglist.PagingHoverColor : ""; _settingModel.NevigationBarColor = !string.IsNullOrEmpty(settinglist.NevigationBarColor) ? settinglist.NevigationBarColor : ""; _settingModel.NevigationBarTextFontSize = !string.IsNullOrEmpty(settinglist.NevigationBarTextFontSize) ? settinglist.NevigationBarTextFontSize : ""; _settingModel.NevigationBarFontColor = !string.IsNullOrEmpty(settinglist.NevigationBarFontColor) ? settinglist.NevigationBarFontColor : ""; _settingModel.NevigationBarHoverColor = !string.IsNullOrEmpty(settinglist.NevigationBarHoverColor) ? settinglist.NevigationBarHoverColor : ""; _settingModel.FooterColor = !string.IsNullOrEmpty(settinglist.FooterColor) ? settinglist.FooterColor : ""; _settingModel.SidebarTitleBackgroundColor = !string.IsNullOrEmpty(settinglist.SidebarTitleBackgroundColor) ? settinglist.SidebarTitleBackgroundColor : ""; _settingModel.SidebarTitleFontcolor = !string.IsNullOrEmpty(settinglist.SidebarTitleFontcolor) ? settinglist.SidebarTitleFontcolor : ""; _settingModel.SidebarTitleFontSize = !string.IsNullOrEmpty(settinglist.SidebarTitleFontSize) ? settinglist.SidebarTitleFontSize : ""; _settingModel.PostTitleFontColor = !string.IsNullOrEmpty(settinglist.PostTitleFontColor) ? settinglist.PostTitleFontColor : ""; _settingModel.PostTitleFontSize = !string.IsNullOrEmpty(settinglist.PostTitleFontSize) ? settinglist.PostTitleFontSize : ""; _settingModel.ButtonColor = !string.IsNullOrEmpty(settinglist.ButtonColor) ? settinglist.ButtonColor : ""; _settingModel.ContentType = ContentType; _settingModel.IsSearchEnabled = isSearchEnabled; _settingModel.IsCommentEnabled = isCommentEnabled; _settingModel.IsSocialSharingEnabled = isSocialSharingEnabled; ViewBag.NevigationbarFontFamily = GetAllFont(_settingModel != null ? _settingContext.GetSettings().Select(x => x.NevigationBarFontFamily).FirstOrDefault() : string.Empty);// new SelectList(font,"FontID","Name"); ViewBag.SidebarTitleFontFamily = GetAllFont(_settingModel != null ? _settingContext.GetSettings().Select(x => x.SidebarTitleFontFamily).FirstOrDefault() : string.Empty); ViewBag.PostTitleFontFamily = GetAllFont(_settingModel != null ? _settingContext.GetSettings().Select(x => x.PostTitleFontFamily).FirstOrDefault() : string.Empty); ViewBag.IsSearchEnabled = Models.Common.GetStatusListBoolean(isSearchEnabled ? "true" : "false"); ViewBag.IsCommentEnabled = Models.Common.GetStatusListBoolean(isCommentEnabled ? "true" : "false"); ViewBag.IsSocialSharingEnabled = Models.Common.GetStatusListBoolean(isSocialSharingEnabled ? "true" : "false"); ViewBag.fontSize = Models.Common.GetFontList("12"); _settingModel.PostPerPage = _settingContext.GetSettings().Select(x => x.PostPerPage).FirstOrDefault(); _settingModel.CommentPerPost = _settingContext.GetSettings().Select(x => x.CommentPerPost).FirstOrDefault(); #endregion return(View(_settingModel)); }
public ActionResult BlogEmailListing(int?emailtype, GridSortOptions gridSortOptions, int?pagetype, int?page, int?pagesize, FormCollection fm, string objresult) { var _objContext = new Contexts.EmailsContexts(); ViewBag.Title = _objContext.GetEmailType(emailtype.Value) + " Listing"; var _EmailsModel = new EmailsModel(); #region Ajax Call if (objresult != null) { AjaxRequest objAjaxRequest = JsonConvert.DeserializeObject <AjaxRequest>(objresult);//Convert json String to object Model if (objAjaxRequest.ajaxcall != null && !string.IsNullOrEmpty(objAjaxRequest.ajaxcall) && objresult != null && !string.IsNullOrEmpty(objresult)) { if (objAjaxRequest.ajaxcall == "paging") //Ajax Call type = paging i.e. Next|Previous|Back|Last { Session["pageNo"] = page; // stores the page no for status } else if (objAjaxRequest.ajaxcall == "sorting") //Ajax Call type = sorting i.e. column sorting Asc or Desc { page = (Session["pageNo"] != null ? Convert.ToInt32(Session["pageNo"].ToString()) : page); Session["GridSortOption"] = gridSortOptions; pagesize = (Session["PageSize"] != null ? Convert.ToInt32(Session["PageSize"].ToString()) : pagesize); } else if (objAjaxRequest.ajaxcall == "ddlPaging")//Ajax Call type = drop down paging i.e. drop down value 10, 25, 50, 100, ALL { Session["PageSize"] = (Request.QueryString["pagesize"] != null ? Convert.ToInt32(Request.QueryString["pagesize"].ToString()) : pagesize); Session["GridSortOption"] = gridSortOptions; Session["pageNo"] = page; } else if (objAjaxRequest.ajaxcall == "status")//Ajax Call type = status i.e. Active/Inactive { page = (Session["pageNo"] != null ? Convert.ToInt32(Session["pageNo"].ToString()) : page); gridSortOptions = (Session["GridSortOption"] != null ? Session["GridSortOption"] as GridSortOptions : gridSortOptions); } else if (objAjaxRequest.ajaxcall == "displayorder")//Ajax Call type = Display Order i.e. drop down values { page = (Session["pageNo"] != null ? Convert.ToInt32(Session["pageNo"].ToString()) : page); gridSortOptions = (Session["GridSortOption"] != null ? Session["GridSortOption"] as GridSortOptions : gridSortOptions); } objAjaxRequest.ajaxcall = null;; //remove parameter value } } #endregion Ajax Call //This section is used to retain the values of page , pagesize and gridsortoption on complete page post back(Edit, Dlete) if (!Request.IsAjaxRequest() && Session["Edit/Delete"] != null && !string.IsNullOrEmpty(Session["Edit/Delete"].ToString())) { pagesize = (Session["PageSize"] != null ? Convert.ToInt32(Session["PageSize"]) : Models.Common._pageSize); page = (Session["pageNo"] != null ? Convert.ToInt32(Session["pageNo"]) : Models.Common._currentPage); gridSortOptions = (Session["GridSortOption"] != null ? Session["GridSortOption"] as GridSortOptions : gridSortOptions); Session["Edit/Delete"] = null; } else if (!Request.IsAjaxRequest() && Session["Edit/Delete"] == null) { //gridSortOptions.Column = "CreateDate"; Session["PageSize"] = null; Session["pageNo"] = null; Session["GridSortOption"] = null; } if (gridSortOptions.Column != null && gridSortOptions.Column == "EmailTxt") { } else { gridSortOptions.Column = "EmailTxt"; } var pageSize = pagesize.HasValue ? pagesize.Value : Models.Common._pageSize; var Page = page.HasValue ? page.Value : Models.Common._currentPage; TempData["pager"] = pagesize; var pagedViewModel = new PagedViewModel <EmailsModel> { ViewData = ViewData, Query = _objContext.GetEmail(emailtype).AsQueryable(), GridSortOptions = gridSortOptions, DefaultSortColumn = "EmailTxt", Page = Page, PageSize = pageSize, }.Setup(); if (Request.IsAjaxRequest()) // check if request comes from ajax, then return Partial view { return(View("BlogEmailListingPartial", pagedViewModel)); // ("partial view name ") } else { return(View(pagedViewModel)); } }
public JsonResult Delete(int?EmailId, int?emailtype) { Session["Edit/Delete"] = "Delete"; var EmailContext = new Contexts.EmailsContexts(); var SettingContexts = new Contexts.SettingContexts(); var objSettingContexts = SettingContexts.GetSettings().FirstOrDefault(); var rvd = new RouteValueDictionary(); int?Page = 1; var count = 1; count = EmailContext.GetEmails().Count(); var page = Request.QueryString["page"] ?? Models.Common._currentPage.ToString(); var pagesize = Request.QueryString["pagesize"] ?? Models.Common._pageSize.ToString(); if (Convert.ToInt32(page) > 1) { Page = count > ((Convert.ToInt32(page) - 1) * Convert.ToInt32(pagesize)) ? Convert.ToInt32(page) : (Convert.ToInt32(page)) - 1; } rvd.Add("page", Page); rvd.Add("Column", Request.QueryString["Column"] != null ? Request.QueryString["Column"].ToString() : "FirstName"); rvd.Add("Direction", Request.QueryString["Direction"] != null ? Request.QueryString["Direction"].ToString() : "Ascending"); rvd.Add("pagesize", pagesize); rvd.Add("emailtype", emailtype); if (EmailId.HasValue) { try { if (EmailContext != null) { var email_coun = 0; if (emailtype == 1)// Sending email { email_coun = SettingContexts.GetSettings().Where(x => x.SendingEmail == Convert.ToString(EmailId)).Count(); } else if (emailtype == 2)// Receiving email { if (!string.IsNullOrEmpty(objSettingContexts.ReceivingEmail)) { if (objSettingContexts.ReceivingEmail.Contains(",")) { var recevingemail_array = objSettingContexts.ReceivingEmail.Split(','); email_coun = recevingemail_array.Contains(Convert.ToString(EmailId)) ? 1 : 0; } else { var recevingemail_array = new string[] { objSettingContexts.ReceivingEmail }; email_coun = recevingemail_array.Contains(Convert.ToString(EmailId)) ? 1 : 0; } } } if (email_coun == 0) { EmailContext.DeleteEmails(EmailId); TempData["AlertMessage"] = "Email details deleted successfully."; } else { TempData["Message"] = "Email is in use, can not be deleted."; return(Json(Url.Action("BlogEmailListing", "Emails", rvd))); } } } catch { TempData["AlertMessage"] = "Some error occured while deleting the Email, Please try again later."; } } return(Json(Url.Action("BlogEmailListing", "Emails", rvd))); }