/// <summary> /// /// </summary> /// <param name="blogId"></param> /// <returns></returns> public ActionResult Edit(int? blogId = null) { if (User.Identity.IsAuthenticated == false) { Response.Redirect("~/Home/Index"); } Blog blog = new Blog(); if (blogId != null) { blog = Blog.Get(Convert.ToInt32(blogId)); } return View(blog); }
public JsonResult Save(string blog_description, string blog_title, string blog_hidden, string blog_html, string blog_start_date, string blog_end_date, int? blog_id = null) { Blog blog = new Blog(); if (blog_id != null) { blog = Blog.Get (Convert.ToInt32 (blog_id)); blog.BlogPostDate = DateTime.Now; } else { blog.BlogAuthor = User.Identity.Name; } blog.BlogDescription = blog_description; blog.BlogHidden = blog_hidden == "yes" ? true : false; blog.BlogTitle = blog_title; blog.BlogHtml = blog_html; if (blog_start_date.Length > 0) { blog.BlogStartDate = Convert.ToDateTime(blog_start_date); } if (blog_end_date.Length > 0) { blog.BlogEndDate = Convert.ToDateTime(blog_end_date); } blog.Save(); return Json (blog); }
/// <summary> /// /// </summary> /// <param name="blogId"></param> /// <returns></returns> public ActionResult View(int? blogId = null) { Blog blog = new Blog(); if (blogId != null) { blog = Blog.Get (Convert.ToInt32 (blogId)); } else { RedirectToAction ("Home", "Blog"); } return View(blog); // PartialView to return Partial }
public static void LoadParameters(SqliteCommand cmd, Blog blog) { string query = cmd.CommandText; if (query.IndexOf("@blog_id") != -1) { cmd.Parameters.Add("@blog_id", System.Data.DbType.String).Value = Convert.ToInt32(blog.BlogID); } cmd.Parameters.Add("@blog_html", System.Data.DbType.String).Value = blog.BlogHtml; cmd.Parameters.Add("@blog_hidden", System.Data.DbType.Int32).Value = Convert.ToInt32(blog.BlogHidden); if (blog.BlogDescription != null) { cmd.Parameters.Add("@blog_description", System.Data.DbType.String).Value = blog.BlogDescription; } else { cmd.Parameters.Add("@blog_description", System.Data.DbType.String).Value = DBNull.Value; } if (blog.BlogTitle != null) { cmd.Parameters.Add("@blog_title", System.Data.DbType.String).Value = blog.BlogTitle; } else { cmd.Parameters.Add("@blog_title", System.Data.DbType.String).Value = DBNull.Value; } if (blog.BlogStartDate != null) { cmd.Parameters.Add("@blog_start_date", System.Data.DbType.DateTime).Value = blog.BlogStartDate; } else { cmd.Parameters.Add("@blog_start_date", System.Data.DbType.DateTime).Value = DBNull.Value; } if (blog.BlogEndDate != null) { cmd.Parameters.Add("@blog_end_date", System.Data.DbType.DateTime).Value = blog.BlogEndDate; } else { cmd.Parameters.Add("@blog_end_date", System.Data.DbType.DateTime).Value = DBNull.Value; } if (blog.BlogAuthor != null) { cmd.Parameters.Add("@blog_author", System.Data.DbType.String).Value = blog.BlogAuthor; } else { cmd.Parameters.Add("@blog_author", System.Data.DbType.String).Value = DBNull.Value; } }
/// <summary> /// Gets a list if blogs /// </summary> /// <returns>List of blogs</returns> public static List<Blog> GetAll(int? offset, int? limit) { List<Blog> blogs = new List<Blog>(); string query = String.Format("SELECT * FROM kk_blog ORDER BY blog_id DESC "); if (limit != null) { query += String.Format ("LIMIT {0} ", limit); } if (offset != null) { query += String.Format ("OFFSET {0} ", offset); } // get database connection using (SqliteConnection conn = new SqliteConnection (ConnString)) { conn.Open(); // execute cmd using (SqliteCommand cmd = new SqliteCommand(query, conn)) { // user reader to fill data using (SqliteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Blog blog = new Blog(); Blog.DBFill(reader, blog); blogs.Add(blog); } } } } return blogs; }
/// <summary> /// Gets as single Blob by id /// </summary> /// <param name="projectId"></param> /// <returns></returns> public static Blog Get(int blogId) { Blog blog = new Blog(); string query = "SELECT * FROM kk_blog WHERE blog_id = @blog_id;"; // get database connection using (SqliteConnection conn = new SqliteConnection(ConnString)) { conn.Open(); // execute cmd using (SqliteCommand cmd = new SqliteCommand(query, conn)) { cmd.Parameters.Add("@blog_id", System.Data.DbType.Int32).Value = blogId; // user reader to fill data using (SqliteDataReader reader = cmd.ExecuteReader()) { reader.Read(); Blog.DBFill(reader, blog); } } } return blog; }
/// <summary> /// Insert /// </summary> /// <param name="reader"></param> /// <param name="project"></param> public static void DBFill(SqliteDataReader reader, Blog blog) { blog.BlogID = Convert.ToInt32(reader["blog_id"]); blog.BlogTitle = reader["blog_title"].ToString(); blog.BlogDescription = reader["blog_description"].ToString(); blog.BlogHtml = reader["blog_html"].ToString(); blog.BlogPostDate = Convert.ToDateTime(reader["blog_post_date"]); if (reader["blog_start_date"] != DBNull.Value) { blog.BlogStartDate = Convert.ToDateTime(reader["blog_start_date"]); } if (reader["blog_end_date"] != DBNull.Value) { blog.BlogEndDate = Convert.ToDateTime(reader["blog_end_date"]); } if (reader["blog_author"] != DBNull.Value) { blog.BlogAuthor = reader["blog_author"].ToString(); blog.BlogAuthorData = KK.User.GetByUserName (blog.BlogAuthor); } }