public ActionResult EditPage(PageModel pageModel)
{
if (!User.Identity.IsAuthenticated)
return RedirectToAction("LogOn", "Account");
string domain = Utilities.GetMyDomain(Request.Url);
var scope = ObjectScopeProvider1.GetNewObjectScope();
var users = (from c in scope.GetOqlQuery<UserAuthentication>().ExecuteEnumerable()
where
c.Username.ToLower().Equals(User.Identity.Name.ToLower()) &&
c.Domain.ToLower().Equals(domain.ToLower())
select c).ToList();
if (users.Count == 0)
{
ViewData["Status"] = "You are not authorized for this domain [" + domain + "] control panel.";
return View("Status");
}
if (ModelState.IsValid)
{
var pages = (from c in scope.GetOqlQuery<ContentPage>().ExecuteEnumerable()
where c.Id != null && c.Id.Equals(pageModel.Id) && c.DomainName != null && c.DomainName.ToLower().Equals(domain.ToLower())
select c).ToList();
foreach (ContentPage page in pages)
{
scope.Transaction.Begin();
page.Name = pageModel.PageTitle;
page.Content = pageModel.Content;
page.DomainName = domain;
scope.Add(page);
scope.Transaction.Commit();
try
{
using (var connection = new SqlConnection("Data Source=208.91.198.196;Initial Catalog=admin_domain2hostcms;Persist Security Info=True;User ID=domain2hostcms;Password=password@123"))
{
connection.Open();
string qry = "update content_page set [<_content>k___backing_field] = '" + pageModel.Content.Replace("'", "''") + "' where [<_id>k___backing_field]='" + page.Id + "'";
var command = new SqlCommand(qry, connection);
command.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception)
{
continue;
}
break;
}
LoadPages();
return View("Pages");
}
return View(pageModel);
}
public ActionResult EditPage(string pid)
{
if (!User.Identity.IsAuthenticated)
return RedirectToAction("LogOn", "Account");
string domain = Utilities.GetMyDomain(Request.Url);
var scope = ObjectScopeProvider1.GetNewObjectScope();
var users = (from c in scope.GetOqlQuery<UserAuthentication>().ExecuteEnumerable()
where
c.Username.ToLower().Equals(User.Identity.Name.ToLower()) &&
c.Domain.ToLower().Equals(domain.ToLower())
select c).ToList();
if (users.Count == 0)
{
ViewData["Status"] = "You are not authorized for this domain [" + domain + "] control panel.";
return View("Status");
}
if (pid != null)
{
var pages = (from c in scope.GetOqlQuery<ContentPage>().ExecuteEnumerable()
where c.Id != null && c.Id.Equals(pid) && c.DomainName != null && c.DomainName.ToLower().Equals(domain.ToLower())
select c).ToList();
var contentPage = new PageModel();
foreach (ContentPage page in pages)
{
contentPage.PageTitle = page.Name;
contentPage.Content = page.Content;
contentPage.Id = page.Id;
break;
}
return View(contentPage);
}
return RedirectToAction("Pages");
}
