/// <summary> /// Returns a view to edit a Content object /// </summary> /// <param name="contentID"></param> /// <returns></returns> public ActionResult Edit(int? contentID = null) { KK.Models.Content content = new Content(); if (contentID != null) { if (!Request.IsAuthenticated || !User.IsInRole("admin")) { return RedirectToAction("Index", "Home"); } content = KK.Models.Content.Get(Convert.ToInt32(contentID)); } return PartialView(content); }
public ContentResult Save(string contentController, string contentAction, string contentTitle, string contentHtml, int? contentID, int? photoID) { KK.Models.Content content = new Models.Content(); if (contentID != null) { content = KK.Models.Content.Get(Convert.ToInt32(contentID)); } else { content.ContentAdded = DateTime.Now; content.ContentAddedBy = User.Identity.Name; } content.ContentPhotoID = photoID; content.ContentUpdated = DateTime.Now; content.ContentUpdatedBy = User.Identity.Name; content.ContentAction = contentAction; content.ContentController = contentController; content.ContentTitle = contentTitle; content.ContentHtml = contentHtml; content.Save(); string result = string.Format("{{ \"Result\" : \"success\", \"Data\" : {{ \"ContentID\" :{0} }} }}", content.ContentID); return new ContentResult { Content = result }; }
/// <summary> /// Gets as single project by id /// </summary> /// <param name="projectId"></param> /// <returns></returns> public static Content Get(string controller, string action, string title) { Content content = new Content(); string query = @"SELECT * FROM kk_content WHERE content_action = @action AND content_controller = @controller AND content_title = @title"; // get database connection using (SqliteConnection conn = new SqliteConnection(connectionString)) { conn.Open(); using (SqliteCommand cmd = new SqliteCommand(query, conn)) { cmd.Parameters.Add("@action", System.Data.DbType.String).Value = action; cmd.Parameters.Add("@controller", System.Data.DbType.String).Value = controller; cmd.Parameters.Add("@title", System.Data.DbType.String).Value = title; // user reader to fill data using (SqliteDataReader reader = cmd.ExecuteReader()) { reader.Read(); Content.DBFill(reader, content); } } } return content; }
public static Content Get(int contentId) { Content content = new Content(); string query = "SELECT * FROM kk_content WHERE content_id = @id;"; // get database connection using (SqliteConnection conn = new SqliteConnection(connectionString)) { conn.Open(); // execute cmd using (SqliteCommand cmd = new SqliteCommand(query, conn)) { cmd.Parameters.Add("@id", System.Data.DbType.Int32).Value = contentId; // user reader to fill data using (SqliteDataReader reader = cmd.ExecuteReader()) { reader.Read(); Content.DBFill(reader, content); } } } return content; }
/// <summary> /// Insert /// </summary> /// <param name="reader"></param> /// <param name="project"></param> public static void DBFill(SqliteDataReader reader, Content content) { content.ContentID = Convert.ToInt32(reader["content_id"]); content.ContentAction = reader["content_action"].ToString(); content.ContentController = reader["content_controller"].ToString(); if (reader["content_title"] != DBNull.Value) { content.ContentTitle = reader["content_title"].ToString(); } if (reader["content_photo_id"] != DBNull.Value) { content.ContentPhotoID = Convert.ToInt32(reader["content_photo_id"]); } content.ContentHtml = HttpUtility.UrlDecode(reader["content_html"].ToString(), System.Text.Encoding.Default); content.ContentUpdatedBy = reader["content_updated_by"].ToString(); content.ContentUpdated = Convert.ToDateTime(reader["content_updated_dt"]); content.ContentAddedBy = reader["content_added_by"].ToString(); content.ContentAdded = Convert.ToDateTime(reader["content_added_dt"]); content.ContentItems = ContentItem.GetAll(Convert.ToInt32(content.ContentID)); }