private void CheckInsertEventTeamScore()
{
using (PortalDataContext pdc = new PortalDataContext())
{
List <int> teamIDList = new List <int>();
teamIDList = (from t in pdc.Teams
where t.ActivityID == SynergyCurrentID &&
!(from ets in pdc.EventTeamScores
where ets.EventID == hdnEventID.Value.ToInt()
select ets.TeamID).Contains(t.TeamID)
select t.TeamID).ToList();
foreach (int teamID in teamIDList)
{
EventTeamScore ets = new EventTeamScore()
{
EventID = hdnEventID.Value.ToInt(),
TeamID = teamID,
Rank = 0,
Score = 0
};
pdc.EventTeamScores.InsertOnSubmit(ets);
}
pdc.SubmitChanges();
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
Event ev = new Event()
{
Name = txtEventName.Text,
ActivityID = SynergyCurrentID,
EventDivisionID = ddlDivision.SelectedValue.ToInt(),
EventCategoryID = ddlCategory.SelectedValue.ToInt(),
MaxPoint = txtMaxPoints.Text.ToInt(),
WinnerTeamID = ddlWinner.SelectedValue.ToInt(),
SortOrder = txtOrder.Text.ToInt(),
IsActive = true,
ScoringTypeID = 1,
CreatedBy = Request.Cookies["Speedo"]["UserName"].ToString(),
DateCreated = DateTime.Now
};
using (PortalDataContext pdc = new PortalDataContext())
{
pdc.Events.InsertOnSubmit(ev);
pdc.SubmitChanges();
List <int> teamIDList = new List <int>();
teamIDList = (from t in pdc.Teams
where t.ActivityID == SynergyCurrentID
select t.TeamID).ToList();
foreach (int teamID in teamIDList)
{
EventTeamScore ets = new EventTeamScore()
{
EventID = ev.EventID,
TeamID = teamID,
Rank = 0,
Score = 0
};
pdc.EventTeamScores.InsertOnSubmit(ets);
}
pdc.SubmitChanges();
}
Response.Redirect("EventMenu.aspx");
}
