private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
if (treeView1.SelectedNode == treeView1.Nodes[0])//增删查改用户
{
CapForm sub = new CapForm();
sub.TopLevel = false;
sub.Dock = DockStyle.Fill;//把子窗体设置为控件
PanelRightMain.Controls.Clear();
PanelRightMain.Controls.Add(sub);
sub.Show();
ToolStripButton tsb = new ToolStripButton("盒码采集");
toolStrip1.Items.Clear();
toolStrip1.Items.Add(tsb);
}
else if (treeView1.SelectedNode == treeView1.Nodes[1])//增删查改用户
{
Upload sub = new Upload();
sub.TopLevel = false;
sub.Dock = DockStyle.Fill;//把子窗体设置为控件
PanelRightMain.Controls.Clear();
PanelRightMain.Controls.Add(sub);
sub.Show();
ToolStripButton tsb = new ToolStripButton("上传箱号");
toolStrip1.Items.Clear();
toolStrip1.Items.Add(tsb);
}
else if (treeView1.SelectedNode == treeView1.Nodes[2])//增删查改用户
{
CapCaseAndBox sub = new CapCaseAndBox();
sub.TopLevel = false;
sub.Dock = DockStyle.Fill;//把子窗体设置为控件
PanelRightMain.Controls.Clear();
PanelRightMain.Controls.Add(sub);
sub.Show();
ToolStripButton tsb = new ToolStripButton("上传箱号");
toolStrip1.Items.Clear();
toolStrip1.Items.Add(tsb);
}
}
private void btnCommit_Click(object sender, EventArgs e)
{
using (var Content = new DataClassesDataContext())
{
if (dtpGameDate.Value == GetLastUploadGameDate())
{
MessageBox.Show("An upload for this game date has already occured", "Cannot Proceed",
MessageBoxButtons.OK);
return;
}
//create a new upload
var newUpload = new Upload();
newUpload.GameDate = dtpGameDate.Value;
newUpload.UploadDate = DateTime.Now.Date;
newUpload.SeasonID = _SeasonID;
Content.Uploads.InsertOnSubmit(newUpload);
Content.SubmitChanges();
foreach (var teamModel in Teams)
{
//Update or create record
var record =
Content.Records.FirstOrDefault(x => x.TeamID == teamModel.TeamID && x.SeasonID == _SeasonID);
if (record == null)
{
record = new Record();
record.TeamID = teamModel.TeamID;
record.SeasonID = _SeasonID;
record.Wins = teamModel.Wins;
record.Losses = teamModel.Losses;
record.PythWins = teamModel.PythWins;
record.PythLosses = teamModel.PythLosses;
record.DateModified = DateTime.Now.Date;
Content.Records.InsertOnSubmit(record);
Content.SubmitChanges();
}
else
{
record.Wins = teamModel.Wins;
record.Losses = teamModel.Losses;
record.PythWins = teamModel.PythWins;
record.PythLosses = teamModel.PythLosses;
record.DateModified = DateTime.Now.Date;
Content.SubmitChanges();
}
//Update or create opponentrecords
foreach (var opponentModel in teamModel.OpponentsList)
{
if (opponentModel.WinsVersus != 0 || opponentModel.LossesVersus != 0)
{
var opponentRecord = Content.OpponentsRecords.FirstOrDefault(
x => x.TeamID == teamModel.TeamID && x.OpponentTeamID == opponentModel.OpponentTeamID &&
x.SeasonID == _SeasonID);
if (opponentRecord == null)
{
opponentRecord = new OpponentsRecord();
opponentRecord.SeasonID = _SeasonID;
opponentRecord.TeamID = teamModel.TeamID;
opponentRecord.OpponentTeamID = opponentModel.OpponentTeamID;
opponentRecord.WinsAgainst = opponentModel.WinsVersus;
opponentRecord.LossesAgainst = opponentModel.LossesVersus;
opponentRecord.DateModified = DateTime.Now.Date;
Content.OpponentsRecords.InsertOnSubmit(opponentRecord);
Content.SubmitChanges();
}
else
{
opponentRecord.WinsAgainst = opponentModel.WinsVersus;
opponentRecord.LossesAgainst = opponentModel.LossesVersus;
opponentRecord.DateModified = DateTime.Now.Date;
Content.SubmitChanges();
}
}
}
//Insert team calculations - new for each upload
var calculations = new TeamCalculation();
calculations.UploadID = newUpload.UploadID;
calculations.SeasonID = _SeasonID;
calculations.TeamID = teamModel.TeamID;
calculations.WP = teamModel.WinningPercentage;
calculations.OWP = teamModel.OpponentsWinPercentage;
calculations.OOWP = teamModel.OpponentsOpponentWinPercentage;
calculations.SoS = teamModel.StrengthOfSchedule;
calculations.RPI = teamModel.RPI;
calculations.PythOOWP = teamModel.PythOpponentsOpponentWinPercentage;
calculations.PythOWP = teamModel.PythOpponentsWinPercentage;
calculations.PythRPI = teamModel.PythRPI;
calculations.PythWP = teamModel.PythWinPercentage;
calculations.DateCreated = DateTime.Now.Date;
Content.TeamCalculations.InsertOnSubmit(calculations);
Content.SubmitChanges();
}
}
this.Close();
}
