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 StartStopButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable competitionToChangeStatus = (from a in competitionDataBase.zCompetitionsTable where a.ID == iD select a).FirstOrDefault(); if (competitionToChangeStatus != null) { if (competitionToChangeStatus.OpenForApplications == null) { competitionToChangeStatus.OpenForApplications = true; } else { competitionToChangeStatus.OpenForApplications = !competitionToChangeStatus.OpenForApplications; } competitionDataBase.SubmitChanges(); } else { //error } } Response.Redirect("ChooseCompetition.aspx"); }
private int GetDaysBeforeCompetitionEnd(int competitionId) { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); DateTime today = DateTime.Today; zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.ID == competitionId && a.Active == true select a).FirstOrDefault(); if (currentCompetition == null) { return(-1); } if (currentCompetition.EndDate == null) { return(-1); } DateTime competitionEndTime = Convert.ToDateTime(currentCompetition.EndDate); if (today > competitionEndTime) { return(-1); } double days = (competitionEndTime - today).TotalDays; if (days > 0) { return(Convert.ToInt32(days)); } return(-1); }
protected void GetTamplateWithNoMarkButton(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.ID == iD select a).FirstOrDefault(); if (currentCompetition != null) { if (currentCompetition.TemplateDocWithoutMarksName != null) { if (currentCompetition.TemplateDocWithoutMarksName.Any()) { string templatesWithNoMark = Server.MapPath("~/documents/templatesWithNoMark") + "\\" + currentCompetition.ID.ToString() + "\\" + currentCompetition.TemplateDocWithoutMarksName; HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + currentCompetition.TemplateDocWithoutMarksName); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(templatesWithNoMark)); HttpContext.Current.Response.End(); Response.End(); } } } } }
protected void LinkButton2_Click(object sender, EventArgs e) { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); var sessionParam = Session["CompetitionID"]; if (sessionParam == null) { //error Response.Redirect("ChooseCompetition.aspx"); } int iD = (int)sessionParam; if (iD > 0) { zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.Active == true && a.ID == iD select a).FirstOrDefault(); if (currentCompetition == null) { //error Response.Redirect("ChooseCompetition.aspx"); } String path = Server.MapPath("~/documents/templatesWithNoMark") + "\\\\" + currentCompetition.ID.ToString() + "\\\\" + currentCompetition.TemplateDocWithoutMarksName; HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + currentCompetition.TemplateDocWithoutMarksName); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(path)); HttpContext.Current.Response.End(); Response.End(); } }
protected bool competitionIsClosed(zApplicationTable currentApplication) { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.ID == currentApplication.FK_CompetitionTable select a).FirstOrDefault(); return(!currentCompetition.OpenForApplications); }
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 GetDocButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { var userIdtmp = Session["UserID"]; if (userIdtmp == null) { Response.Redirect("~/Default.aspx"); } int userId = (int)userIdtmp; var appid = button.CommandArgument; int idapp = Convert.ToInt32(appid); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable join b in competitionDataBase.zApplicationTable on a.ID equals b.FK_CompetitionTable where b.ID == idapp select a).FirstOrDefault(); string dirPath = Server.MapPath("~/documents/byApplication/" + idapp); string templateFilePath = Server.MapPath("~/documents/templates") + "\\" + currentCompetition.ID.ToString() + "\\" + currentCompetition.TemplateDocName; string newFileName = "Заявка " + currentCompetition.TemplateDocName + ".doc"; newFileName = newFileName.Replace(":", "_"); string newFilePath = dirPath + "\\" + newFileName; string zipFile = Server.MapPath("~/documents/generatedZipFiles/") + idapp + ".zip"; string extractPath = Server.MapPath("~/documents/extract/"); CreateXmlFile createXmlFile = new CreateXmlFile(); string asdadasdda = System.Web.HttpContext.Current.Server.MapPath("~/") + @"documents\generatedZipFiles\" + idapp + ".zip"; createXmlFile.CreateDocument(templateFilePath, newFilePath, idapp, 0); if (File.Exists(System.Web.HttpContext.Current.Server.MapPath("~/") + @"documents\generatedZipFiles\" + idapp + ".zip")) { File.Delete(System.Web.HttpContext.Current.Server.MapPath("~/") + @"documents\generatedZipFiles\" + idapp + ".zip"); ZipFile.CreateFromDirectory(dirPath, zipFile); HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=file.zip"); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(zipFile)); HttpContext.Current.Response.End(); } else { ZipFile.CreateFromDirectory(dirPath, zipFile); HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=file.zip"); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(zipFile)); HttpContext.Current.Response.End(); } Response.End(); } }
protected void GetDocButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTables join b in competitionDataBase.zApplicationTable on a.ID equals b.FK_CompetitionTable where b.ID == iD select a).FirstOrDefault(); if (currentCompetition != null) { var userIdtmp = Session["UserID"]; if (userIdtmp == null) { Response.Redirect("~/Default.aspx"); } int userId = (int)userIdtmp; if (currentCompetition.TemplateDocName != null) { if (currentCompetition.TemplateDocName.Any()) { string templateFilePath = Server.MapPath("~/documents/templates") + "\\" + currentCompetition.ID.ToString() + "\\" + currentCompetition.TemplateDocName; string newFileName = DateTime.Now.ToString() + " " + currentCompetition.TemplateDocName; newFileName = newFileName.Replace(":", "_"); string newFileDirectory = Server.MapPath("~/documents/generated") + "\\" + userId.ToString(); string newFilePath = newFileDirectory + "\\" + newFileName; Directory.CreateDirectory(newFileDirectory); CreateDocument(templateFilePath, newFilePath, iD); HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + currentCompetition.TemplateDocName); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(newFilePath)); HttpContext.Current.Response.End(); Response.End(); } } } } }
protected void DeleteButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable competitionToDelete = (from a in competitionDataBase.zCompetitionsTable where a.ID == iD select a).FirstOrDefault(); if (competitionToDelete != null) { competitionToDelete.Active = false; competitionDataBase.SubmitChanges(); } else { //error } } }
protected void OpenButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentApplication = (from a in competitionDataBase.zCompetitionsTable where a.Active == true && a.ID == iD select a).FirstOrDefault(); if (currentApplication != null) { currentApplication.Sended = true; //currentApplication.SendedDataTime = DateTime.Now; competitionDataBase.SubmitChanges(); } } Response.Redirect("CuratorCompetition.aspx"); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { Button send = (Button)e.Row.FindControl("OpenButton"); Button change = (Button)e.Row.FindControl("ChangeButton"); if (send != null && change != null) { CompetitionDataContext CompetitionsDataBase = new CompetitionDataContext(); zCompetitionsTable sended = (from a in CompetitionsDataBase.zCompetitionsTable where a.Active == true && a.ID == Convert.ToInt32(send.CommandArgument) select a).FirstOrDefault(); if (sended.Sended == true) { send.Enabled = false; change.Enabled = false; } else { send.Enabled = true; change.Enabled = true; } } }
protected void CreateSaveButtonClick(object sender, EventArgs e) { CompetitionDataContext competitionDataBase = new CompetitionDataContext(); var sessionParam = Session["CompetitionID"]; if (sessionParam == null) { //error Response.Redirect("ChooseCompetition.aspx"); } else { int iD = (int)sessionParam; if (iD > 0) { if ((NameTextBox.Text.Length > 0) && (DescriptionTextBox.Text.Length > 0)) { zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.Active == true && a.ID == iD select a).FirstOrDefault(); if (currentCompetition == null) { //error Response.Redirect("ChooseCompetition.aspx"); } else { currentCompetition.Name = NameTextBox.Text; currentCompetition.Number = DescriptionTextBox.Text; currentCompetition.Budjet = Convert.ToDouble(BudjetTextBox.Text); // currentCompetition.FK_Curator = Convert.ToInt32(DropDownList1.SelectedIndex); currentCompetition.StartDate = Calendar1.SelectedDate; currentCompetition.EndDate = Calendar2.SelectedDate; if (FileUpload1.HasFile) { try { String path = Server.MapPath("~/documents/templates"); Directory.CreateDirectory(path + "\\\\" + currentCompetition.ID.ToString()); FileUpload1.PostedFile.SaveAs(path + "\\\\" + currentCompetition.ID.ToString() + "\\\\" + FileUpload1.FileName); currentCompetition.TemplateDocName = FileUpload1.FileName; // FileStatusLabel.Text = "Файл загружен!"; } catch (Exception ex) { // FileStatusLabel.Text = "Не удалось загрузить файл."; } } if (FileUpload2.HasFile) { try { String path = Server.MapPath("~/documents/templatesWithNoMark"); Directory.CreateDirectory(path + "\\\\" + currentCompetition.ID.ToString()); FileUpload2.PostedFile.SaveAs(path + "\\\\" + currentCompetition.ID.ToString() + "\\\\" + FileUpload2.FileName); currentCompetition.TemplateDocWithoutMarksName = FileUpload2.FileName; // FileStatusLabel.Text = "Файл загружен!"; } catch (Exception ex) { // FileStatusLabel.Text = "Не удалось загрузить файл."; } } competitionDataBase.SubmitChanges(); } } } else { if ((NameTextBox.Text.Length > 0) && (DescriptionTextBox.Text.Length > 0)) { zCompetitionsTable newCompetition = new zCompetitionsTable(); newCompetition.Name = NameTextBox.Text; newCompetition.Number = DescriptionTextBox.Text; newCompetition.Budjet = Convert.ToDouble(BudjetTextBox.Text); // newCompetition.FK_Curator = Convert.ToInt32(DropDownList1.SelectedIndex); newCompetition.StartDate = Calendar1.SelectedDate; newCompetition.EndDate = Calendar2.SelectedDate; newCompetition.Active = true; newCompetition.OpenForApplications = false; competitionDataBase.zCompetitionsTable.InsertOnSubmit(newCompetition); competitionDataBase.SubmitChanges(); if (FileUpload1.HasFile) { try { String path = Server.MapPath("~/documents/templates"); Directory.CreateDirectory(path + "\\\\" + newCompetition.ID.ToString()); FileUpload1.PostedFile.SaveAs(path + "\\\\" + newCompetition.ID.ToString() + "\\\\" + FileUpload1.FileName); newCompetition.TemplateDocName = FileUpload1.FileName; // FileStatusLabel.Text = "Файл загружен!"; } catch (Exception ex) { // FileStatusLabel.Text = "Не удалось загрузить файл."; } } if (FileUpload2.HasFile) { try { String path = Server.MapPath("~/documents/templatesWithNoMark"); Directory.CreateDirectory(path + "\\\\" + newCompetition.ID.ToString()); FileUpload2.PostedFile.SaveAs(path + "\\\\" + newCompetition.ID.ToString() + "\\\\" + FileUpload2.FileName); newCompetition.TemplateDocWithoutMarksName = FileUpload2.FileName; // FileStatusLabel.Text = "Файл загружен!"; } catch (Exception ex) { // FileStatusLabel.Text = "Не удалось загрузить файл."; } } competitionDataBase.SubmitChanges(); } } } Response.Redirect("ChooseCompetition.aspx"); }
protected void GetDocButtonClick(object sender, EventArgs e) { Button button = (Button)sender; { int iD = Convert.ToInt32(button.CommandArgument); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable join b in competitionDataBase.zApplicationTable on a.ID equals b.FK_CompetitionTable where b.ID == iD select a).FirstOrDefault(); if (currentCompetition != null) { var userIdtmp = Session["UserID"]; if (userIdtmp == null) { Response.Redirect("~/Default.aspx"); } int userId = (int)userIdtmp; if (currentCompetition.TemplateDocName != null) { if (currentCompetition.TemplateDocName.Any()) { string templateFilePath = Server.MapPath("~/documents/templates") + "\\" + currentCompetition.ID.ToString() + "\\" + currentCompetition.TemplateDocName; string newFileName = "Заявка пользователя на конкурс " + currentCompetition.TemplateDocName; newFileName = newFileName.Replace(":", "_"); string newFileDirectory = Server.MapPath("~/documents/generated") + "\\" + iD.ToString(); string newFilePath = newFileDirectory + "\\" + newFileName; Directory.CreateDirectory(newFileDirectory); CreateXmlFile createXmlFile = new CreateXmlFile(); int docType = 0; try { RadioButtonList newRadioButtonList = button.Parent.FindControl("RadioButtonList1") as RadioButtonList; docType = Convert.ToInt32(newRadioButtonList.SelectedValue); } catch (Exception) { throw; } createXmlFile.CreateDocument(templateFilePath, newFilePath, iD, docType); string convertedFilePath = createXmlFile.ConvertedFilePath; HttpContext.Current.Response.ContentType = "application/x-zip-compressed"; HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=document." + createXmlFile.ConvertedFileExtension); HttpContext.Current.Response.BinaryWrite(ReadByteArryFromFile(convertedFilePath)); HttpContext.Current.Response.End(); Response.End(); /* System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; * response.ClearContent(); * response.Clear(); * response.ContentType = "text/plain"; * response.AddHeader("Content-Disposition", "attachment; filename=document." + createXmlFile.ConvertedFileExtension); * response.TransmitFile(convertedFilePath); * response.Flush(); * response.Clear(); * response.Redirect("~/User/UserMainPage.aspx"); * response.End(); * */ /* * Response.WriteFile(convertedFilePath); * Response.Redirect("~/User/UserMainPage.aspx");*/ } } } } //Response.Redirect("UserMainPage.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { CompetitionDataContext curator = new CompetitionDataContext(); /* List<UsersTable> curators = (from a in curator.UsersTable * where a.AccessLevel == 15 && a.Active == true * select a).ToList(); * * ListItem tmpItem2 = new ListItem(); * tmpItem2.Text = "Выберите куратора"; * tmpItem2.Value = "0"; * DropDownList1.Items.Add(tmpItem2); * * foreach (UsersTable current in curators) * { * ListItem tmpItem = new ListItem(); * tmpItem.Text = current.Email; * tmpItem.Value = current.ID.ToString(); * DropDownList1.Items.Add(tmpItem); * } */ var sessionParam = Session["CompetitionID"]; if (sessionParam == null) { //error Response.Redirect("ChooseCompetition.aspx"); } else { 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) { //error Response.Redirect("ChooseCompetition.aspx"); } else { NameTextBox.Text = currentCompetition.Name; DescriptionTextBox.Text = currentCompetition.Number; BudjetTextBox.Text = currentCompetition.Budjet.ToString(); //DropDownList1.SelectedIndex = Convert.ToInt32(currentCompetition.FK_Curator); Calendar1.SelectedDate = Convert.ToDateTime(currentCompetition.StartDate); Calendar2.SelectedDate = Convert.ToDateTime(currentCompetition.EndDate); if (currentCompetition.TemplateDocName != null) { if (currentCompetition.TemplateDocName.Any()) { LinkButton1.Text = currentCompetition.TemplateDocName; } else { LinkButton1.Visible = false; LinkButton1.Enabled = false; } } else { LinkButton1.Visible = false; LinkButton1.Enabled = false; } if (currentCompetition.TemplateDocWithoutMarksName != null) { if (currentCompetition.TemplateDocWithoutMarksName.Any()) { LinkButton2.Text = currentCompetition.TemplateDocWithoutMarksName; } else { LinkButton2.Visible = false; LinkButton2.Enabled = false; } } else { LinkButton2.Visible = false; LinkButton2.Enabled = false; } } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { var sessionParam1 = Session["ApplicationID"]; if ((sessionParam1 == null)) { Response.Redirect("ChooseApplication.aspx"); } int applicationId = Convert.ToInt32(sessionParam1); CompetitionDataContext competitionDataBase = new CompetitionDataContext(); zApplicationTable currentApplication = (from a in competitionDataBase.zApplicationTable where a.ID == applicationId select a).FirstOrDefault(); zCompetitionsTable currentCompetition = (from a in competitionDataBase.zCompetitionsTable where a.ID == currentApplication.FK_CompetitionTable select a).FirstOrDefault(); CompetitionCountDown competitionCountDown = new CompetitionCountDown(); CountDownLabel.Text = competitionCountDown.GetDaysBeforeCompetitionEndMessage(currentCompetition.ID); Label1.Text = currentApplication.Name; Label2.Text = currentCompetition.Name; if (currentApplication.StartProjectDate != null) { DateTime dateTime = (DateTime)currentApplication.StartProjectDate; string tmpStr = dateTime.ToString().Split(' ')[0]; string[] tmpArray = tmpStr.Split('.'); string tmp2 = tmpArray[2] + "-" + tmpArray[1] + "-" + tmpArray[0]; startdata.Value = tmp2; } if (currentApplication.EndProjectDate != null) { DateTime dateTime = (DateTime)currentApplication.EndProjectDate; string tmpStr = dateTime.ToString().Split(' ')[0]; string[] tmpArray = tmpStr.Split('.'); string tmp2 = tmpArray[2] + "-" + tmpArray[1] + "-" + tmpArray[0]; enddata.Value = tmp2; } DataTable dataTable = new DataTable(); dataTable.Columns.Add(new DataColumn("ID", typeof(string))); dataTable.Columns.Add(new DataColumn("Name", typeof(string))); dataTable.Columns.Add(new DataColumn("CreateDate", typeof(string))); List <zDocumentsTable> documentsList = (from a in competitionDataBase.zDocumentsTable where a.FK_ApplicationTable == applicationId && a.Active == true select a).ToList(); foreach (zDocumentsTable currentDocument in documentsList) { DataRow dataRow = dataTable.NewRow(); dataRow["ID"] = currentDocument.ID; dataRow["Name"] = currentDocument.Name; if (currentDocument.Name == null) { dataRow["Name"] = "ссылка"; if (currentDocument.LinkOut != null) { string linkOutString = currentDocument.LinkOut; if (linkOutString.Length > 100) { linkOutString = linkOutString.Remove(100) + "..."; dataRow["Name"] = linkOutString; } else { dataRow["Name"] = currentDocument.LinkOut; } } } dataRow["CreateDate"] = currentDocument.AddDateTime.ToString().Split(' ')[0]; dataTable.Rows.Add(dataRow); } DocumentsGV.DataSource = dataTable; DocumentsGV.DataBind(); List <zBlockTable> currentBlock = (from a in competitionDataBase.zBlockTable where a.Active == true select a).ToList(); DataTable dataTable2 = new DataTable(); dataTable2.Columns.Add(new DataColumn("ID", typeof(string))); dataTable2.Columns.Add(new DataColumn("BlockName", typeof(string))); dataTable2.Columns.Add(new DataColumn("Status", typeof(string))); dataTable2.Columns.Add(new DataColumn("EnableButton", typeof(bool))); Status status = new Status(); int statusHistory = 2; foreach (zBlockTable current in currentBlock) { DataRow dataRow2 = dataTable2.NewRow(); dataRow2["ID"] = current.ID; dataRow2["BlockName"] = current.BlockName; int blockStatus = status.GetStatusIdForBlockInApplication(current.ID, currentApplication.ID); dataRow2["Status"] = status.GetStatusNameByStatusId(blockStatus); dataRow2["EnableButton"] = false; if (status.IsDataReady(statusHistory)) { dataRow2["EnableButton"] = true; } statusHistory = blockStatus; dataTable2.Rows.Add(dataRow2); } BlockGV.DataSource = dataTable2; BlockGV.DataBind(); List <zPartnersTable> partners = (from a in competitionDataBase.zPartnersTable where a.Active == true join b in competitionDataBase.zApplicationAndPartnersMappingTable on a.ID equals b.FK_PartnersTable where b.Active == true && b.FK_Application == applicationId select a).ToList(); DataTable dataTable3 = new DataTable(); dataTable3.Columns.Add(new DataColumn("ID", typeof(string))); dataTable3.Columns.Add(new DataColumn("Surname", typeof(string))); dataTable3.Columns.Add(new DataColumn("Name", typeof(string))); dataTable3.Columns.Add(new DataColumn("Patronymic", typeof(string))); dataTable3.Columns.Add(new DataColumn("Role", typeof(bool))); foreach (zPartnersTable current in partners) { DataRow dataRow3 = dataTable3.NewRow(); dataRow3["ID"] = current.ID; dataRow3["Surname"] = current.Surname; dataRow3["Name"] = current.Name; dataRow3["Patronymic"] = current.Patronymic; dataRow3["Role"] = false; if (current.Role == null && current.Role == false) { dataRow3["Role"] = false; } if (current.Role == true) { dataRow3["Role"] = true; } dataTable3.Rows.Add(dataRow3); } PartnersGV.DataSource = dataTable3; PartnersGV.DataBind(); } }
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); } } }