/// <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];
}
