private ActionResult BindContactUsReport(ContactUsReportModel model) { try { model.PageNumber = model.PageNumber == null ? 1 : model.PageNumber; } catch { model.PageNumber = 1; } model.PageSize = Convert.ToInt32(StratasFair.Business.CommonHelper.CommonData.FetchSettingValue("Admin.PageSize.Long")); // 2 return(View(model)); }
public ActionResult ContactUsExportToCsv() { try { ConvertToCSV objCSV = new ConvertToCSV(); string FilePath = "~/Content/Resources/Reports/csvData.csv"; objCSV.fncDeleteFile(FilePath); ReportsHelper objLedgerHelper = new ReportsHelper(); ContactUsReportModel objLedgerModel = new ContactUsReportModel { PageNumber = 1, PageSize = 100000000 }; List <ContactUsReportModel> listLedgerModel = objLedgerHelper.GetContactUsReport(objLedgerModel); DataTable dt = new DataTable(); dt.Columns.Add("Name"); dt.Columns.Add("Email Address"); dt.Columns.Add("Message"); dt.Columns.Add("Created On"); if (listLedgerModel.Count() != 0) { foreach (var item in listLedgerModel) { DataRow row = dt.NewRow(); row["Name"] = item.FirstName; row["Email Address"] = item.EmailAddress; row["Message"] = item.Message; row["Created On"] = StratasFair.Business.CommonHelper.AppLogic.GetDateFromatForCsv(item.CreatedOn); dt.Rows.Add(row); } } if (dt.Rows.Count > 0) { objCSV.CreateCSVFile(dt, Server.MapPath("~/Content/Resources/Reports/") + "csvData.csv"); objCSV.FncDownLoadFiles("ContactUs_" + DateTime.Now.ToShortDateString() + ".csv", FilePath); } } catch (Exception Ex) { string Err = Ex.Message.ToString(); } return(Redirect(Url.Content("~/securehost/rootlogin/report/contactus"))); }
/// <summary> /// Get the contact us query report /// </summary> /// <param name="model"></param> /// <returns></returns> public List <ContactUsReportModel> GetContactUsReport(ContactUsReportModel model) { return(context.Usp_ContactUsReportAdmin(model.KeywordSearch, model.PageNumber, model.PageSize).Select(x => new ContactUsReportModel { Sno = x.Sno, ContactUsId = x.ContactUsId, FirstName = x.FirstName, LastName = x.LastName, Message = x.Message, CreatedOn = x.CreatedOn, TotalCount = x.TotalCount.Value, Status = x.Status, EmailAddress = x.EmailAddress }).ToList()); }
public ActionResult ContactUs(ContactUsReportModel model, int?id) { model.PageNumber = 1; return(BindContactUsReport(model)); }
public ActionResult ContactUs(ContactUsReportModel model) { return(BindContactUsReport(model)); }