public bool UpdateVaDuyet(CMS_News entity) { try { CMS_News obj = MyContext.CMS_News.Find(entity.ID); obj.TITLE = entity.TITLE; obj.CONTENTS = entity.CONTENTS; obj.EXCERPT = entity.EXCERPT; obj.ID_CATEGORIES = entity.ID_CATEGORIES; obj.PICTURE = entity.PICTURE; obj.EDITDATE = System.DateTime.Now; obj.ID_USERMODIFY = entity.ID_USERMODIFY; if (obj.ID_NEWS_STATUS == 1 || obj.ID_NEWS_STATUS == 3 || obj.ID_NEWS_STATUS == 6) { obj.ID_NEWS_STATUS = 2; } MyContext.Entry(obj).State = EntityState.Modified; MyContext.SaveChanges(); return(true); } catch (Exception ex) { Logs.WriteLog(ex); return(false); } }
public ActionResult Create(FormCollection fc, CMS_News obj) { try { TempData.Keep("categories"); if (ModelState.IsValid) { CMS_News_DAO objDAO = new CMS_News_DAO(); CSF_Users_DAO objUserDao = new CSF_Users_DAO(); int userID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name); obj.ID_USERCREATE = userID; int ReturnID = objDAO.Insert(obj); if (ReturnID > 0) { SetAlert("Thêm tin tức thành công", AlertType.Success); return(RedirectToAction("Index", "CMS_News")); } else { ModelState.AddModelError("", "Thêm tin tức không thành công"); } return(View("Index")); } return(View()); } catch (Exception ex) { SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error); Logs.WriteLog(ex); return(View()); } }
public ActionResult Edit(FormCollection fc, CMS_News obj) { try { if (ModelState.IsValid) { CMS_News_DAO objDAO = new CMS_News_DAO(); CSF_Users_DAO objUserDao = new CSF_Users_DAO(); int userID = objUserDao.GetUserIDByUserName(HttpContext.User.Identity.Name); obj.ID_USERMODIFY = userID; bool update = false; update = objDAO.Update(obj); if (update) { SetAlert("Cập nhật tin tức thành công", AlertType.Success); return(RedirectToAction("Index", "CMS_News")); } else { SetAlert("Cập nhật không thành công", AlertType.Error); } } return(View(obj)); } catch (Exception ex) { SetAlert("Lỗi" + ex.Message.ToString(), AlertType.Error); Logs.WriteLog(ex); return(View()); } }
public bool CreateOrUpdate(CMS_NewsModels model, ref string msg) { var Result = true; using (var cxt = new CMS_Context()) { using (var trans = cxt.Database.BeginTransaction()) { try { if (string.IsNullOrEmpty(model.Id)) { var _Id = Guid.NewGuid().ToString(); var e = new CMS_News { Id = _Id, Title = model.Title, Short_Description = model.Short_Description, ImageURL = model.ImageURL, CreatedBy = model.CreatedBy, CreatedDate = DateTime.Now, Description = model.Description, UpdatedBy = model.UpdatedBy, UpdatedDate = DateTime.Now, IsActive = model.IsActive }; cxt.CMS_News.Add(e); } else { var e = cxt.CMS_News.Find(model.Id); if (e != null) { e.Title = model.Title; e.Short_Description = model.Short_Description; e.ImageURL = model.ImageURL; e.Description = model.Description; e.UpdatedBy = model.UpdatedBy; e.UpdatedDate = DateTime.Now; e.IsActive = model.IsActive; } } cxt.SaveChanges(); trans.Commit(); } catch (Exception) { Result = false; msg = "Vui lòng kiểm tra đường truyền"; trans.Rollback(); } finally { cxt.Dispose(); } } } return(Result); }
public bool UpdateTrangThai(int iIDNews, Int16 iTrangThai, Int16 iTieuDiem) { try { CMS_News obj = MyContext.CMS_News.Find(iIDNews); obj.ID_NEWS_STATUS = iTrangThai; obj.ISFOCUS = iTieuDiem; MyContext.SaveChanges(); return(true); } catch (Exception ex) { Logs.WriteLog(ex); return(false); } }
public int Insert(CMS_News entity) { try { entity.CREATEDATE = System.DateTime.Now; entity.NUMBEROFVIEW = 0; entity.ISFOCUS = 0; MyContext.CMS_News.Add(entity); MyContext.SaveChanges(); return(entity.ID); } catch (Exception ex) { Logs.WriteLog(ex); throw; } }
public bool CreateOrUpdate(CMS_NewsModels model, ref string msg) { NSLog.Logger.Info("NewsCreateOrUpdate", model); var Result = true; using (var cxt = new CMS_Context()) { try { if (string.IsNullOrEmpty(model.Id)) /* insert */ { var _Id = Guid.NewGuid().ToString(); var e = new CMS_News { Id = _Id, Title = model.Title, Link = model.Link, Short_Description = model.Short_Description, Type = model.Type, ImageURL = model.ImageURL, Description = model.Description, IsActive = model.IsActive, Author = model.Author, Category = model.Category, Source = model.Source, CreatedUser = model.CreatedBy, CreatedDate = DateTime.Now, ModifiedUser = model.UpdatedBy, LastModified = DateTime.Now, Status = (byte)Commons.EStatus.Actived, }; cxt.CMS_News.Add(e); } else /* updated */ { var e = cxt.CMS_News.Find(model.Id); if (e != null) { e.Title = model.Title; e.Short_Description = model.Short_Description; e.Type = model.Type; e.Link = model.Link; e.ImageURL = model.ImageURL; e.Description = model.Description; e.Author = model.Author; e.Source = model.Source; e.Category = model.Category; e.ModifiedUser = model.UpdatedBy; e.LastModified = DateTime.Now; e.IsActive = model.IsActive; } } cxt.SaveChanges(); NSLog.Logger.Info("ResponseNewsCreateOrUpdate", new { Result, msg }); } catch (Exception ex) { Result = false; msg = "Vui lòng kiểm tra đường truyền"; NSLog.Logger.Error("ErrorNewsCreateOrUpdate", ex); } } return(Result); }