public static object UpdateNews(tbl_News model, string NgayDeliverConvert) { var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); var obj = new GCRequest { _a = "Updatetbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name _d = new Dictionary <string, object> { { "NewsTypeId", model.NewsTypeId }, { "KieuString1", model.KieuString1 }, { "NgayDeliver", WebsiteExtension.ConvertDate(NgayDeliverConvert) }, { "Name", model.Name }, { "ShortContentNews", model.ShortContentNews }, { "hinhanhImageSample", model.hinhanhImageSample }, { "TagName", model.TagName }, { "UpdateDate", DateTime.Now }, { "UpdateStaffId", HttpContext.Current.Session["UserID"] }, { "ContentNews", model.ContentNews } }, _c = new Dictionary <string, object> { { "Id", model.Id }, { "Status", 1 } } }; var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content } return(robj.Result); }
public async Task <IHttpActionResult> Posttbl_News(tbl_News tbl_News) { LogApi.Log(User.Identity.GetUserId(), "PostNews " + User.Identity.GetUserName()); tbl_News.col_NewsDateTime = DateTime.Now; if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tbl_News.Add(tbl_News); await db.SaveChangesAsync(); try { var tokens = db.tbl_DeviceIds; foreach (var d in tokens) { Notifications.NotifyAsync(d.col_DeviceToken, "News", "News: " + tbl_News.col_News); } } catch (Exception ex) { } return(Ok("Posted")); }
public static object PostNews(tbl_News model) { if (model.ContentNews != null) { model.ContentNews.Replace('\'', '\"'); } var service = new S(ConfigurationManager.ConnectionStrings["CotoidayCon"].ConnectionString, true); var obj = new GCRequest { _a = "Inserttbl_News", //Action prefix f,p for get data; tbl_PT_MailBox is table name _d = new Dictionary <string, object> { { "NewsTypeId", model.NewsTypeId }, { "KieuString1", model.KieuString1 }, { "NgayDeliver", DateTime.Now }, { "Name", model.Name }, { "ShortContentNews", model.ShortContentNews }, { "hinhanhImageSample", model.hinhanhImageSample }, { "TagName", model.TagName }, { "ContentNews", model.ContentNews }, { "CreateDate", DateTime.Now }, { "CreateStaffId", HttpContext.Current.Session["UserID"] } } }; var robj = service.P(obj); // {Result: 0 is failed, 1 is success, Records: List object array, TotalRecordCount: number of records, Message: error content } return(robj.Result); }
public ActionResult AddNews(tbl_News md) { var model = NewsService.PostNews(md); ViewBag.Success = model; return(View()); }
public async Task <IHttpActionResult> Puttbl_News(int id, tbl_News tbl_News) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tbl_News.col_NewsID) { return(BadRequest()); } db.Entry(tbl_News).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tbl_NewsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
/// <summary> /// Thêm mới tin tức /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddNews(tbl_News model) { model.NewID = AutoIDNew(); model.View = 0; model.Status = true; db.tbl_News.Add(model); db.SaveChanges(); return(true); }
public async Task <IHttpActionResult> Gettbl_News(int id) { tbl_News tbl_News = await db.tbl_News.FindAsync(id); if (tbl_News == null) { return(NotFound()); } return(Ok(tbl_News)); }
/// <summary> /// Cập nhật tin tức. /// </summary> /// <param name="model"></param> /// <returns></returns> public bool CapNhat(tbl_News model) { var result = db.tbl_News.Find(model.NewID); result.Title = model.Title; result.MetaTitle = model.MetaTitle; result.Image = model.Image; result.SummaryText = model.SummaryText; result.Content = model.Content; result.ModifyBy = model.ModifyBy; result.ModifyDate = model.ModifyDate; db.SaveChanges(); return(true); }
public async Task <IHttpActionResult> Deletetbl_News(int id) { LogApi.Log(User.Identity.GetUserId(), "DeleteNews " + User.Identity.GetUserName()); tbl_News tbl_News = await db.tbl_News.FindAsync(id); if (tbl_News == null) { return(NotFound()); } db.tbl_News.Remove(tbl_News); await db.SaveChangesAsync(); return(Ok("Deleted")); }
public async Task <IActionResult> Update(tbl_News model) { if (!ModelState.IsValid) { return(Json(new { status = 100, //you can see the datails of status code in ~/Global/statusCodes errors = ModelState.Values.Where(e => e.Errors.Count > 0).ToList(), message = "لطفا در وارد کردن اطلاعات دقت کنید" })); } var news = await db.News.FindAsync(model.Id); if (news != null) { news.Title = model.Title; news.Abstract = model.Abstract; news.Description = model.Description; //todo News.Photo = model.Photo; if (await db.SaveChangesAsync() == 1) { return(Json(new { status = 200, //you can see the datails of status code in Global/statusCode error = 0, message = "خبر با موفقیت ویرایش شد" })); } else { return(Json(new { status = 600, //you can see the datails of status code in ~/Global/statusCodes errors = ModelState.Values.Where(e => e.Errors.Count > 0).ToList(), message = "هنگام ویرایش خبر مشکلی رخ داد لطفا بعدا تلاش کنید" })); } } return(Json(new { status = 404, //you can see the datails of status code in ~/Global/statusCodes errors = 0, message = "خبر مورد نظر پیدا نشد" })); }
public async Task <IActionResult> Insert(CreateNewsViewModel model) { if (!ModelState.IsValid) { return(Json(new { status = 100, //you can see the datails of status code in ~/Global/statusCodes errors = ModelState.Values.Where(e => e.Errors.Count > 0).ToList(), message = "لطفا در وارد کردن اطلاعات دقت کنید" })); } var News = new tbl_News { Title = model.Title, Abstract = model.Abstract, Description = model.Description, Photo = model.Photo, IsDelete = false, CreationDate = DateTime.Now }; //todo sms verification try { await db.News.AddAsync(News); var result = await db.SaveChangesAsync(); return(new JsonResult(new { status = 200, //you can see the datails of status code in Global/statusCode error = 0, message = "خبر با موفقیت اضافه شد" })); } catch (Exception e) { ModelState.AddModelError("", e.Message); return(new JsonResult(new { status = 600, //you can see the datails of status code in ~/Global/statusCodes errors = ModelState.Values.Where(e => e.Errors.Count > 0).ToList(), message = "هنگام افزودن خبر مشکلی رخ داد لطفا بعدا تلاش کنید" })); } }
public ActionResult DangTin(tbl_News model) { if (ModelState.IsValid) { model.MetaTitle = ConvertToUnSign(model.Title); model.CreateBy = GetSessionID(); model.CreateDate = DateTime.Now; var result = new NewsDAO().AddNews(model); if (result) { SetAlert("Đăng tin tức thành công", "success"); return(RedirectToAction("Index")); } else { SetAlert("Lỗi! Đăng tin tức không thành công", "danger"); } } LoadCategory(model.CategoryNewID); return(View(model)); }
public ActionResult CapNhat(tbl_News model) { if (ModelState.IsValid) { model.MetaTitle = ConvertToUnSign(model.Title); model.ModifyBy = GetSessionID(); model.ModifyDate = DateTime.Now; var result = new NewsDAO().CapNhat(model); if (result) { //Cập nhật thành công, SetAlert("Cập nhật thành công", "success"); return(RedirectToAction("Index")); } else { SetAlert("Cập nhật không thành công, vui lòng kiểm tra lại!", "danger"); return(View(model)); } } LoadCategory(model.CategoryNewID); return(View(model)); }
public ActionResult EditNews(tbl_News md, string NgayDeliverConvert) { var model = NewsService.UpdateNews(md, NgayDeliverConvert); return(RedirectToAction("ManageNews", "News")); }