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