protected void ExpertAddButtonClick(object sender, EventArgs e)
{
Button button = (Button)sender;
if (button != null)
{
var appIdTmp = Session["ApplicationID"];
if (appIdTmp == null)
{
Response.Redirect("ApllicationExpertEdit.aspx");
}
int applicationId = Convert.ToInt32(appIdTmp);
CompetitionDataContext CompetitionsDataBase = new CompetitionDataContext();
zExpertsAndApplicationMappingTable expertAndApplicationConnection = (from a in CompetitionsDataBase.zExpertsAndApplicationMappingTable
where a.FK_UsersTable == Convert.ToInt32(button.CommandArgument)
&& a.FK_ApplicationsTable == applicationId
select a).FirstOrDefault();
if (expertAndApplicationConnection != null)
{
expertAndApplicationConnection.Active = true;
CompetitionsDataBase.SubmitChanges();
}
else
{
expertAndApplicationConnection = new zExpertsAndApplicationMappingTable();
expertAndApplicationConnection.Active = true;
expertAndApplicationConnection.FK_ApplicationsTable = applicationId;
expertAndApplicationConnection.FK_UsersTable = Convert.ToInt32(button.CommandArgument);
CompetitionsDataBase.zExpertsAndApplicationMappingTable.InsertOnSubmit(expertAndApplicationConnection);
CompetitionsDataBase.SubmitChanges();
}
}
Response.Redirect("ApllicationExpertEdit.aspx");
}
protected void DeleteExpertButtonClick(object sender, EventArgs e)
{
var sessionParam1 = Session["ApplicationID"];
ImageButton button = (ImageButton)sender;
if (sessionParam1 == null && button != null)
{
//error
Response.Redirect("~/Default.aspx");
}
int applicationId = Convert.ToInt32(sessionParam1);
int userId = Convert.ToInt32(button.CommandArgument);
CompetitionDataContext competitionDataBase = new CompetitionDataContext();
zApplicationTable currentApplication = (from a in competitionDataBase.zApplicationTable
where a.Active == true && a.Accept == false &&
a.ID == applicationId &&
a.Sended == true
select a).FirstOrDefault();
if (currentApplication != null)
{
zExpertsAndApplicationMappingTable expertlink =
(from a in competitionDataBase.zExpertsAndApplicationMappingTable
where a.Active == true && a.FK_ApplicationsTable == applicationId &&
a.FK_UsersTable == userId
select a).FirstOrDefault();
if (expertlink != null)
{
expertlink.Active = false;
competitionDataBase.SubmitChanges();
}
}
Response.Redirect("ApplicationExpertsAndExpertsGroupEdit.aspx");
}
protected void AddExpertGroupClick(object sender, EventArgs e)
{
var sessionParam1 = Session["ApplicationID"];
ImageButton button = (ImageButton)sender;
if (sessionParam1 == null && button != null)
{
//error
Response.Redirect("~/Default.aspx");
}
int applicationId = Convert.ToInt32(sessionParam1);
int groupId = Convert.ToInt32(button.CommandArgument);
CompetitionDataContext competitionDataBase = new CompetitionDataContext();
zApplicationTable currentApplication = (from a in competitionDataBase.zApplicationTable
where a.Active == true && a.Accept == false &&
a.ID == applicationId &&
a.Sended == true
select a).FirstOrDefault();
if (currentApplication != null)
{
List <zExpertAndExpertGroupMappingTable> currentgroup =
(from a in competitionDataBase.zExpertAndExpertGroupMappingTable
where a.Active == true && a.FK_ExpertGroupTable == groupId
select a).ToList();
if (currentgroup != null)
{
foreach (var n in currentgroup)
{
zExpertsAndApplicationMappingTable expertlink =
(from a in competitionDataBase.zExpertsAndApplicationMappingTable
where a.FK_ApplicationsTable == applicationId &&
a.FK_UsersTable == n.FK_UsersTable
select a).FirstOrDefault();
if (expertlink == null)
{
zExpertsAndApplicationMappingTable newexpertlink = new zExpertsAndApplicationMappingTable();
newexpertlink.Active = true;
newexpertlink.FK_ApplicationsTable = currentApplication.ID;
newexpertlink.FK_UsersTable = n.FK_UsersTable;
competitionDataBase.zExpertsAndApplicationMappingTable.InsertOnSubmit(newexpertlink);
competitionDataBase.SubmitChanges();
}
else
{
if (expertlink.Active == false)
{
expertlink.Active = true;
competitionDataBase.SubmitChanges();
}
}
}
}
}
Response.Redirect("ApplicationExpertsAndExpertsGroupEdit.aspx");
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
var sessionParam1 = Session["ApplicationID"];
if (sessionParam1 == null)
{
//error
Response.Redirect("~/Default.aspx");
}
int applicationId = Convert.ToInt32(sessionParam1);
ImageButton addexpert = (ImageButton)e.Row.FindControl("AddExpertButton");
ImageButton deletexpert = (ImageButton)e.Row.FindControl("DeleteExpertButton");
ImageButton addgroup = (ImageButton)e.Row.FindControl("AddExpertGroup");
ImageButton deletegroup = (ImageButton)e.Row.FindControl("DeleteGroupButton");
Label status = (Label)e.Row.FindControl("StatusLabel");
Label groupstatus = (Label)e.Row.FindControl("GroupStatusLabel");
if (addexpert != null && deletexpert != null && addgroup != null)
{
if (Convert.ToInt32(addgroup.CommandArgument) == 0 && Convert.ToInt32(deletegroup.CommandArgument) == 0)
{
addgroup.Visible = false;
deletegroup.Visible = false;
}
CompetitionDataContext CompetitionsDataBase = new CompetitionDataContext();
zExpertsAndApplicationMappingTable buttonstate =
(from a in CompetitionsDataBase.zExpertsAndApplicationMappingTable
where a.FK_UsersTable == Convert.ToInt32(addexpert.CommandArgument) &&
a.FK_ApplicationsTable == applicationId
select a).FirstOrDefault();
if (buttonstate == null)
{
deletexpert.Visible = false;
}
else
{
if (buttonstate.Active == true)
{
addexpert.Visible = false;
status.Visible = true;
}
else
{
deletexpert.Visible = false;
}
}
List <zExpertAndExpertGroupMappingTable> currentgroup =
(from a in CompetitionsDataBase.zExpertAndExpertGroupMappingTable
where a.Active == true && a.FK_ExpertGroupTable == Convert.ToInt32(addgroup.CommandArgument)
select a).ToList();
if (currentgroup != null)
{
foreach (var n in currentgroup)
{
zExpertsAndApplicationMappingTable expertlink =
(from a in CompetitionsDataBase.zExpertsAndApplicationMappingTable
where a.FK_ApplicationsTable == applicationId &&
a.FK_UsersTable == n.FK_UsersTable
select a).FirstOrDefault();
if (expertlink != null)
{
if (expertlink.Active == true)
{
addgroup.Visible = false;
}
else
{
deletegroup.Visible = false;
}
}
}
}
}
}
