protected void CreateSaveButtonClick(object sender, EventArgs e)
{
var userIdtmp = Session["UserID"];
if (userIdtmp == null)
{
Response.Redirect("~/CuratorMainPage.aspx");
}
int userId = (int)userIdtmp;
CompetitionDataContext competitionDataBase = new CompetitionDataContext();
zCompetitionsTable newCompetition = new zCompetitionsTable();
newCompetition.Name = NameTextBox.Text;
newCompetition.Budjet = Convert.ToDouble(BudjetTextBox.Text);
newCompetition.FK_Curator = userId;
newCompetition.StartDate = Calendar1.SelectedDate;
newCompetition.EndDate = Calendar2.SelectedDate;
newCompetition.Active = true;
newCompetition.OpenForApplications = false;
competitionDataBase.zCompetitionsTable.InsertOnSubmit(newCompetition);
competitionDataBase.SubmitChanges();
foreach (ListItem current in CheckBoxList1.Items)
{
zActionsCompetitionsMappingTable actionlink = new zActionsCompetitionsMappingTable();
actionlink.FK_Competiton = newCompetition.ID;
actionlink.FK_ActionPR = Convert.ToInt32(current.Value);
actionlink.Active = current.Selected;
competitionDataBase.zActionsCompetitionsMappingTable.InsertOnSubmit(actionlink);
competitionDataBase.SubmitChanges();
}
Session["CompetitionID"] = newCompetition.ID;
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Готово!');", true);
}
protected void SaveButtonClick(object sender, EventArgs e)
{
CompetitionDataContext competitionDataBase = new CompetitionDataContext();
var sessionParam = Session["CompetitionID"];
var userId = Session["UserID"];
if (sessionParam != null && userId != null)
{
int iD = (int)sessionParam;
int user = (int)userId;
if (iD > 0)
{
zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable
where a.Active == true && a.ID == iD
select a).FirstOrDefault();
if (currentCompetition != null)
{
foreach (ListItem current in CheckBoxList1.Items)
{
zActionsCompetitionsMappingTable action = (from a in competitionDataBase.zActionsCompetitionsMappingTable
where a.FK_Competiton == iD &&
a.FK_ActionPR == Convert.ToInt32(current.Value)
select a).FirstOrDefault();
if (action != null)
{
if (current.Selected == true)
{
action.Active = true;
competitionDataBase.SubmitChanges();
}
}
else
{
action = new zActionsCompetitionsMappingTable();
action.Active = current.Selected;
action.FK_Competiton = iD;
action.FK_ActionPR = Convert.ToInt32(current.Value);
competitionDataBase.zActionsCompetitionsMappingTable.InsertOnSubmit(action);
competitionDataBase.SubmitChanges();
}
}
currentCompetition.Name = NameTextBox.Text;
currentCompetition.Budjet = Convert.ToDouble(BudjetTextBox.Text);
currentCompetition.FK_Curator = user;
currentCompetition.StartDate = Calendar1.SelectedDate;
currentCompetition.EndDate = Calendar2.SelectedDate;
competitionDataBase.SubmitChanges();
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Готово!');", true);
}
}
}
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Ошибка!');", true);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CompetitionDataContext curator = new CompetitionDataContext();
List <zTaskPRManualTable> comp = (from a in curator.zTaskPRManualTable where a.Active == true select a).ToList();
foreach (zTaskPRManualTable n in comp)
{
ListItem TmpItem = new ListItem();
TmpItem.Text = n.TaskPR;
TmpItem.Value = n.ID.ToString();
CheckBoxList1.Items.Add(TmpItem);
}
var sessionParam = Session["CompetitionID"];
if (sessionParam != null)
{
int iD = (int)sessionParam;
if (iD > 0)
{
CompetitionDataContext competitionDataBase = new CompetitionDataContext();
zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable
where a.Active == true && a.ID == iD
select a).FirstOrDefault();
if (currentCompetition == null)
{
Response.Redirect("CuratorCompetition.aspx");
}
else
{
NameTextBox.Text = currentCompetition.Name;
BudjetTextBox.Text = currentCompetition.Budjet.ToString();
foreach (ListItem current in CheckBoxList1.Items)
{
zActionsCompetitionsMappingTable action = (from a in competitionDataBase.zActionsCompetitionsMappingTable
where a.Active == true && a.FK_Competiton == iD &&
a.FK_ActionPR == Convert.ToInt32(current.Value)
select a).Distinct().FirstOrDefault();
if (action != null)
{
if (action.FK_ActionPR == Convert.ToInt32(current.Value))
{
current.Selected = true;
}
}
else
{
}
}
Calendar1.SelectedDate = Convert.ToDateTime(currentCompetition.StartDate);
Calendar2.SelectedDate = Convert.ToDateTime(currentCompetition.EndDate);
}
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "Script", "alert('Ошибка!');", true);
}
}
}
