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