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; }