public List <blogModel> getUsersBlogList(blogModel blogParams) { using (DAL db = new DAL()) { List <blogModel> lsblog = new List <blogModel>(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_GetUsersBlogList"; cmd.Parameters.AddWithValue("@showOnHomePage", Convert.ToBoolean(blogParams.onHomePage)); DataSet ds = db.ReturnDataset(cmd); foreach (DataRow item in ds.Tables[0].Rows) { blogModel data = new blogModel(); lsblog.Add(data); } return(lsblog); } catch (Exception ex) { throw ex; } } }
public static int Editblog(int num, string heading, string body) { blogModel data = new blogModel { num = num, heading = heading, body = body }; string sql = "update dbo.BlogData set heading='" + data.heading + "',body='" + data.body + "' where num=" + data.num + ";"; return(SqlDataAccess.EditData <blogModel>(sql)); }
public static int Createblog(int num, string heading, string body) { blogModel data = new blogModel { num = num, heading = heading, body = body }; string sql = "insert into dbo.BlogData (num,heading,body) values (" + data.num + ",'" + data.heading + "','" + data.body + "');"; return(SqlDataAccess.SaveData <blogModel>(sql)); }
public BlogModel GetBlogById(int id) { blogModel data = LoadBlog(id); BlogModel blog = new BlogModel { ID = data.num, BlogHeader = data.heading, BlogBody = data.body }; return(blog); }
public ActionResult createBlog(int?id, blogModel AddBlog) { var blog = _context.blogs.Find(id); //if (blog != null) //{ // System.Diagnostics.Debug.WriteLine("update function"); //} //else //{ // System.Diagnostics.Debug.WriteLine("date function"); // _context.blogs.Add(AddBlog); // System.Diagnostics.Debug.WriteLine("Done"); //} return(View(blog)); }
public ActionResult Save(blogModel blogm) { var blog = _context.blogs.Find(blogm.blogId); if (blog != null) { blog.blogTitle = blogm.blogTitle; blog.blogText = blogm.blogText; System.Diagnostics.Debug.WriteLine("update function", blogm.blogId); System.Diagnostics.Debug.WriteLine("id dd", blogm.blogId); } else { System.Diagnostics.Debug.WriteLine("date function"); _context.blogs.Add(blogm); System.Diagnostics.Debug.WriteLine("Done"); } _context.SaveChanges(); return(RedirectToAction("blogView", "blog")); }
public List <blogModel> getAdminBlogsList() { using (DAL db = new DAL()) { List <blogModel> lsblog = new List <blogModel>(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "sp_GetAdminBlogsList"; DataSet ds = db.ReturnDataset(cmd); foreach (DataRow item in ds.Tables[0].Rows) { blogModel data = new blogModel(); lsblog.Add(data); } return(lsblog); } catch (Exception ex) { throw ex; } } }