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); } } }