public ActionResult AddCampaign(FormCollection collection)
{
if (Session["userKey"] != null)
{
try
{
pcms_campaign campaign = new pcms_campaign();
campaign.CAMPAIGN_NAME = collection["campaign_name"].ToString();
string[] s = collection["startdate"].ToString().Split('/');
campaign.CAMPAIGN_START_DATE = Convert.ToDateTime(s[2] + "/" + s[0] + "/" + s[1]);
string[] s1 = collection["endDate"].ToString().Split('/');
campaign.CAMPAIGN_END_DATE = Convert.ToDateTime(s1[2] + "/" + s1[0] + "/" + s1[1]);
campaign.CAMPAIGN_DESCRIPTION = Convert.ToString(collection["Description"]);
campaign.CAMPAIGN_URL = collection["campaignurl"].ToString();
campaign.CAMPAIGN_DESIGN_ID = collection["designlist"] == "" ? 0 : Convert.ToInt16(collection["designlist"]);
campaign.CAMPAIGN_CONTENT_ID = collection["contentlist"] == "" ? 0 : Convert.ToInt16(collection["contentlist"]);
campaign.CAMPAIGN_POPUP_ID = Convert.ToInt16(Convert.ToString(collection["popuplist"]));
campaign.CAMPAIGN_CONTAINER_ID = Convert.ToString(collection["containerid"]);
campaign.CAMPAIGN_STATUS = Convert.ToString(collection["campaingstatus"]);
campaign.CAMPAIGN_REDIRECT_URL = Convert.ToString(collection["redirecturl"]);
campaign.CAMPAIGN_RULE_ID = Convert.ToInt16(collection["rulelister"]);
campaign.CAMPAIGN_POPUP_STATUS = Convert.ToString(collection["popup"]);
campaign.INSERTED_BY = Session["userKey"].ToString();
campaign.INSERTED_DATE = DateTime.Now;
campaign.TS_CNT = 0;
var campaigner = objBAL.AddCampain(campaign);
if (campaigner.Contains("Inserted"))
{
ViewBag.Message = "Campaign Inserted";
}
else if (campaigner.Contains("Duplicate"))
{
ViewBag.Message = "Campaign name must be unique";
}
else
{
ViewBag.Message = "Something went wrong";
}
return(View());
}
catch (Exception ex)
{
ErrorLog obj = new ErrorLog();
obj.LogError(ex);
return(null);
}
}
else
{
return(RedirectToAction("Index", "Account", null));
}
}
public string InsertCampaignData(pcms_campaign _campaign)
{
string Msg = "";
PCMS_DbContext context = new PCMS_DbContext();
try
{
if (!context.pcms_campaign.Any(u => u.CAMPAIGN_NAME == _campaign.CAMPAIGN_NAME))
{
pcms_campaign cm = new pcms_campaign();
cm.PK_CAMPAIGN = Guid.NewGuid();
cm.CAMPAIGN_NAME = _campaign.CAMPAIGN_NAME;
cm.CAMPAIGN_DESCRIPTION = Cryptographys.Encrypt(_campaign.CAMPAIGN_DESCRIPTION);
cm.CAMPAIGN_START_DATE = Convert.ToDateTime(_campaign.CAMPAIGN_START_DATE);
cm.CAMPAIGN_END_DATE = Convert.ToDateTime(_campaign.CAMPAIGN_END_DATE);
cm.CAMPAIGN_STATUS = _campaign.CAMPAIGN_STATUS;
cm.CAMPAIGN_DESIGN_ID = _campaign.CAMPAIGN_DESIGN_ID;
cm.CAMPAIGN_CONTENT_ID = _campaign.CAMPAIGN_CONTENT_ID;
cm.CAMPAIGN_POPUP_STATUS = _campaign.CAMPAIGN_POPUP_STATUS;
cm.CAMPAIGN_POPUP_ID = _campaign.CAMPAIGN_POPUP_ID;
cm.CAMPAIGN_RULE_ID = _campaign.CAMPAIGN_RULE_ID;
cm.CAMPAIGN_URL = Cryptographys.Encrypt(_campaign.CAMPAIGN_URL);
cm.CAMPAIGN_REDIRECT_URL = Cryptographys.Encrypt(_campaign.CAMPAIGN_REDIRECT_URL);
cm.CAMPAIGN_CONTAINER_ID = _campaign.CAMPAIGN_CONTAINER_ID;
cm.INSERTED_BY = _campaign.INSERTED_BY;
cm.INSERTED_DATE = _campaign.INSERTED_DATE;
cm.TS_CNT = _campaign.TS_CNT;
context.AddTopcms_campaign(cm);
context.SaveChanges();
Msg = "Inserted";
}
else
{
Msg = "Duplicate";
}
return(Msg);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public string UpdateCamaign(pcms_campaign _campaign)
{
string Msg = "";
try
{
using (PCMS_DbContext _pcmsDbContext = new PCMS_DbContext())
{
//Perform Update operation
pcms_campaign cm = _pcmsDbContext.pcms_campaign.Single(u => u.CAMPAIGN_ID == _campaign.CAMPAIGN_ID);
cm.CAMPAIGN_NAME = _campaign.CAMPAIGN_NAME;
cm.CAMPAIGN_DESCRIPTION = Cryptographys.Encrypt(_campaign.CAMPAIGN_DESCRIPTION);
cm.CAMPAIGN_START_DATE = Convert.ToDateTime(_campaign.CAMPAIGN_START_DATE);
cm.CAMPAIGN_END_DATE = Convert.ToDateTime(_campaign.CAMPAIGN_END_DATE);
cm.CAMPAIGN_STATUS = _campaign.CAMPAIGN_STATUS;
cm.CAMPAIGN_DESIGN_ID = _campaign.CAMPAIGN_DESIGN_ID;
cm.CAMPAIGN_CONTENT_ID = _campaign.CAMPAIGN_CONTENT_ID;
cm.CAMPAIGN_POPUP_STATUS = _campaign.CAMPAIGN_POPUP_STATUS;
cm.CAMPAIGN_POPUP_ID = _campaign.CAMPAIGN_POPUP_ID;
cm.CAMPAIGN_RULE_ID = _campaign.CAMPAIGN_RULE_ID;
cm.CAMPAIGN_URL = Cryptographys.Encrypt(_campaign.CAMPAIGN_URL);
cm.CAMPAIGN_REDIRECT_URL = Cryptographys.Encrypt(_campaign.CAMPAIGN_REDIRECT_URL);
cm.CAMPAIGN_CONTAINER_ID = _campaign.CAMPAIGN_CONTAINER_ID;
cm.INSERTED_BY = _campaign.INSERTED_BY;
cm.INSERTED_DATE = _campaign.INSERTED_DATE;
cm.TS_CNT = _campaign.TS_CNT;
_pcmsDbContext.SaveChanges();
Msg = "Updated";
return(Msg);
}
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public string AddCampain(pcms_campaign _campaign)
{
return(objDAL.InsertCampaignData(_campaign));
}
public string UpdateCamaign(pcms_campaign campaign)
{
return(objDAL.UpdateCamaign(campaign));
}