public static void UpdateDanceGroup(DanceGroupModel model) { using (var ctx = new DFAppEntities()) { DBModel.DanceGroups t = ctx.DanceGroups.FirstOrDefault(x => x.DanceGroupID == model.DanceGroupID); if (t != null) { if (!string.IsNullOrEmpty(model.DanceGroupName)) { t.DanceGroupName = model.DanceGroupName; } if (!string.IsNullOrEmpty(model.DanceGroupDesc)) { t.DanceGroupDesc = model.DanceGroupDesc; } if (model.AgeCategoryID.HasValue) { t.AgeCategoryID = model.AgeCategoryID; } ctx.SaveChanges(); } } }
public static void DeleteDanceGroup(int id) { using (var ctx = new DFAppEntities()) { DBModel.DanceGroups t = ctx.DanceGroups.FirstOrDefault(x => x.DanceGroupID == id); if (t != null) { ctx.Entry(t).Collection(x => x.DanceGroupChoreographies).Load(); ctx.Entry(t).Collection(x => x.DanceGroupMembers).Load(); ctx.Entry(t).Collection(x => x.DanceGroupStaff).Load(); ctx.Entry(t).Collection(x => x.DanceSelectionDanceGroups).Load(); ctx.Entry(t).Collection(x => x.DanceGroupLocations).Load(); ctx.Entry(t).Collection(x => x.UserDanceGroups).Load(); for (int i = t.DanceGroupChoreographies.Count() - 1; i >= 0; i--) { ctx.DanceGroupChoreographies.Remove(t.DanceGroupChoreographies.ElementAt(i)); } for (int i = t.DanceGroupMembers.Count() - 1; i >= 0; i--) { ctx.DanceGroupMembers.Remove(t.DanceGroupMembers.ElementAt(i)); } for (int i = t.DanceGroupStaff.Count() - 1; i >= 0; i--) { ctx.DanceGroupStaff.Remove(t.DanceGroupStaff.ElementAt(i)); } for (int i = t.DanceSelectionDanceGroups.Count() - 1; i >= 0; i--) { ctx.DanceSelectionDanceGroups.Remove(t.DanceSelectionDanceGroups.ElementAt(i)); } for (int i = t.DanceGroupLocations.Count() - 1; i >= 0; i--) { ctx.DanceGroupLocations.Remove(t.DanceGroupLocations.ElementAt(i)); } for (int i = t.UserDanceGroups.Count() - 1; i >= 0; i--) { ctx.UserDanceGroups.Remove(t.UserDanceGroups.ElementAt(i)); } ctx.DanceGroups.Remove(t); ctx.SaveChanges(); } } }
public static DanceGroupModel CreateDanceGroup(DanceGroupModel model) { using (var ctx = new DFAppEntities()) { DBModel.DanceGroups existing = ctx.DanceGroups.FirstOrDefault(x => x.DanceGroupName.ToLower() == model.DanceGroupName.ToLower()); if (existing != null) { throw new Exception("Grupa sa datim imenom već postoji."); } DBModel.DanceGroups dg = new DBModel.DanceGroups(); dg.DanceGroupName = model.DanceGroupName; dg.DanceGroupDesc = model.DanceGroupDesc; dg.AgeCategoryID = model.AgeCategoryID; ctx.DanceGroups.Add(dg); ctx.SaveChanges(); model.DanceGroupID = dg.DanceGroupID; return(model); } }