public ActionResult AddContent(pcms_content content, FormCollection col)
{
try
{
content.INSERTED_DATE = DateTime.Now;
content.TS_CNT = 0;
content.INSERTED_BY = Session["userKey"].ToString();
var res = objBAL.AddContent(content);
if (res.Contains("Inserted"))
{
return(RedirectToAction("Content"));
}
else if (res.Contains("Duplicate"))
{
ViewBag.Error = "Content Name must be unique";
return(View());
}
else
{
ViewBag.Error = "Something went wrong while adding content";
return(View());
}
}
catch (Exception ex)
{
ErrorLog obj = new ErrorLog();
obj.LogError(ex);
return(null);
}
}
public string DeleteContent(int query)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
pcms_content content = context.pcms_content.Single(x => x.CONTENT_ID == query);
context.pcms_content.DeleteObject(content);
context.SaveChanges();
Msg = "Deleted";
return(Msg);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public string UpdateContent(pcms_content _content)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
pcms_content nUser = context.pcms_content.Single(u => u.CONTENT_ID == _content.CONTENT_ID);
nUser.CONTENT_DESCRIPTION = Cryptographys.Encrypt(_content.CONTENT_DESCRIPTION);
nUser.CONTENT_HTML = Cryptographys.Encrypt(_content.CONTENT_HTML);
context.SaveChanges();
Msg = "Updated";
return(Msg);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public pcms_content EditContent(int query)
{
try
{
pcms_content _content = new pcms_content();
PCMS_DbContext context = new PCMS_DbContext();
var res = context.pcms_content.Single(content => content.CONTENT_ID == query);
_content.CONTENT_ID = res.CONTENT_ID;
_content.CONTENT_NAME = Cryptographys.Decrypt(res.CONTENT_NAME);
_content.CONTENT_DESCRIPTION = Cryptographys.Decrypt(res.CONTENT_DESCRIPTION);
_content.CONTENT_HTML = Cryptographys.Decrypt(res.CONTENT_HTML);
_content.INSERTED_BY = res.INSERTED_BY;
_content.INSERTED_DATE = res.INSERTED_DATE;
_content.CONTENT_ISDELETED = res.CONTENT_ISDELETED;
_content.TS_CNT = res.TS_CNT;
return(_content);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
return(null);
}
}
public string AddContent(pcms_content _Content)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
if (!context.pcms_campaign.Any(u => u.CAMPAIGN_NAME == _Content.CONTENT_NAME))
{
pcms_content cn = new pcms_content();
cn.CONTENT_PK = Guid.NewGuid();
cn.CONTENT_NAME = Cryptographys.Encrypt(_Content.CONTENT_NAME);
cn.CONTENT_DESCRIPTION = Cryptographys.Encrypt(_Content.CONTENT_DESCRIPTION);
cn.CONTENT_HTML = Cryptographys.Encrypt(_Content.CONTENT_HTML);
cn.INSERTED_BY = _Content.INSERTED_BY;
cn.INSERTED_DATE = _Content.INSERTED_DATE;
cn.CONTENT_ISDELETED = _Content.CONTENT_ISDELETED;
cn.TS_CNT = _Content.TS_CNT;
context.AddTopcms_content(cn);
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 ActionResult EditContent(pcms_content _content)
{
try
{
_content.TS_CNT = 1;
_content.UPDATED_DATE = DateTime.Now;
_content.UPDATED_BY = Convert.ToString(Session["userKey"]);
var Resultset = objBAL.UpdateContent(_content);
if (Resultset.Contains("Updated"))
{
return(RedirectToAction("Content", "Home", null));
}
else
{
return(RedirectToAction("Content", "Home", null));
}
}
catch (Exception ex)
{
ErrorLog obj = new ErrorLog();
obj.LogError(ex);
return(null);
}
}
public string UpdateContent(pcms_content _content)
{
return(objDAL.UpdateContent(_content));
}
public string AddContent(pcms_content _Content)
{
return(objDAL.AddContent(_Content));
}
