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 GetShowsByInstrument(string strSearch)
{
ShowsByInstrumentVM model = new ShowsByInstrumentVM()
{
LstShowsByInstrument = AnalyticsDAL.GetShowsByInstrument(strSearch),
StrSearch = strSearch
};
foreach (var showsByInstrument in model.LstShowsByInstrument)
{
showsByInstrument.Show = ShowsDAL.GetShow(showsByInstrument.IntShowID);
}
return(PartialView("AnalyticsPartials/_ShowsByInstrument", 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));
}
public static ShowsByInstrumentVM Of(string strSearch, int intShowID)
{
Show show = ShowsDAL.GetShow(intShowID);
return(new ShowsByInstrumentVM(strSearch, show));
}