public StaticPage GetStaticPageById(int staticPageId)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var cmd =
new SqlCommand(
"Select p.UserID, p.StaticPageContent,p.StatusID,s.StatusType, p.DateOfPageCreation, p.StaticPageTitle, p.StaticPageID from StaticPage p inner join [Status] s on p.StatusID= s.StatusID where p.StaticPageID = StaticPageID order by p.DateOfPageCreation desc",
cn);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var staticPage = new StaticPage();
{
//Status = new Status(),
//User = new User()
};
staticPage.User.UserId= dr.GetString(0);
staticPage.StaticPageContent = dr.GetString(1);
staticPage.Status.StatusID = dr.GetInt32(2);
staticPage.Status.StatusType = dr.GetString(3);
staticPage.DateOfPageCreation = dr.GetDateTime(4);
staticPage.StaticPageTitle = dr.GetString(5);
staticPage.StaticPageID = dr.GetInt32(6);
return staticPage;
}
}
}
return null;
}
public void SaveStaticPageDBTest()
{
var repo = new StaticPageRepo();
StaticPage staticPage = new StaticPage()
{
User = new User()
{
UserId = "f319beb5-8a14-40c1-9cb5-0d6c92571ae4"
},
StaticPageContent = "<p>Do not do things</p>",
StaticPageTitle = "Static Page Number 1",
Status = new Status() { StatusID = 1 },
DateOfPageCreation = DateTime.Now
};
repo.SaveStaticPage(staticPage);
var list = repo.GetAllStaticPages();
Assert.AreEqual(1, list.Count);
Assert.AreEqual("Static Page Number 1", list.FirstOrDefault(x => x.StaticPageID == 1).StaticPageTitle);
}
public List<StaticPage> GetAllStaticPages()
{
var staticPages = new List<StaticPage>();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand("Select p.UserId, p.StaticPageContent, p.StatusID, s.StatusType, p.DateOfPageCreation, p.StaticPageTitle, p.StaticPageID from StaticPage p inner join [Status] s on p.StatusID= s.StatusID order by p.DateOfPageCreation desc", cn);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var staticPage = new StaticPage()
{
Status = new Status(),
User = new User()
};
staticPage.User.UserId = dr.GetString(0);
staticPage.StaticPageContent= dr.GetString(1);
staticPage.Status.StatusID = dr.GetInt32(2);
staticPage.Status.StatusType = dr.GetString(3);
staticPage.DateOfPageCreation = dr.GetDateTime(4);
staticPage.StaticPageTitle = dr.GetString(5);
staticPage.StaticPageID = dr.GetInt32(6);
staticPages.Add(staticPage);
}
}
}
var repo = new UserRepo();
foreach (var page in staticPages)
{
var id = page.User.UserId;
page.User = repo.GetUserById(id);
page.User.UserId = id;
}
return staticPages;
}
public ActionResult CreateStaticPages(StaticPageVM model)
{
var staticPage = new StaticPage();
staticPage = model.NewPage;
staticPage.StaticPageContent = model.HtmlContent;
if (model.NewPage.Status == null)
{
staticPage.Status = new Status()
{
StatusID = 1
};
}
else
{
staticPage.Status.StatusID = model.NewPage.Status.StatusID;
}
var ops = OperationsFactory.CreateStaticPageOps();
ops.SaveStaticPage(staticPage);
return RedirectToAction("Index", "Home");
}
public void SaveStaticPage(StaticPage staticPage)
{
if (staticPage.DateOfPageCreation > new DateTime(01 / 01 / 2000))
_repo.SaveStaticPage(staticPage);
}
public void SaveStaticPage(StaticPage staticPage)
{
}
public void SaveStaticPage(StaticPage staticPage)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
p.Add("@UserId", staticPage.User.UserId);
p.Add("@StaticPageContent", staticPage.StaticPageContent);
p.Add("@StatusID", staticPage.Status.StatusID);
p.Add("@DateOfPageCreation", staticPage.DateOfPageCreation);
p.Add("@StaticPageTitle", staticPage.StaticPageTitle);
cn.Query("SaveStaticPage", p, commandType: CommandType.StoredProcedure);
}
}