public ActionResult CheckUserIn(int intUserID)
{
GetDAL get = new GetDAL();
get.OpenConnection();
Users u = get.GetUserByID(intUserID);
get.CloseConnection();
get.OpenConnection();
List <AttendancePlanned> apList = get.GetAttendancePlannedByRehearsalPart(ChosenRehearsalPart); // join query here
get.CloseConnection();
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
foreach (AttendancePlanned ap in apList)
{
if (u.Equals(ap.User))
{
insert.InsertAttendanceActual(new AttendanceActual(DateTime.Now, true, ap));
UsersNotCurrentlyAtRehearsal.Remove(u);
}
}
get.CloseConnection();
insert.CloseConnection();
return(RedirectToAction("Index"));
}
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"));
}
public ActionResult MarkTaskFinished(int intTaskID)
{
InsertDAL insertDAL = new InsertDAL();
insertDAL.OpenConnection();
insertDAL.MarkTaskAsComplete(intTaskID);
insertDAL.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddConflict(ConflictsHomeVM vm)
{
vm.ConflictToAdd.User = Globals.LOGGED_IN_USER;
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertConflict(vm.ConflictToAdd);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult AddTask(TasksHomeVM vm)
{
InsertDAL insertDAL = new InsertDAL();
vm.NewTask.UserAssignedBy = Globals.LOGGED_IN_USER;
insertDAL.OpenConnection();
insertDAL.InsertTask(vm.NewTask);
insertDAL.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult EditUser(ProfileHomeVM vm)
{
Users currentUser = Globals.LOGGED_IN_USER;
currentUser.StrEmail = vm.EditedUserProfile.StrEmail;
currentUser.StrPhone = vm.EditedUserProfile.StrPhone;
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.ChangeEmailAndPhone(currentUser);
insert.CloseConnection();
return(RedirectToAction("Index"));
}
public ActionResult ConfirmSchedule()
{
// update rehearsal part times
//vm.LstConfirmScheduledRehearsalParts = tmpRehearsalPartsSchedule.LstScheduledRehearsalParts;
// insert start and end dates for each rehearsal part into db
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
foreach (var rp in tmpRehearsalPartsSchedule.LstScheduledRehearsalParts)
{
insert.UpdateRPTimes(rp.IntRehearsalPartID, rp.DtmStartDateTime.GetValueOrDefault(), rp.DtmEndDateTime.GetValueOrDefault());
}
insert.CloseConnection();
return(Json(new { success = true, response = "confirmed!" }, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index", "Schedule");
}
public ActionResult AddAnnouncement(CallboardHomeVM vm)
{
Callboard newCallboard = vm.NewAnnouncement;
newCallboard.PostedByUser = Globals.LOGGED_IN_USER;
// insert announcement into database
InsertDAL insert = new InsertDAL();
insert.OpenConnection();
insert.InsertCallboard(newCallboard);
insert.CloseConnection();
// also send email
return(SendEmail(newCallboard));
}
public ActionResult AddUserToEvent(ProfileHomeVM vm)
{
Users currentUser = Globals.LOGGED_IN_USER;
// add user to group
InsertDAL insertDAL = new InsertDAL();
insertDAL.OpenConnection();
insertDAL.InsertToUserEvents(vm.NewEvent, currentUser);
insertDAL.CloseConnection();
GetDAL get = new GetDAL();
get.OpenConnection();
Globals.LOGGED_IN_USER.LstEvents = get.GetEventsByUser(currentUser.IntUserID);
get.CloseConnection();
return(RedirectToAction("Index"));
}
