public ActionResult AddEventSchedule(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
//vm.NewEventSchedule.PerWeekdayDuration = NodaTime.Period.FromMinutes(vm.NewEventSchedule.PerWeekdayDuration.Minutes);
//vm.NewEventSchedule.PerWeekendDuration = NodaTime.Period.FromMinutes(vm.NewEventSchedule.PerWeekendDuration.Minutes);
EventSchedule newEventSchedule = new EventSchedule(
vm.NewEventSchedule.Event,
(int)vm.NewEventSchedule.IntWeekdayDuration,
(int)vm.NewEventSchedule.IntWeekendDuration,
vm.NewEventSchedule.StrMondayStart,
vm.NewEventSchedule.StrTuesdayStart,
vm.NewEventSchedule.StrWednesdayStart,
vm.NewEventSchedule.StrThursdayStart,
vm.NewEventSchedule.StrFridayStart,
vm.NewEventSchedule.StrSaturdayStart,
vm.NewEventSchedule.StrSundayStart);
insert.OpenConnection();
insert.InsertEventSchedule(newEventSchedule);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddRehearsalPart(AdminHomeVM vm)
{
PeriodBuilder builder = new PeriodBuilder();
builder.Minutes = vm.NewRehearsalPart.IntLengthMinutes;
vm.NewRehearsalPart.DurLength = builder.Build();
GetDAL get = new GetDAL();
get.OpenConnection();
foreach (var id in vm.NewRehearsalPart.ArrMemberNeededIDs)
{
Users tmpUser = get.GetUserByID(id);
vm.NewRehearsalPart.LstMembers.Add(tmpUser);
}
get.CloseConnection();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
int newRehearsalPartID = insert.InsertRehearsalPart(vm.NewRehearsalPart);
vm.NewRehearsalPart.IntRehearsalPartID = newRehearsalPartID;
foreach (var m in vm.NewRehearsalPart.LstMembers)
{
AttendancePlanned ap = new AttendancePlanned(vm.NewRehearsalPart, m);
insert.InsertAttendancePlanned(ap);
}
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddEvent(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertEvent(vm.NewEvent);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddTypes(AdminHomeVM vm)
{
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertType(vm.NewType);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
// GET: Admin
public ActionResult Index()
{
if (Globals.IS_ADMIN)
{
AdminHomeVM model = new AdminHomeVM();
GetDAL get = new GetDAL();
get.OpenConnection();
model.LstAllGroups = get.GetAllGroups();
model.LstAllEvents = get.GetAllEvents();
model.LstAdminEvents = get.GetAdminEventsByUser(Globals.LOGGED_IN_USER.IntUserID);
foreach (Event e in model.LstAdminEvents)
{
e.LstRehearsalParts = get.GetRehearsalPartsByEvent(e);
foreach (RehearsalPart rp in e.LstRehearsalParts)
{
rp.LstMembers = get.GetUsersByRehearsalPart(rp);
if (rp.DtmStartDateTime.Equals(DateTime.MinValue))
{
rp.DtmStartDateTime = null;
}
if (rp.DtmEndDateTime.Equals(DateTime.MinValue))
{
rp.DtmEndDateTime = null;
}
}
}
model.LstAllTypes = get.GetAllTypes();
model.LstAllUsersForAdminEvents = get.GetAllUsersForAdminEvents(model.LstAdminEvents);
get.CloseConnection();
get.OpenConnection();
foreach (Users u in model.LstAllUsersForAdminEvents)
{
u.LstConflicts = get.GetConflictsByUser(u).OrderBy(x => x.DtmStartDateTime).ToList();
}
get.CloseConnection();
return(View("AdminHome", model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
//
// Navbar Index: 1
// GET: Admin
public ActionResult Index()
{
if (!CheckLogin())
{
return(RedirectToAction("Index", "Home"));
}
AdminHomeVM ahvm = new AdminHomeVM
{
adminName = db.AdminAccounts.FirstOrDefault().Account,
blogCount = db.BlogPages.Count(),
programCount = db.Programs.Count(),
editionCount = db.ProgramEditions.Count(),
programList = db.Programs.ToList()
};
return(View(ahvm));
}
