public string UpdateUrlList(string weburl, string insertby, DateTime insertdate, int tscnt, string url)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
pcms_rules objRules = new pcms_rules();
objRules.RULE_APPLIED_URL = Cryptographys.Encrypt(url);
objRules.INSERTED_BY = insertby;
objRules.INSERTED_DATE = insertdate;
objRules.WEBSITE_URL = Cryptographys.Encrypt(weburl);
objRules.TS_CNT = tscnt;
objRules.RULE_PK = Guid.NewGuid();
context.AddTopcms_rules(objRules);
context.SaveChanges();
Msg = "Inserted";
return(Msg);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public string SaveURL(string usr, string url, string usrby)
{
string Msg = "";
try
{
using (PCMS_DbContext _pcmsDbContext = new PCMS_DbContext())
{
pcms_rules objRules = new pcms_rules();
objRules.WEBSITE_URL = Cryptographys.Encrypt(usr);
objRules.RULE_APPLIED_URL = Cryptographys.Encrypt(url);
objRules.INSERTED_BY = usrby;
objRules.INSERTED_DATE = DateTime.Now;
objRules.TS_CNT = 1;
objRules.RULE_PK = Guid.NewGuid();
_pcmsDbContext.AddTopcms_rules(objRules);
_pcmsDbContext.SaveChanges();
Msg = "Inserted";
return(Msg);
}
}
catch (Exception ex)
{
return(Msg = ex.Message);
}
}
public ActionResult Rules(FormCollection formData)
{
if (Session["userKey"] != null)
{
try
{
pcms_rules rules = new pcms_rules();
rules.RULE_APPLIED_URL = TempData["RULE_APPLIED_URL"].ToString();
rules.RULE_ID = Convert.ToInt16(TempData["QUERY"].ToString());
rules.RULE_NAME = formData["rule-name"];
rules.RULE_LOCATION = formData["location"];
rules.RULE_PARAMETER_KEY_VALUE = formData["parameter_list"];
rules.RULE_USER_TYPE = formData["user"];
rules.INSERTED_BY = Session["userKey"].ToString();
rules.INSERTED_DATE = DateTime.Now;
rules.WEBSITE_URL = formData["WEBSITE_URL"].ToString();
rules.TS_CNT = 0;
rules.RULE_ISDELETED = false;
var Data = objBAL.updateRules(rules);
var result = TempData["Filter"];
TempData.Keep();
if (Data.Contains("Inserted"))
{
ViewBag.Message = "New rule has been added";
return(View(result));
}
else if (Data.Contains("Duplicate"))
{
ViewBag.Message = "Rule name must be unique";
return(View(result));
}
else
{
ViewBag.Message = "Something went wrong while adding rule";
return(View(result));
}
}
catch (Exception ex)
{
ErrorLog obj = new ErrorLog();
obj.LogError(ex);
return(null);
}
}
else
{
return(RedirectToAction("Index", "Account", null));
}
}
public string AddWebsite(pcms_List list)
{
string Msg = "";
try
{
using (PCMS_DbContext _pcmsDbContext = new PCMS_DbContext())
{
string url = list.url[0].WEBSITE_URL;
if (_pcmsDbContext.pcms_website.Any(u => u.WEBSITE_URL == url))
{
return(Msg = "Duplicate");
}
else
{
pcms_website objWebsite = new pcms_website();
objWebsite.WEBSITE_URL = list.url[0].WEBSITE_URL;
objWebsite.WEBSITE_SITEMAP_URL = list.url[0].WEBSITE_SITEMAP_URL != null ? list.url[0].WEBSITE_SITEMAP_URL : "";
objWebsite.SDK_VERIFIED = Convert.ToBoolean(list.url[0].SDK_VERIFIED);
objWebsite.INSERTED_BY = list.url[0].INSERTED_BY;
objWebsite.INSERTED_DATE = list.url[0].INSERTED_DATE;
objWebsite.TS_CNT = list.url[0].TS_CNT;
objWebsite.WEBSITE_PK = Guid.NewGuid();
pcms_rules objRules = new pcms_rules();
string webmap = list.url[0].WEBSITE_URL != null?Cryptographys.Encrypt(list.url[0].WEBSITE_URL) : "";
objRules.RULE_APPLIED_URL = webmap;
objRules.INSERTED_BY = list.url[0].INSERTED_BY;
objRules.INSERTED_DATE = list.url[0].INSERTED_DATE;
objRules.WEBSITE_URL = Cryptographys.Encrypt(list.url[0].WEBSITE_URL);
objRules.TS_CNT = list.url[0].TS_CNT;
objRules.RULE_PK = Guid.NewGuid();
_pcmsDbContext.AddTopcms_website(objWebsite);
_pcmsDbContext.AddTopcms_rules(objRules);
_pcmsDbContext.SaveChanges();
Msg = "Inserted";
return(Msg);
}
}
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public ActionResult URLList(pcms_rules rules)
{
string url = "";
if (!string.IsNullOrEmpty(Convert.ToString(TempData["url"])))
{
url = TempData["url"].ToString();
}
else
{
url = "";
}
var ResultSet = objBAL.getUrlList(url);
TempData.Keep();
return(View(ResultSet));
}
public string DeleteRules(string query)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
pcms_rules rule = context.pcms_rules.Single(x => x.RULE_ID == Convert.ToInt16(query));
context.pcms_rules.DeleteObject(rule);
context.SaveChanges();
Msg = "Deleted";
return(Msg);
}
catch (Exception ex)
{
Utilities objUtilities = new Utilities();
objUtilities.LogError(ex);
Msg = "Something went wrong";
return(null);
}
}
public string updateRules(pcms_rules Rule)
{
string Msg = "";
try
{
PCMS_DbContext context = new PCMS_DbContext();
if (!context.pcms_rules.Any(u => u.RULE_NAME == Rule.RULE_NAME))
{
pcms_rules pu = new pcms_rules();
pu.RULE_NAME = Cryptographys.Encrypt(Rule.RULE_NAME);
pu.RULE_LOCATION = Rule.RULE_LOCATION;
pu.RULE_USER_TYPE = Rule.RULE_USER_TYPE;
pu.RULE_PK = Guid.NewGuid();
pu.RULE_PARAMETER_KEY_VALUE = Rule.RULE_PARAMETER_KEY_VALUE;
pu.RULE_APPLIED_URL = Cryptographys.Encrypt(Rule.RULE_APPLIED_URL);
pu.RULE_ISDELETED = Rule.RULE_ISDELETED;
pu.INSERTED_BY = Rule.INSERTED_BY;
pu.INSERTED_DATE = Rule.INSERTED_DATE;
pu.WEBSITE_URL = Cryptographys.Encrypt(Rule.WEBSITE_URL);
pu.TS_CNT = Rule.TS_CNT;
context.AddTopcms_rules(pu);
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 updateRules(pcms_rules rule)
{
return(objDAL.updateRules(rule));
}
