public Response AddNewStaticPage(StaticPage p)
{
_response = new Response();
var staticPage = _repo.AddNewStaticPage(p);
if (staticPage != null)
{
_response.Success = true;
_response.StaticPage = staticPage;
}
return _response;
}
public void TestAddNewStaticPage()
{
var page = new StaticPage();
page.StaticPageId = 1;
page.StaticPageTitle = "About JSDate";
page.StaticPageText = "<p>From the creators of JDate, the premier online dating service for Jewish-singles, comes a new venture aimed at connecting hearts among individuals who share this one similar passion: coding.</p>" +
"< p > We are JSDate and we aim to \"plug\" you in with the coding & ldquo; partner & rdquo; of your dreams.</ p >" +
"< p > Get ready to take your “ paired - programming & rdquo; to the next level...</ p > ";
page.Status = PageStatus.Approved;
page.User.Id = "74e60034-4ccf-4421-96cd-847d1aa2908a";
page.TimeCreated = DateTime.Parse("2015-12-07 12:01:39.170");
Assert.AreEqual(true, _ops.AddNewStaticPage(page).Success);
}
public Response()
{
Users = new List <ApplicationUser>();
IdUserRoles = new List <IdentityUserRole>();
IdRoles = new List <IdentityRole>();
Hashtag = new Hashtag();
Hashtags = new List <Hashtag>();
BlogPost = new BlogPost();
BlogPosts = new List <BlogPost>();
StaticPage = new StaticPage();
StaticPages = new List <StaticPage>();
Category = new Category();
Categories = new List <Category>();
User = new ApplicationUser();
BlogStats = new BlogStats();
}
public Response()
{
Users = new List<ApplicationUser>();
IdUserRoles = new List<IdentityUserRole>();
IdRoles = new List<IdentityRole>();
Hashtag = new Hashtag();
Hashtags = new List<Hashtag>();
BlogPost = new BlogPost();
BlogPosts = new List<BlogPost>();
StaticPage = new StaticPage();
StaticPages = new List<StaticPage>();
Category = new Category();
Categories = new List<Category>();
User = new ApplicationUser();
BlogStats = new BlogStats();
}
public StaticPage AddNewStaticPage(StaticPage newPage)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
p.Add("@UserID", newPage.User.Id);
p.Add("@StaticPageTitle", newPage.StaticPageTitle);
p.Add("@StaticPageText", newPage.StaticPageText);
p.Add("@TimeCreated", newPage.TimeCreated);
p.Add("@Status", (int)newPage.Status);
p.Add("@StaticPageID", DbType.Int32, direction: ParameterDirection.Output);
cn.Execute("AddNewStaticPage", p, commandType: CommandType.StoredProcedure);
newPage.StaticPageId = p.Get<int>("StaticPageID");
}
newPage = GetStaticPageById(newPage.StaticPageId);
return newPage;
}
private StaticPage PopulateStaticPageFromReader(SqlDataReader dr)
{
StaticPage staticPage = new StaticPage();
staticPage.StaticPageId = (int)dr["StaticPageID"];
staticPage.StaticPageTitle = dr["StaticPageTitle"].ToString();
staticPage.StaticPageText = dr["StaticPageText"].ToString();
staticPage.TimeCreated = DateTime.Parse(dr["TimeCreated"].ToString());
staticPage.Status = (PageStatus)dr["Status"];
staticPage.User = PopulateUserFromDataReader(dr);
return staticPage;
}
public StaticPage UpdateStaticPageStatus(int staticPageId, PageStatus updateStaticPageStatus)
{
StaticPage staticPage = new StaticPage();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "UpdateStaticPageStatus";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StaticPageID", staticPageId);
cmd.Parameters.AddWithValue("@Status", (int)updateStaticPageStatus);
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
staticPage = PopulateStaticPageFromReader(dr);
}
}
}
return staticPage;
}
public StaticPage GetStaticPageById(int staticPageId)
{
StaticPage page = new StaticPage();
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var cmd = new SqlCommand();
cmd.CommandText = "GetPageByID";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
cmd.Parameters.AddWithValue("@staticPageID", staticPageId);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
page = PopulateStaticPageFromReader(dr);
}
}
}
return page;
}
public StaticPage EditStaticPage(StaticPage page)
{
using (SqlConnection cn = new SqlConnection(Settings.ConnectionString))
{
var p = new DynamicParameters();
p.Add("@StaticPageID", page.StaticPageId);
p.Add("@StaticPageTitle", page.StaticPageTitle);
p.Add("@StaticPageText", page.StaticPageText);
p.Add("@Status", page.Status);
cn.Execute("EditStaticPage", p, commandType: CommandType.StoredProcedure);
}
page = GetStaticPageById(page.StaticPageId);
return page;
}
public AddStaticPageVM()
{
StaticPage = new StaticPage();
}
public void AddNewStaticPageTest()
{
StaticPage staticPage = new StaticPage()
{
User = new ApplicationUser()
{
Id = "74e60034-4ccf-4421-96cd-847d1aa2908a"
},
StaticPageTitle = "About 2SB&D",
StaticPageText = "<p>\"Two Sweet Boys and Dean\" is a start-up dating service based in Akron, Ohio.</p>" +
"<p> Dean is a struggling DJ with a hidden passion for Bootstrap.Tim is a sweet boy who dreams of one day moving to the big city...of Seattle.Patrick is also a sweet boy who can't resist the \"back-end\".</p>" +
"<p> Together, we are here to help them find the \"coding partners\" of their dreams.</p> ",
Status = PageStatus.Approved,
TimeCreated = DateTime.Parse("2015-12-07 21:20:10")
};
var actual = _repo.AddNewStaticPage(staticPage);
Assert.AreEqual(staticPage.User.Id, actual.User.Id);
Assert.AreEqual(staticPage.StaticPageTitle, actual.StaticPageTitle);
Assert.AreEqual(staticPage.StaticPageText, actual.StaticPageText);
Assert.AreEqual(staticPage.Status, actual.Status);
Assert.AreEqual(staticPage.TimeCreated, actual.TimeCreated);
}
public Response EditStaticPage(StaticPage page)
{
_response = new Response();
var staticPage = _repo.EditStaticPage(page);
if (staticPage != null)
{
_response.Success = true;
_response.StaticPage = staticPage;
}
return _response;
}
