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"));
}
