public ActionResult InsertShow(string StrName, string StrAuthor, int IntBudget, bool YsnIsMusical, int IntClubID, int IntDateID)
{
Show newShow = new Show
{
StrName = StrName,
StrAuthor = StrAuthor,
IntBudget = IntBudget,
YsnIsMusical = YsnIsMusical,
IntClubID = IntClubID,
Club = ClubsDAL.GetClub(IntClubID),
IntDateID = IntDateID,
Date = DatesDAL.GetDate(IntDateID)
};
bool success = ShowsDAL.InsertShow(newShow);
ShowsVM model = new ShowsVM()
{
LstAllClubs = ClubsDAL.GetAllClubs(),
LstShows = ShowsDAL.GetAllShows(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Shows", model));
}
public ActionResult GetAllActorsNotIn(int intShowID)
{
AllActorsNotInVM model = new AllActorsNotInVM()
{
LstAllShows = ShowsDAL.GetAllShows(),
LstAllActorsNotIn = AnalyticsDAL.GetAllActorsNotIn(intShowID),
Show = ShowsDAL.GetShow(intShowID)
};
return(PartialView("AnalyticsPartials/_AllActorsNotIn", model));
}
public ActionResult Analytics()
{
AnalyticsVM model = new AnalyticsVM();
model._budgetAverage_vm.LstBudgetAverages = AnalyticsDAL.GetBudgetAverages();
model._musicalsCount_vm.LstMusicalCounts = AnalyticsDAL.GetMusicalCounts();
model._repeatStaffPositions_vm.LstPossiblePositions = AnalyticsDAL.GetPossiblePositions();
model._membersByVoicePart_vm.LstAllVoiceParts = AnalyticsDAL.GetPossibleVoiceParts();
model._nonSinging_vm.LstNonSingingMembers = AnalyticsDAL.GetNonSingingMembers();
model._allActorsNotIn_vm.LstAllShows = ShowsDAL.GetAllShows();
return(View(model));
}
public ActionResult DeleteStaff(int IntStaffID)
{
Staff remStaff = new Staff
{
IntStaffID = IntStaffID
};
bool success = StaffDAL.DeleteStaff(remStaff);
StaffVM model = new StaffVM()
{
LstStaff = StaffDAL.GetAllStaff(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Staff", model));
}
public ActionResult DeleteShow(int IntShowID)
{
Show remShow = new Show
{
IntShowID = IntShowID
};
bool success = ShowsDAL.DeleteShow(remShow);
ShowsVM model = new ShowsVM()
{
LstAllClubs = ClubsDAL.GetAllClubs(),
LstShows = ShowsDAL.GetAllShows(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Shows", model));
}
public ActionResult DeletePit(int IntPitID)
{
Pit remPit = new Pit
{
IntPitID = IntPitID
};
bool success = PitsDAL.DeletePit(remPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult DeleteCast(int IntCastID)
{
Cast remCast = new Cast
{
IntCastID = IntCastID
};
bool success = CastsDAL.DeleteCast(remCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
public ActionResult UpdateShow(int IntShowID, int IntBudget)
{
Show updShow = new Show
{
IntShowID = IntShowID,
IntBudget = IntBudget
};
bool success = ShowsDAL.UpdateShow(updShow);
ShowsVM model = new ShowsVM()
{
LstAllClubs = ClubsDAL.GetAllClubs(),
LstShows = ShowsDAL.GetAllShows(),
LstAllDates = DatesDAL.GetAllDates()
};
return(PartialView("CRUDPartials/_Shows", model));
}
public ActionResult Crud()
{
ViewBag.Message = "Create, Read, Update, and Delete table info here";
CRUDVM model = new CRUDVM();
IEnumerable <Cast> allCasts = CastsDAL.GetAllCasts();
IEnumerable <Club> allClubs = ClubsDAL.GetAllClubs();
IEnumerable <Date> allDates = DatesDAL.GetAllDates();
IEnumerable <Exec> allExec = ExecDAL.GetAllExec();
IEnumerable <Member> allMembers = MembersDAL.GetAllMembers();
IEnumerable <Pit> allPits = PitsDAL.GetAllPits();
IEnumerable <Show> allShows = ShowsDAL.GetAllShows();
IEnumerable <Staff> allStaff = StaffDAL.GetAllStaff();
model._shows_vm.LstShows = allShows;
model._shows_vm.LstAllClubs = allClubs;
model._shows_vm.LstAllDates = allDates;
model._casts_vm.LstCasts = allCasts;
model._casts_vm.LstAllMembers = allMembers;
model._casts_vm.LstAllShows = allShows;
model._exec_vm.LstExec = allExec;
model._exec_vm.LstAllMembers = allMembers;
model._exec_vm.LstAllClubs = allClubs;
model._exec_vm.LstAllDates = allDates;
model._members_vm.LstMembers = allMembers;
model._pits_vm.LstPits = allPits;
model._pits_vm.LstAllMembers = allMembers;
model._pits_vm.LstAllShows = allShows;
model._staff_vm.LstStaff = allStaff;
model._staff_vm.LstAllMembers = allMembers;
model._staff_vm.LstAllShows = allShows;
return(View(model));
}
public ActionResult UpdateCast(int IntCastID, int IntMemberID)
{
Cast updCast = new Cast
{
IntCastID = IntCastID,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID)
};
bool success = CastsDAL.UpdateCast(updCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
public ActionResult UpdatePit(int IntPitID, int IntSeat, int IntMemberID)
{
Pit upPit = new Pit
{
IntPitID = IntPitID,
IntSeat = IntSeat,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID)
};
bool success = PitsDAL.UpdatePit(upPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult InsertStaff(string StrPosition, int IntMemberID, int IntShowID)
{
Staff newStaff = new Staff
{
StrPosition = StrPosition,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = StaffDAL.InsertStaff(newStaff);
StaffVM model = new StaffVM()
{
LstStaff = StaffDAL.GetAllStaff(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Staff", model));
}
public ActionResult InsertPit(string StrInstrument, int IntSeat, int IntMemberID, int IntShowID)
{
Pit newPit = new Pit
{
StrInstrument = StrInstrument,
IntSeat = IntSeat,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = PitsDAL.InsertPit(newPit);
PitsVM model = new PitsVM()
{
LstPits = PitsDAL.GetAllPits(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Pits", model));
}
public ActionResult InsertCast(string StrVoicePart, string StrRole, int IntMemberID, int IntShowID)
{
Cast newCast = new Cast
{
StrVoicePart = StrVoicePart,
StrRole = StrRole,
IntMemberID = IntMemberID,
Member = MembersDAL.GetMember(IntMemberID),
IntShowID = IntShowID,
Show = ShowsDAL.GetShow(IntShowID)
};
bool success = CastsDAL.InsertCast(newCast);
CastsVM model = new CastsVM()
{
LstCasts = CastsDAL.GetAllCasts(),
LstAllMembers = MembersDAL.GetAllMembers(),
LstAllShows = ShowsDAL.GetAllShows()
};
return(PartialView("CRUDPartials/_Casts", model));
}
