public IQueryable<ViewModels.AreaViewModel> AreaRead() { List<AreaViewModel> ret = new List<AreaViewModel>(); var qry = db.Area; foreach (Area o in qry) { AreaViewModel a = new AreaViewModel(); a.AreaID = o.AreaID; a.Name = o.Name; a.OldAreaID = o.AreaID; ret.Add(a); } return ret.AsQueryable(); }
public bool AreaCreate(AreaViewModel areaViewModel) { bool ret = false; try { Area area = new Area(); area.AreaID = areaViewModel.AreaID; area.Name = areaViewModel.Name; db.Area.Add(area); db.SaveChanges(); ret = true; } catch { } return ret; }
public bool AreaUpdate(AreaViewModel areaViewModel) { bool ret = false; try { if (areaViewModel.AreaID == areaViewModel.OldAreaID) { Area area = db.Area.Find(areaViewModel.AreaID); area.Name = areaViewModel.Name; db.SaveChanges(); ret = true; } else { if (AreaCreate(areaViewModel)) { var qry = db.SubArea.Where(q => q.AreaID == areaViewModel.OldAreaID); foreach (SubArea o in qry) { o.AreaID = areaViewModel.AreaID; } var qry2 = db.AreaReResponsibleClass.Where(q => q.AreaID == areaViewModel.OldAreaID); foreach (AreaReResponsibleClass o in qry2) { o.AreaID = areaViewModel.AreaID; } db.SaveChanges(); Area area = db.Area.Find(areaViewModel.OldAreaID); db.Area.Remove(area); 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 bool AreaDestroy(AreaViewModel areaViewModel) { bool ret = false; try { Area area = db.Area.Find(areaViewModel.AreaID); db.Area.Remove(area); db.SaveChanges(); ret = true; } catch (Exception ex) { ex.ToString(); } return ret; }