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 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 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 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));
}
