private void SaveWebPost(string fileName, PostModel model) { WebPostModel wPost = new WebPostModel() { PTitle = model.PTitle, PText = model.PText, PLink = model.PLink, PImage = model.PImage, PDate = model.PDate.ToString("yyyy-MM-ddTHH:mm:ss"), PPrice = model.PPrice }; System.IO.MemoryStream msPost = new System.IO.MemoryStream(); System.Runtime.Serialization.Json.DataContractJsonSerializer dcJsonPost = new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(WebPostModel)); dcJsonPost.WriteObject(msPost, wPost); using (System.IO.FileStream f2 = new System.IO.FileStream(fileName, System.IO.FileMode.Create)) { byte[] jsonArray = msPost.ToArray(); using (System.IO.Compression.GZipStream gz = new System.IO.Compression.GZipStream(f2, System.IO.Compression.CompressionMode.Compress)) { gz.Write(jsonArray, 0, jsonArray.Length); } } }
// GET: Api/Post/Add3 public JsonResult Add3() { PostModel model = new PostModel(); model.PDate = DateTime.Now; string fileName = Server.MapPath("~/App_Data/test3.json"); model.PText = fileName; System.Runtime.Serialization.Json.DataContractJsonSerializer ser = new System.Runtime.Serialization.Json.DataContractJsonSerializer(typeof(PostModel)); System.IO.MemoryStream stream1 = new System.IO.MemoryStream(); ser.WriteObject(stream1, model); using (System.IO.FileStream f2 = new System.IO.FileStream(fileName, System.IO.FileMode.Create)) { byte[] jsonArray = stream1.ToArray(); using (System.IO.Compression.GZipStream gz = new System.IO.Compression.GZipStream(f2, System.IO.Compression.CompressionMode.Compress)) { gz.Write(jsonArray, 0, jsonArray.Length); } } return Json(model, JsonRequestBehavior.AllowGet); }
public void Edit(PostModel model) { string commandText = @"UPDATE post SET post_link = " + SQLString(model.PLink) + @" , post_image = " + SQLString(model.PImage) + @" , post_title = " + SQLString(model.PTitle) + @" , post_text = " + SQLString(model.PText) + @" , post_price = " + SQLDecimal(model.PPrice) + @" , post_date = " + SQLDateTime(model.PDate) + @" , post_price_type_id = " + SQLInt(model.PPriceTypeId) + @" WHERE id = " + SQLInt(model.PostId); base.ExecuteNonQuery(commandText); }
public PostModel GetPost(int id) { string commandText = @"SELECT p.id , p.n_site_id , p.n_category_id , p.post_link , p.post_image , p.post_title , p.post_text , p.new_post_id , p.new_post_transaction_id , p.post_price , p.n_template_location_id , p.post_date , p.n_site_posted_id , p.post_price_type_id FROM post p WHERE p.id = " + SQLInt(id); PostModel model = null; using (DataTable dTable = base.FillDataTable(commandText)) { if( dTable.Rows.Count > 0) { DataRow dRow = dTable.Rows[0]; model = new PostModel() { PostId = TryParse.ToInt32(dRow["id"]), SiteId = TryParse.ToInt32(dRow["n_site_id"]), CategoryId = TryParse.ToInt32(dRow["n_category_id"]), PLink = TryParse.ToString(dRow["post_link"]), PImage = TryParse.ToString(dRow["post_image"]), PTitle = TryParse.ToString(dRow["post_title"]), PText = TryParse.ToString(dRow["post_text"]), PPrice = TryParse.ToDecimal(dRow["post_price"]), TemplateLocationId = TryParse.ToInt32(dRow["n_template_location_id"]), PDate = TryParse.ToDateTime(dRow["post_date"]), SitePostedId = TryParse.ToInt32(dRow["n_site_posted_id"]), PPriceTypeId = TryParse.ToInt32(dRow["post_price_type_id"]) }; } } return model; }
public ActionResult Edit(PostModel model, string redirectUrl = "") { if (!ModelState.IsValid) { using (Contexts.PostContext context = new Contexts.PostContext()) { ViewBag.PostPriceTypes = context.GetPostPriceTypes(true); } return View("Edit", model); } else { using (Contexts.PostContext context = new Contexts.PostContext()) { context.Edit(model); } return Redirect(redirectUrl); } }