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