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