/// <summary> /// Saves a new Roster to the MySQL DB /// </summary> /// <param name="model"></param> /// <returns>The Roster information, including the unique identifier</returns> public List <RosterModel> CreateRoster(RosterModel model) { List <RosterModel> roster = new List <RosterModel>(); using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { foreach (PersonModel player in model.players) { var p = new DynamicParameters(); p.Add("@RosterID", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); p.Add("@InPersonID", player.PersonID); p.Add("@InDivisionTeamsID", model.DivisionTeamsID); connection.Execute("spRoster", p, commandType: CommandType.StoredProcedure); // grabs newly created ID from database and returns it as part of the current Person Model // https://stackoverflow.com/questions/13151861/fetch-last-inserted-id-form-stored-procedure-in-mysql var id = p.Get <int?>("RosterID"); model.RosterID = Convert.ToInt32(id); roster.Add(model); } return(roster); } }
public void SaveRosterDetails(RosterModel RosterModel) { if (RosterModel.Id == 0) { var roster = new tblRoaster() { ENDDATE = RosterModel.EndDate, COMPANYID = RosterModel.CompanyId, STARTTIME = RosterModel.StartTime, STARTDATE = RosterModel.StartDate, FINISHTIME = RosterModel.FinishTime, USERID = RosterModel.UserId }; entity.tblRoasters.Add(roster); } else { var y = entity.tblRoasters.FirstOrDefault(t => t.ID == RosterModel.Id); y.ENDDATE = RosterModel.EndDate; y.STARTTIME = RosterModel.StartTime; y.STARTDATE = RosterModel.StartDate; y.FINISHTIME = RosterModel.FinishTime; y.USERID = RosterModel.UserId; } entity.SaveChanges(); }
public RosterDisplayModel RosterToRosterDisplayModel(RosterModel roster) { // Copy roster data to new RosterDisplayModel RosterDisplayModel rdModel = new RosterDisplayModel(); rdModel.ID = roster.ID; rdModel.StartDate = roster.StartDate; rdModel.EndDate = roster.EndDate; rdModel.TotalHours = roster.TotalHours; rdModel.AllocatedCasualHours = roster.AllocatedCasualHours; rdModel.AllocatedHours = roster.AllocatedHours; rdModel.AllocatedPermanentHours = roster.AllocatedPermanentHours; // Create DataGridColumns for display on view rdModel.ColumnCollection = new ObservableCollection <DataGridColumn>(); // Add column for showing Person Data // ...... // Add Columns for displaying RosterDayEntries for (DateTime date = rdModel.StartDate; date <= rdModel.EndDate; date = date.AddDays(1.0)) { DataGridTextColumn dgtc = new DataGridTextColumn(); dgtc.Header = date; /// XXX: Binding goes here rdModel.ColumnCollection.Add(dgtc); } return(rdModel); }
public ActionResult Add(RosterModel roster) { if (ModelState.IsValid) { _dbContext.Roster.Add(roster); _dbContext.SaveChanges(); } return(RedirectToAction("Index")); }
public static void UpdateSelectedRoster(RosterModel selectedRoster) { GetSelectedRosterDisplayModel(selectedRoster); // Invoke Event so all views can be updated if (SelectedRosterChanged != null) { SelectedRosterChanged.Invoke(); } }
public void PersonComplete(PersonModel model) { DivisionTeamsModel dtm = (DivisionTeamsModel)playersTeamComboBox.SelectedItem; RosterModel rm = new RosterModel(); rm.DivisionTeamsID = dtm.DivisionTeamsID; sdtp.PersonID = model.PersonID; teamMembers.Add(model); rm.players = teamMembers; GlobalConfig.Connection.CreateRoster(rm); sdtp.RosterID = rm.RosterID; wireUpPlayersListBox(); }
public void SaveRosterDetails(RosterServiceModel RosterDetails) { var roster = new RosterModel() { Id = RosterDetails.Id, EndDate = RosterDetails.EndDate, CompanyId = RosterDetails.CompanyId, FinishTime = RosterDetails.FinishTime, StartDate = RosterDetails.StartDate, StartTime = RosterDetails.StartTime, UserId = RosterDetails.UserId }; _IRosterRepository.SaveRosterDetails(roster); }
public IActionResult Index() { //create object model RosterModel rosterModel = new RosterModel() { FirstName = "Tracy", LastName = "Feng", Age = 23, Id = 001 }; return(View(rosterModel)); //return Content("Hello World!"); //return View(); }
public ActionResult Update(RosterModel roster) { var rosterInDb = _dbContext.Roster.SingleOrDefault(v => v.ID == roster.ID); if (rosterInDb == null) { return(HttpNotFound()); } rosterInDb.Firstname = roster.Firstname; rosterInDb.Lastname = roster.Lastname; rosterInDb.description = roster.description; _dbContext.SaveChanges(); return(RedirectToAction("Index")); }
/// <summary> /// Performs Edits on DB depending on changes made to team in edit form /// DB tables altered at team, roster, and teamcaptains /// </summary> /// <param name="model">A TeamModel</param> private void EditTeam(TeamModel model) { RosterModel roster = new RosterModel(); roster.DivisionTeamsID = model.DivisionTeamsID; roster.players = selectedPlayers; GlobalConfig.Connection.EditTeam(model); GlobalConfig.Connection.EditRoster(roster, addedPeople, removedPeople); // If no team members remove team captain data from DB // count of 1 is "No Captain" string if (selectedPlayers.Count == 1) { GlobalConfig.Connection.EditCaptainRemove(model); } else { GlobalConfig.Connection.EditCaptain(model); } }
/// <summary> /// Modifies Roster data in MySQL DB /// </summary> /// <param name="model"></param> public void EditRoster(RosterModel model, List <PersonModel> adds, List <PersonModel> removes) { using (IDbConnection connection = new MySqlConnection(GlobalConfig.CnnString(db))) { foreach (PersonModel x in adds) { var p = new DynamicParameters(); p.Add("@InDivisionTeamsID", model.DivisionTeamsID); p.Add("@InPersonID", x.PersonID); connection.Execute("spEditRosterAdd", p, commandType: CommandType.StoredProcedure); } foreach (PersonModel y in removes) { var p = new DynamicParameters(); p.Add("@InDivisionTeamsID", model.DivisionTeamsID); p.Add("@InPersonID", y.PersonID); connection.Execute("spEditRosterRemove", p, commandType: CommandType.StoredProcedure); } } }
private void addPlayerButton_Click(object sender, EventArgs e) { dtm = (DivisionTeamsModel)(playersTeamComboBox.SelectedItem); if (dtm != null) { PersonModel pm = (PersonModel)playersComboBox.SelectedItem; if (pm != null) { teamMembers.Clear(); teamMembers.Add(pm); seasonPlayers.Add(pm); RosterModel rm = new RosterModel(); rm.DivisionTeamsID = dtm.DivisionTeamsID; rm.players = teamMembers; GlobalConfig.Connection.CreateRoster(rm); sdtp.SeasonID = season.SeasonID; sdtp.PersonID = pm.PersonID; sdtp.DivisionTeamsID = dtm.DivisionTeamsID; sdtp.RosterID = rm.RosterID; sdtp.SeasonDivisionsID = dtm.SeasonDivisionsID; sdtp.TeamID = dtm.TeamID; sdtp.DivisionID = dtm.DivisionID; //dtm = (DivisionTeamsModel)playersTeamComboBox.SelectedItem; teamMembers.Clear(); teamMembers = GlobalConfig.Connection.GetTeamMembers(dtm); // creat ean entry in DB with SeasonID, DivisionteamsID and PlayerID GlobalConfig.Connection.CreateSDTP(sdtp); wireUpPlayersListBox(); wireUpPlayersComboBox(); } } }
public ActionResult Index(int?id) { if (!id.HasValue) { return(RedirectToAction("Index", "roster", new { id = KSU.maxPlayerSeason })); } int gsID = id.Value; if (gsID >= 2007 && gsID <= KSU.maxPlayerSeason) { RosterModel rm = new RosterModel(); rm.SeasonID = gsID; return(View(rm)); } else { throw new Exception("KSULAX||we can't find the roster you requested"); } }
private static Guid?GetShiftRoster(DateTime DateCheck, RosterModel roster) { Guid?result = null; switch (DateCheck.DayOfWeek) { case DayOfWeek.Monday: result = roster.MonShiftID; break; case DayOfWeek.Tuesday: result = roster.TueShiftID; break; case DayOfWeek.Wednesday: result = roster.WedShiftID; break; case DayOfWeek.Thursday: result = roster.ThuShiftID; break; case DayOfWeek.Friday: result = roster.FriShiftID; break; case DayOfWeek.Saturday: result = roster.SatShiftID; break; case DayOfWeek.Sunday: result = roster.SunShiftID; break; } return(result); }
private static void GetSelectedRosterDisplayModel(RosterModel roster) { }
public void EditRoster(RosterModel model, List <PersonModel> adds, List <PersonModel> removes) { throw new NotImplementedException(); }
public List <RosterModel> CreateRoster(RosterModel model) { throw new NotImplementedException(); }
public TeamModel() { Rosters = new RosterModel[0]; TeamPermissions = new TeamPermissionModel[0]; }