public IQueryable<PageRemarkViewModel> Read() { List<PageRemarkViewModel> ret = new List<PageRemarkViewModel>(); var qry = db.PageRemark.Where(x=>x.isOpen != "F"); foreach (PageRemark o in qry) { PageRemarkViewModel v = new PageRemarkViewModel(); v.ID = o.ID; //v.Content = o.Content; if (o.ModifyUserID != null) v.ModifyUserName = o.UserData.UserName; v.PageCName = o.PageCName; v.PageName = o.PageName; v.ModifyDT = o.ModifyDateTime; if(o.ModifyDateTime!=null) v.ModifyDTStr = o.ModifyDateTime.Value.ToString("yyyy/MM/dd"); v.isOpen = o.isOpen; v.ModifyUserID = o.ModifyUserID; v.OrderSeq = o.OrderSeq.Value; v.HasActtachment = ""; if (db.PageFiles.Where(x => x.PageID == o.ID).Count() > 0) v.HasActtachment = "@"; ret.Add(v); } return ret.AsQueryable(); }
public bool Update(PageRemarkViewModel pageRemarkViewModel) { bool ret = false; try { PageRemark pageRemark = db.PageRemark.Find(pageRemarkViewModel.ID); pageRemark.Content = pageRemarkViewModel.Content; pageRemark.ModifyUserID = pageRemarkViewModel.ModifyUserID; pageRemark.ModifyDateTime = DateTime.Now; db.SaveChanges(); ret = true; } catch (DbUpdateConcurrencyException ex) { // Update the values of the entity that failed to save from the store ex.Entries.Single().Reload(); } catch (DbEntityValidationException ex) { var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); } return ret; }
public PageRemarkViewModel Read(int ID) { PageRemarkViewModel v = new PageRemarkViewModel(); var qry = db.PageRemark.Where(x => x.ID == ID); foreach (PageRemark o in qry) { v.ID = o.ID; v.Content = o.Content; if (o.ModifyUserID != null) v.ModifyUserName = o.UserData.UserName; v.PageCName = o.PageCName; v.PageName = o.PageName; v.ModifyDT = o.ModifyDateTime; if (o.ModifyDateTime != null) v.ModifyDTStr = o.ModifyDateTime.Value.ToString("yyyy/MM/dd"); v.isOpen = o.isOpen; v.ModifyUserID = o.ModifyUserID; v.OrderSeq = o.OrderSeq.Value; } return v; }