public ActionResult EditPage(string pid)
{
if (!User.Identity.IsAuthenticated)
return RedirectToAction("LogOn", "Account");
if (pid != null)
{
var scope = ObjectScopeProvider1.GetNewObjectScope();
var pages = (from c in scope.GetOqlQuery<ContentPage>().ExecuteEnumerable()
where c.Id != null && c.Id.Equals(pid)
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");
}
public ActionResult EditPage(PageModel pageModel)
{
if (!User.Identity.IsAuthenticated)
return RedirectToAction("LogOn", "Account");
if (ModelState.IsValid)
{
var scope = ObjectScopeProvider1.GetNewObjectScope();
var pages = (from c in scope.GetOqlQuery<ContentPage>().ExecuteEnumerable()
where c.Id != null && c.Id.Equals(pageModel.ID)
select c).ToList();
foreach (ContentPage page in pages)
{
scope.Transaction.Begin();
page.Name = pageModel.PageTitle;
page.Content = pageModel.Content;
scope.Add(page);
scope.Transaction.Commit();
try
{
using (var connection = new SqlConnection("Data Source=208.91.198.196;Initial Catalog=admin_hopestrack;Persist Security Info=True;User ID=hopestrack;Password=password@123"))
{
connection.Open();
string qry = "update content_page set [<_content>k___backing_field] = '" + pageModel.Content + "' 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 AddPage(PageModel adPageModel)
{
if (!User.Identity.IsAuthenticated)
return RedirectToAction("LogOn", "Account");
if (ModelState.IsValid)
{
var scope = ObjectScopeProvider1.GetNewObjectScope();
var contentPage = new ContentPage { Name = adPageModel.PageTitle, Content = adPageModel.Content, Id = DateTime.Now.Ticks.ToString() };
scope.Transaction.Begin();
scope.Add(contentPage);
scope.Transaction.Commit();
try
{
using (var connection = new SqlConnection("Data Source=208.91.198.196;Initial Catalog=admin_hopestrack;Persist Security Info=True;User ID=hopestrack;Password=password@123"))
{
connection.Open();
string qry = "update content_page set [<_content>k___backing_field] = '" + adPageModel.Content + "' 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);
}