public bool DisplayDraftPPRDetails() { try { PPRDataBL obj = new PPRDataBL(); DataTable dt = new DataTable(); dt = obj.GetDraftPPRDataBL(Session["UserId"].ToString()); if (dt.Rows.Count > 0) { DraftGridView.DataSource = dt; DraftGridView.DataBind(); } else { DraftGridView.DataSource = dt; DraftGridView.DataBind(); } // Panelmodule.Visible = true; } catch (Exception ex) { // LogError(ex); } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { var userIdtmp = Session["UserID"]; if (userIdtmp == null) { Response.Redirect("~/Default.aspx"); } int userId = (int)userIdtmp; CompetitionDataContext competitionDataBase = new CompetitionDataContext(); CompetitionCountDown competitionCountDown = new CompetitionCountDown(); Tab1.CssClass = "Clicked"; MainView.ActiveViewIndex = 0; #region competitions { DataTable dataTable = new DataTable(); dataTable.Columns.Add(new DataColumn("ID", typeof(string))); dataTable.Columns.Add(new DataColumn("Number", typeof(string))); dataTable.Columns.Add(new DataColumn("Name", typeof(string))); dataTable.Columns.Add(new DataColumn("Budjet", typeof(string))); dataTable.Columns.Add(new DataColumn("StartDate", typeof(string))); dataTable.Columns.Add(new DataColumn("EndDate", typeof(string))); List <zCompetitionsTable> competitionsList = (from a in competitionDataBase.zCompetitionsTable where a.Active == true && a.OpenForApplications == true select a).ToList(); foreach (zCompetitionsTable currentCompetition in competitionsList) { if (competitionCountDown.IsCompetitionEndDateExpired(currentCompetition.ID)) { continue; } DataRow dataRow = dataTable.NewRow(); dataRow["ID"] = currentCompetition.ID; dataRow["Name"] = currentCompetition.Name; dataRow["Number"] = currentCompetition.Number; dataRow["Budjet"] = Convert.ToInt32(currentCompetition.Budjet); dataRow["StartDate"] = currentCompetition.StartDate.ToString().Split(' ')[0]; dataRow["EndDate"] = currentCompetition.EndDate.ToString().Split(' ')[0]; dataTable.Rows.Add(dataRow); } MainGV.DataSource = dataTable; MainGV.DataBind(); } #endregion /// в первую таблицу все те у которых конкурс еще открыт а заявка не отправлена /// во вторую все те у которых заявка отправлена /// в третью все те у которых закрыта заявка #region currentApplications { 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("CompetitionName", typeof(string))); dataTable.Columns.Add(new DataColumn("StatusLabelEnabled", typeof(bool))); dataTable.Columns.Add(new DataColumn("SendButtonEnabled", typeof(bool))); List <zApplicationTable> applicationList = (from a in competitionDataBase.zApplicationTable where a.FK_UsersTable == userId && a.Sended == false && a.Active == true join b in competitionDataBase.zCompetitionsTable on a.FK_CompetitionTable equals b.ID where b.Active == true && b.OpenForApplications == true select a).Distinct().ToList(); Status status = new Status(); foreach (zApplicationTable currentApplication in applicationList) { if (competitionCountDown.IsCompetitionEndDateExpiredByApplication(currentApplication.ID)) { continue; } DataRow dataRow = dataTable.NewRow(); dataRow["ID"] = currentApplication.ID; dataRow["Name"] = currentApplication.Name; dataRow["CompetitionName"] = (from a in competitionDataBase.zCompetitionsTable where a.ID == (Convert.ToInt32(currentApplication.FK_CompetitionTable)) select a.Name).FirstOrDefault(); if (status.IsApplicationReadyToSend(currentApplication.ID)) { dataRow["StatusLabelEnabled"] = false; dataRow["SendButtonEnabled"] = true; } else { dataRow["StatusLabelEnabled"] = true; dataRow["SendButtonEnabled"] = false; } dataTable.Rows.Add(dataRow); } ApplicationGV.DataSource = dataTable; ApplicationGV.DataBind(); } #endregion #region applicationsArchive { 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("CompetitionName", typeof(string))); dataTable.Columns.Add(new DataColumn("SendedDate", typeof(string))); dataTable.Columns.Add(new DataColumn("Accept", typeof(string))); List <zApplicationTable> applicationList = (from a in competitionDataBase.zApplicationTable where a.FK_UsersTable == userId && a.Active == true && a.Sended == true join b in competitionDataBase.zCompetitionsTable on a.FK_CompetitionTable equals b.ID where b.Active == true select a).Distinct().ToList(); foreach (zApplicationTable currentApplication in applicationList) { DataRow dataRow = dataTable.NewRow(); dataRow["ID"] = currentApplication.ID; dataRow["Name"] = currentApplication.Name; dataRow["CompetitionName"] = (from a in competitionDataBase.zCompetitionsTable where a.ID == (Convert.ToInt32(currentApplication.FK_CompetitionTable)) select a.Name).FirstOrDefault(); if (currentApplication.SendedDataTime == null) { dataRow["SendedDate"] = "Не отправлялось на рассмотрение"; } else { dataRow["SendedDate"] = currentApplication.SendedDataTime.ToString().Split(' ')[0]; } zApplicationTable accept = (from a in competitionDataBase.zApplicationTable where a.ID == (Convert.ToInt32(currentApplication.ID)) select a).FirstOrDefault(); if (accept.Accept == true) { dataRow["Accept"] = "Принята"; } else { dataRow["Accept"] = "На рассмотрении"; } dataTable.Rows.Add(dataRow); } ArchiveApplicationGV.DataSource = dataTable; ArchiveApplicationGV.DataBind(); } #endregion #region draftApplications { 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("CompetitionName", typeof(string))); List <zApplicationTable> applicationList = (from a in competitionDataBase.zApplicationTable where a.FK_UsersTable == userId && a.Active == true join b in competitionDataBase.zCompetitionsTable on a.FK_CompetitionTable equals b.ID where b.Active == true select a).Distinct().ToList(); foreach (zApplicationTable currentApplication in applicationList) { if (competitionIsClosed(currentApplication) || competitionCountDown.IsCompetitionEndDateExpiredByApplication(currentApplication.ID)) { DataRow dataRow = dataTable.NewRow(); dataRow["ID"] = currentApplication.ID; dataRow["Name"] = currentApplication.Name; dataRow["CompetitionName"] = (from a in competitionDataBase.zCompetitionsTable where a.ID == (Convert.ToInt32(currentApplication.FK_CompetitionTable)) select a.Name).FirstOrDefault(); dataTable.Rows.Add(dataRow); } } DraftGridView.DataSource = dataTable; DraftGridView.DataBind(); } #endregion } }