public Menu()
{
ParentId = string.Empty;
Id = DateTime.Now.ToString("yyddmmHHss");
Page = new ContentPage();
}
public ActionResult AddPage(PageModel adPageModel)
{
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 contentPage = new ContentPage { Name = adPageModel.PageTitle, Content = adPageModel.Content, Id = DateTime.Now.Ticks.ToString(), DomainName = domain };
scope.Transaction.Begin();
scope.Add(contentPage);
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] = '" + adPageModel.Content.Replace("'", "''") + "' where [<_id>k___backing_field]='" + contentPage.Id + "'";
var command = new SqlCommand(qry, connection);
command.ExecuteNonQuery();
connection.Close();
}
}
catch (Exception)
{
LoadPages();
return View("Pages");
}
LoadPages();
return View("Pages");
}
return View(adPageModel);
}