public JsonResult GetAllLists() { //string LoginUser = (string)Session["LoginSAPID"]; try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchAllList("", userkey, uid); dt.TableName = "FetchLists"; dt.Columns.ToString(); var lists = (from DataRow dr in dt.Rows select new { ID = dr["ID"].ToString(), Listname = dr["Listname"].ToString(), Listtype = dr["Listtype"].ToString(), }).ToList(); return(Json(new { data = lists }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create(ListHeader listHeader) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); var CreateList = tns.CreateListHeader(LoginUser, listHeader.Listname, listHeader.H1, listHeader.H2, listHeader.H3, listHeader.H4, listHeader.H5, listHeader.H6, listHeader.H7, listHeader.H8, listHeader.H9, listHeader.H10, listHeader.H11, listHeader.H12, listHeader.H13, listHeader.H14, listHeader.H15, listHeader.H16, listHeader.H17, listHeader.H18, listHeader.H19, listHeader.H20, userkey, uid); var CreateListStatus = CreateList.Split('~'); if (CreateListStatus[0] != "00") { TempData["Msg"] = CreateListStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateListStatus[1]; return(RedirectToAction("Index")); } } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(RedirectToAction("Index")); } }
public ActionResult SaveTemplate(Templates templates) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); var createTemplate = tns.CreateHTMLTemplate(templates.Contents, templates.Title, LoginUser); var CreateStatus = createTemplate.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(RedirectToAction("Index")); } }
public JsonResult GetAllTemplates() { //string LoginUser = (string)Session["LoginSAPID"]; try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.Fetchtemplates("2", "", "", userkey, uid); dt.TableName = "Fetchtemplates"; dt.Columns.ToString(); var template = (from DataRow dr in dt.Rows select new { ID = dr["ID"].ToString(), Title = dr["title"].ToString(), Contents = dr["HtmlCont"].ToString(), Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"), }).ToList(); return(Json(new { data = template }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetRecipientMessage(string recipientId) { //string LoginUser = (string)Session["LoginSAPID"]; try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchsendingHtml(recipientId, userkey, uid); dt.TableName = "FetchHtml"; dt.Columns.ToString(); var template = (from DataRow dr in dt.Rows select new { Contents = dr["HtmlCont"].ToString(), }).ToList(); return(Json(new { data = template }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult StopCampaign(string campaignId) { try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; TNS.TNS tns = new TNS.TNS(); var stopStatus = tns.StopCampaign(campaignId, LoginUser, userkey, uid); var status = stopStatus.Split('~'); if (status[0] != "01") { TempData["Msg"] = status[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = status[1]; return(RedirectToAction("Index")); } } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetCampaignStatus(string campaignId) { try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.Fetchsendingdashboard(campaignId, userkey, uid); dt.TableName = "FetchCampaigns"; dt.Columns.ToString(); var template = (from DataRow dr in dt.Rows select new { Successful = dr["Successful"].ToString(), Error = dr["Error"].ToString(), Outstanding = dr["Outstanding"].ToString(), }).ToList(); return(Json(new { data = template }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetListHeaders(string id) { //string LoginUser = (string)Session["LoginSAPID"]; try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchListByParam(id, "", userkey, uid); dt.TableName = "FetchListA"; dt.Columns.ToString(); var headers = (from DataRow dr in dt.Rows select new ListHeader() { ID = dr["ID"].ToString(), Listname = dr["Listname"].ToString(), H1 = dr["H1"].ToString(), H2 = dr["H2"].ToString(), H3 = dr["H3"].ToString(), H4 = dr["H4"].ToString(), H5 = dr["H5"].ToString(), H6 = dr["H6"].ToString(), H7 = dr["H7"].ToString(), H8 = dr["H8"].ToString(), H9 = dr["H9"].ToString(), H10 = dr["H10"].ToString(), H11 = dr["H11"].ToString(), H12 = dr["H12"].ToString(), H13 = dr["H13"].ToString(), H14 = dr["H14"].ToString(), H15 = dr["H15"].ToString(), H16 = dr["H16"].ToString(), H17 = dr["H17"].ToString(), H18 = dr["H18"].ToString(), H19 = dr["H19"].ToString(), H20 = dr["H20"].ToString(), Listtype = dr["Listtype"].ToString(), }).ToList(); return(Json(new { data = headers }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequestCategory", "Requests", "GetRequestCategory", "FetchRequestCategories Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchAllList("", userkey, uid); dt.TableName = "FetchList"; dt.Columns.ToString(); // var listCreated = tns.CreateListContent(LoginUser, "1", "OyeTunji", "Adelana", "*****@*****.**", "Stanbic IBTC", "Software Arc", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); return(View()); }
public ActionResult Index(string startdate, string enddate) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchALLCampaigns("", userkey, uid); dt.TableName = "FetchCampaigns"; dt.Columns.ToString(); DateTime sdate = DateTime.ParseExact(startdate, "dd-MM-yyyy", CultureInfo.InvariantCulture); DateTime edate = DateTime.ParseExact(enddate, "dd-MM-yyyy", CultureInfo.InvariantCulture); var Campaigns = (from DataRow dr in dt.Rows orderby dr["ID"] descending where DateTime.Parse(dr["DateCreated"].ToString()) >= sdate && DateTime.Parse(dr["DateCreated"].ToString()) <= edate select new Campaign() { ID = dr["ID"].ToString(), CampaignName = dr["CampaignName"].ToString(), EmailTitle = dr["EmailTitle"].ToString(), SenderName = dr["SenderName"].ToString(), CreatedBy = dr["CreatedBy"].ToString(), DateCreated = ((DateTime)dr["DateCreated"]).ToString("dd-MMMM-yyyy"), }).ToList(); var CampaignsCount = Campaigns.Count(); ViewBag.Count = CampaignsCount; ViewBag.Startdate = startdate; ViewBag.Enddate = enddate; ViewBag.Campaigns = Campaigns; return(View()); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); ViewBag.Error = "Error Fetching Records"; return(View()); } }
public JsonResult GetListDetails(String ListId) { try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchList(ListId, userkey, uid); dt.TableName = "FetchLists"; dt.Columns.ToString(); var details = (from DataRow dr in dt.Rows select new { H1 = dr["H1"].ToString(), H2 = dr["H2"].ToString(), H3 = dr["H3"].ToString(), H4 = dr["H4"].ToString(), H5 = dr["H5"].ToString(), H6 = dr["H6"].ToString(), H7 = dr["H7"].ToString(), H8 = dr["H8"].ToString(), H9 = dr["H9"].ToString(), H10 = dr["H10"].ToString(), H11 = dr["H11"].ToString(), H12 = dr["H12"].ToString(), H13 = dr["H13"].ToString(), H14 = dr["H14"].ToString(), H15 = dr["H15"].ToString(), H16 = dr["H16"].ToString(), H17 = dr["H17"].ToString(), H18 = dr["H18"].ToString(), H19 = dr["H19"].ToString(), H20 = dr["H20"].ToString(), }).ToList(); return(Json(new { data = details }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(Json(new { data = ex.Message.ToString() }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Index(Users users, string returnUrl) { try { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string ipaddress = Request.UserHostAddress; string BrowserUsed = Request.UserAgent; TNS.TNS tns = new TNS.TNS(); var LoginStatus = tns.ADAuth(users.Username, users.Password, BrowserUsed, ipaddress, "", userkey, uid); var LoginDetails = LoginStatus.Split('~'); if (LoginDetails[0] != "01") { FormsAuthentication.SetAuthCookie(LoginDetails[1], false); Session["LoginSAPID"] = users.Username; if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") && !returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\")) { return(Redirect(returnUrl)); } else { return(RedirectToAction("Index", "Campaign")); } } else { TempData["error"] = LoginDetails[1]; ViewBag.Error = TempData["error"]; return(View()); } } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog(users.Username, "2", "3", "4", "Login", "Index", "Login Error", ex.Message.ToString(), 0); TempData["error"] = ex.Message.ToString(); ViewBag.Error = TempData["error"]; return(View()); } }
public ActionResult TestCampaign(string listId, string campaignId, string searchparam, string testvalue) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); var testCampaign = tns.SendTestMail(listId, campaignId, searchparam, testvalue, uid, userkey, uid); var testStatus = testCampaign.Split('~'); return(Json(new { data = testStatus[0], msg = testStatus[1] }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(Json(new { data = "01" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetCampaignSendDetails([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, string campaignId) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; //string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.Fetchsendinglist(campaignId, userkey, uid); dt.TableName = "FetchCampaigns"; dt.Columns.ToString(); List <Campaign> Campaigns = new List <Campaign>(); int startRec = requestModel.Start; int pageSize = requestModel.Length; List <Campaign> CampaignCount = (from DataRow dr in dt.Rows select new Campaign() { ID = dr["ID"].ToString() }).ToList(); Campaigns = (from DataRow dr in dt.Rows orderby dr["ID"] descending select new Campaign() { ID = dr["ID"].ToString(), Recipient = dr["SendTo"].ToString(), SMTPResp = dr["SMTPResp"].ToString() }).Skip(startRec).Take(pageSize).ToList(); var totalCount = CampaignCount.Count(); var filteredCount = Campaigns.Count(); if (requestModel.Search.Value != string.Empty) { var value = requestModel.Search.Value.Trim(); CampaignCount = (from DataRow dr in dt.Rows where dr["SendTo"].ToString().Contains(value) || dr["SMTPResp"].ToString().Contains(value) select new Campaign() { ID = dr["ID"].ToString() }).ToList(); Campaigns = (from DataRow dr in dt.Rows orderby dr["ID"] descending where dr["SendTo"].ToString().Contains(value) || dr["SMTPResp"].ToString().Contains(value) select new Campaign() { ID = dr["ID"].ToString(), Recipient = dr["SendTo"].ToString(), SMTPResp = dr["SMTPResp"].ToString() }).Skip(startRec).Take(pageSize).ToList(); totalCount = CampaignCount.Count(); filteredCount = Campaigns.Count(); } var sortedColumns = requestModel.Columns.GetSortedColumns(); var orderByString = String.Empty; foreach (var column in sortedColumns) { orderByString += orderByString != String.Empty ? "," : ""; orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc"); } var data = Campaigns.Select(emList => new { ID = emList.ID, Recipient = emList.Recipient, SMTPResp = emList.SMTPResp }).ToList(); return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetTemplates([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel, String RequestId) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.Fetchtemplates("2", "", "", userkey, uid); dt.TableName = "Fetchtemplates"; dt.Columns.ToString(); List <Templates> templates = new List <Templates>(); int startRec = requestModel.Start; int pageSize = requestModel.Length; List <Templates> templatesCount = (from DataRow dr in dt.Rows select new Templates() { ID = dr["ID"].ToString() }).ToList(); templates = (from DataRow dr in dt.Rows orderby dr["ID"] descending select new Templates() { ID = dr["ID"].ToString(), Title = dr["title"].ToString(), Contents = dr["HtmlCont"].ToString(), Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"), CreatedBy = dr["CreatedBy"].ToString() }).Skip(startRec).Take(pageSize).ToList(); var totalCount = templatesCount.Count(); var filteredCount = templates.Count(); if (requestModel.Search.Value != string.Empty) { var value = requestModel.Search.Value.Trim(); templatesCount = (from DataRow dr in dt.Rows where dr["title"].ToString().Contains(value) select new Templates() { ID = dr["ID"].ToString() }).ToList(); templates = (from DataRow dr in dt.Rows orderby dr["ID"] descending where dr["title"].ToString().Contains(value) select new Templates() { ID = dr["ID"].ToString(), Title = dr["title"].ToString(), Contents = dr["HtmlCont"].ToString(), Datecreated = Convert.ToDateTime(dr["Datecreated"]).ToString("dd-MMM-yyyy hh:mm"), CreatedBy = dr["CreatedBy"].ToString() }).Skip(startRec).Take(pageSize).ToList(); totalCount = templatesCount.Count(); filteredCount = templates.Count(); } var sortedColumns = requestModel.Columns.GetSortedColumns(); var orderByString = String.Empty; foreach (var column in sortedColumns) { orderByString += orderByString != String.Empty ? "," : ""; orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc"); } var data = templates.Select(emList => new { ID = emList.ID, Title = emList.Title, Contents = emList.Contents, Datecreated = emList.Datecreated, CreatedBy = emList.CreatedBy }).ToList(); return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Create(Campaign campaign) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string AttachmentPath = ConfigurationManager.AppSettings["AttachmentPath"]; string LoginUser = (string)Session["LoginSAPID"]; ViewBag.Birthday = ConfigurationManager.AppSettings["Birthday"]; ViewBag.Generic = ConfigurationManager.AppSettings["Generic"]; ViewBag.CustomerJourney = ConfigurationManager.AppSettings["CustomerJourney"]; ViewBag.CustomerJourney30 = ConfigurationManager.AppSettings["30daysCustomerJourney"]; ViewBag.CustomerJourney60 = ConfigurationManager.AppSettings["60daysCustomerJourney"]; ViewBag.CustomerJourney90 = ConfigurationManager.AppSettings["90daysCustomerJourney"]; ViewBag.CustomerJourney365 = ConfigurationManager.AppSettings["365daysCustomerJourney"]; ViewBag.ThreemonthsRedemption = ConfigurationManager.AppSettings["3monthsRedemption"]; ViewBag.AdditionalSubscription = ConfigurationManager.AppSettings["AdditionalSubscription"]; ViewBag.WelcomePack = ConfigurationManager.AppSettings["WelcomePack"]; ViewBag.WebAccess = ConfigurationManager.AppSettings["WebAccess"]; ViewBag.NotificationChange = ConfigurationManager.AppSettings["NotificationChange"]; campaign.Attachment = ""; if (campaign.deliveryType == "SMS") { campaign.Bcc = "N/A"; campaign.CC = "N/A"; campaign.EmailTitle = "N/A"; campaign.DateCreated = ""; campaign.SMTPResp = ""; } try { TNS.TNS tns = new TNS.TNS(); if (campaign.deliveryType == "SMS") { if (campaign.campaignType == "Generic") { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } else { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } } else { var file = Request.Files; if (file[0].ContentLength > 0) { if (campaign.campaignType == "Generic") { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var baseUrl = Request.Url.GetComponents(UriComponents.SchemeAndServer, UriFormat.SafeUnescaped); campaign.Attachment = baseUrl + SaveFile(AttachmentPath, file[0]); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var baseUrl = Request.Url.GetComponents(UriComponents.SchemeAndServer, UriFormat.SafeUnescaped); campaign.Attachment = baseUrl + SaveFile(AttachmentPath, file[0]); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } else { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var baseUrl = Request.Url.GetComponents(UriComponents.SchemeAndServer, UriFormat.SafeUnescaped); campaign.Attachment = baseUrl + SaveFile(AttachmentPath, file[0]); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var baseUrl = Request.Url.GetComponents(UriComponents.SchemeAndServer, UriFormat.SafeUnescaped); campaign.Attachment = baseUrl + SaveFile(AttachmentPath, file[0]); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } } else { if (campaign.campaignType == "Generic") { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, "", userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } else { if (campaign.schedule == "1") { campaign.StartDate = DateTime.Now.AddMinutes(2).ToString("yyyy-MMMM-dd hh:mm:ss"); campaign.EndDate = DateTime.Now.AddHours(120).ToString("yyyy-MMMM-dd hh:mm:ss"); var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } else { var createCampaign = tns.CreateCampaign(LoginUser, campaign.ParamiterizedTemplate, campaign.ListID, campaign.CampaignName, campaign.StartDate, campaign.EndDate, campaign.SenderName, campaign.SenderEmail, campaign.EmailTitle, campaign.CC, campaign.Recipient, campaign.Attachment, campaign.Bcc, campaign.Cycle, campaign.deliveryType, campaign.campaignType, userkey, uid); var CreateStatus = createCampaign.Split('~'); if (CreateStatus[0] != "01") { TempData["Msg"] = CreateStatus[1]; return(RedirectToAction("Index")); } else { TempData["Error"] = CreateStatus[1]; return(RedirectToAction("Index")); } } } } } } catch (Exception ex) { TempData["Error"] = ex.Message.ToString(); //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(View()); } }
public ActionResult Import(string Listname, HttpPostedFileBase upload) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); //var CreateList = tns.CreateListHeader(LoginUser, listHeader.Listname, listHeader.H1, listHeader.H2, listHeader.H3, listHeader.H4, listHeader.H5, listHeader.H6, listHeader.H7, listHeader.H8, listHeader.H9, listHeader.H10, listHeader.H11, listHeader.H12, listHeader.H13, listHeader.H14, listHeader.H15, listHeader.H16, listHeader.H17, listHeader.H18, listHeader.H19, listHeader.H20, userkey, uid); //var CreateListStatus = CreateList.Split('~'); if (upload != null && upload.ContentLength > 0) { if (upload.FileName.EndsWith(".csv")) { // Read the file as a stream StreamReader streamCsv = new StreamReader(upload.InputStream); string csvDataLine = ""; int CurrentLine = 0; string[] PersonData = null; string[] headerData = null; string listCreated = ""; string headerLine = streamCsv.ReadLine(); headerData = headerLine.Split(','); var colHeader = headerData.Count(); if (colHeader == 1) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 2) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 3) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 4) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 5) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 6) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 7) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 8) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 9) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 10) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 11) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 12) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], "", "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 13) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], "", "", "", "", "", "", "", userkey, uid); } else if (colHeader == 14) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], "", "", "", "", "", "", userkey, uid); } else if (colHeader == 15) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], "", "", "", "", "", userkey, uid); } else if (colHeader == 16) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], headerData[15], "", "", "", "", userkey, uid); } else if (colHeader == 17) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], headerData[15], headerData[16], "", "", "", userkey, uid); } else if (colHeader == 18) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], headerData[15], headerData[16], headerData[17], "", "", userkey, uid); } else if (colHeader == 19) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], headerData[15], headerData[16], headerData[17], headerData[18], "", userkey, uid); } else if (colHeader == 20) { listCreated = tns.CreateListHeader(LoginUser, Listname, headerData[0], headerData[1], headerData[2], headerData[3], headerData[4], headerData[5], headerData[6], headerData[7], headerData[8], headerData[9], headerData[10], headerData[11], headerData[12], headerData[13], headerData[14], headerData[15], headerData[16], headerData[17], headerData[18], headerData[19], userkey, uid); } var CreateListStatus = listCreated.Split('~'); if (CreateListStatus[0] != "00") { TempData["Msg"] = CreateListStatus[2]; return(RedirectToAction("Index")); } else { while ((csvDataLine = streamCsv.ReadLine()) != null) { if (CurrentLine != -1) { PersonData = csvDataLine.Split(','); var colCount = PersonData.Count(); if (colCount == 1) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 2) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 3) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 4) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 5) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 6) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], "", "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 7) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], "", "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 8) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], "", "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 9) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], "", "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 10) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], "", "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 11) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], "", "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 12) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], "", "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 13) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], "", "", "", "", "", "", "", userkey, uid); } else if (colCount == 14) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], "", "", "", "", "", "", userkey, uid); } else if (colCount == 15) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], "", "", "", "", "", userkey, uid); } else if (colCount == 16) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], PersonData[15], "", "", "", "", userkey, uid); } else if (colCount == 17) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], PersonData[15], PersonData[16], "", "", "", userkey, uid); } else if (colCount == 18) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], PersonData[15], PersonData[16], PersonData[17], "", "", userkey, uid); } else if (colCount == 19) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], PersonData[15], PersonData[16], PersonData[17], PersonData[18], "", userkey, uid); } else if (colCount == 20) { var listContentCreated = tns.CreateListContent(LoginUser, CreateListStatus[1], PersonData[0], PersonData[1], PersonData[2], PersonData[3], PersonData[4], PersonData[5], PersonData[6], PersonData[7], PersonData[8], PersonData[9], PersonData[10], PersonData[11], PersonData[12], PersonData[13], PersonData[14], PersonData[15], PersonData[16], PersonData[17], PersonData[18], PersonData[19], userkey, uid); } } CurrentLine += 1; } TempData["MessageSuccess"] = "Contact Imported Successfully"; return(RedirectToAction("index", "Lists")); } } else { TempData["MessageError"] = "File Format is not Supported"; return(RedirectToAction("Upload", "Lists")); } } else { TempData["MessageError"] = "Please Add File"; return(RedirectToAction("Upload", "Lists")); } } catch (Exception ex) { TempData["MessageError"] = "Error:" + ex.Message; //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(RedirectToAction("Index")); } }
public JsonResult GetCampaigns([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel) { string userkey = ConfigurationManager.AppSettings["userkey"]; string uid = ConfigurationManager.AppSettings["uid"]; //string LoginUser = (string)Session["LoginSAPID"]; try { TNS.TNS tns = new TNS.TNS(); DataTable dt = tns.FetchALLCampaigns("", userkey, uid); dt.TableName = "FetchCampaigns"; dt.Columns.ToString(); List <Campaign> Campaigns = new List <Campaign>(); int startRec = requestModel.Start; int pageSize = requestModel.Length; List <Campaign> CampaignCount = (from DataRow dr in dt.Rows select new Campaign() { ID = dr["ID"].ToString() }).ToList(); Campaigns = (from DataRow dr in dt.Rows orderby dr["ID"] descending select new Campaign() { ID = dr["ID"].ToString(), ListID = dr["ListID"].ToString(), CampaignName = dr["CampaignName"].ToString(), EmailTitle = dr["EmailTitle"].ToString(), SenderName = dr["SenderName"].ToString(), CreatedBy = dr["CreatedBy"].ToString(), DateCreated = ((DateTime)dr["DateCreated"]).ToString("dd-MMMM-yyyy"), Status = dr["Status"].ToString(), LastRunTime = dr["LastRunTime"].ToString(), NextRunTime = dr["NextRunTime"].ToString(), StartDate = dr["StartDate"].ToString(), EndDate = dr["EndDate"].ToString(), SenderEmail = dr["SenderEmail"].ToString(), Cycle = dr["Cycle"].ToString(), DeactivatedBy = dr["DeactivatedBy"].ToString(), Datedeactivated = dr["Datedeactivated"].ToString(), }).Skip(startRec).Take(pageSize).ToList(); var totalCount = CampaignCount.Count(); var filteredCount = Campaigns.Count(); if (requestModel.Search.Value != string.Empty) { var value = requestModel.Search.Value.Trim(); CampaignCount = (from DataRow dr in dt.Rows where dr["EmailTitle"].ToString().Contains(value) || dr["CampaignName"].ToString().Contains(value) select new Campaign() { ID = dr["ID"].ToString() }).ToList(); Campaigns = (from DataRow dr in dt.Rows orderby dr["ID"] descending where dr["EmailTitle"].ToString().Contains(value) || dr["CampaignName"].ToString().Contains(value) || ((DateTime)dr["DateCreated"]).ToString("dd-MMMM-yyyy").Contains(value) select new Campaign() { ID = dr["ID"].ToString(), ListID = dr["ListID"].ToString(), CampaignName = dr["CampaignName"].ToString(), EmailTitle = dr["EmailTitle"].ToString(), SenderName = dr["SenderName"].ToString(), CreatedBy = dr["CreatedBy"].ToString(), DateCreated = ((DateTime)dr["DateCreated"]).ToString("dd-MMMM-yyyy"), Status = dr["Status"].ToString(), LastRunTime = dr["LastRunTime"].ToString(), NextRunTime = dr["NextRunTime"].ToString(), StartDate = dr["StartDate"].ToString(), EndDate = dr["EndDate"].ToString(), SenderEmail = dr["SenderEmail"].ToString(), Cycle = dr["Cycle"].ToString(), DeactivatedBy = dr["DeactivatedBy"].ToString(), Datedeactivated = dr["Datedeactivated"].ToString(), }).Skip(startRec).Take(pageSize).ToList(); totalCount = CampaignCount.Count(); filteredCount = Campaigns.Count(); } var sortedColumns = requestModel.Columns.GetSortedColumns(); var orderByString = String.Empty; foreach (var column in sortedColumns) { orderByString += orderByString != String.Empty ? "," : ""; orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc"); } var data = Campaigns.Select(emList => new { ID = emList.ID, ListID = emList.ListID, CampaignName = emList.CampaignName, EmailTitle = emList.EmailTitle, SenderName = emList.SenderName, CreatedBy = emList.CreatedBy, DateCreated = emList.DateCreated, Status = emList.Status, LastRunTime = emList.LastRunTime, NextRunTime = emList.NextRunTime, StartDate = emList.StartDate, EndDate = emList.EndDate, SenderEmail = emList.SenderEmail, Cycle = emList.Cycle, DeactivatedBy = emList.DeactivatedBy, Datedeactivated = emList.Datedeactivated, }).ToList(); return(Json(new DataTablesResponse(requestModel.Draw, data, totalCount, totalCount), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //LogError logerror = new LogError(); //logerror.ErrorLog("", LoginUser, "", "Requests/GetRequests", "Requests", "GetRequests", "FetchIncidents Error", ex.Message.ToString(), 0); return(Json(new { data = "Error has occured" }, JsonRequestBehavior.AllowGet)); } }