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 ConfirmSingleRehearsal(string strLocation, string strNotes, DateTime dtmStart, DateTime dtmEnd) { Rehearsal newRehearsal = new Rehearsal { DtmStartDateTime = dtmStart, DtmEndDateTime = dtmEnd, StrLocation = strLocation, StrNotes = strNotes }; newRehearsal.LstRehearsalParts = tmpRehearsalPartsSchedule.LstScheduledRehearsalParts.Where(x => x.DtmStartDateTime.GetValueOrDefault().Date.Equals(newRehearsal.DtmStartDateTime.Date)).ToList(); InsertDAL insert = new InsertDAL(); insert.OpenConnection(); if (insert.InsertRehearsal(newRehearsal)) { return(Json(new { success = true, responseTest = "confirmed!" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, responseTest = "error" }, JsonRequestBehavior.AllowGet)); } }
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")); }