protected void Page_Load(object sender, EventArgs e)
{
if (Session["student"] != null)
{
btn_login.Visible = false;
btn_signUp.Visible = false;
}
else
{
btn_login.Visible = true;
btn_logout.Visible = false;
btn_signUp.Visible = true;
}
int projectid = Convert.ToInt32(Session["projectid"]);
pid.Text = " " + projectid;
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.ProjectsTableTableAdapter taProjects =
new DataSet1TableAdapters.ProjectsTableTableAdapter();
taProjects.Fill(ds.ProjectsTable);
DataTable table = ds.Tables["ProjectsTable"];
string expression = "projectid = " + projectid;
DataRow[] foundRows;
foundRows = table.Select(expression);
for (int i = 0; i < foundRows.Length; i++)
{
pid.Text = "" + foundRows[i][0];
ptitle.Text = "" + foundRows[i][1];
pmn.Text = "" + foundRows[i][2];
pdesc.Text = "" + foundRows[i][5];
ploc.Text = "" + foundRows[i][6];
pskills.Text = "" + foundRows[i][9];
papps.Text = "" + foundRows[i][7];
pdur.Text = "" + foundRows[i][10];
passets.Text = "" + foundRows[i][12];
pdate.Text = "" + foundRows[i][4];
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
DataSet1 ds1 = new DataSet1();
DataSet1TableAdapters.ProjectsTableTableAdapter taProjects = new DataSet1TableAdapters.ProjectsTableTableAdapter();
taProjects.Fill(ds1.ProjectsTable);
int selected = Convert.ToInt32(Session["projectid"]);
DataRow[] dr = ds1.ProjectsTable.Select("projectid=" + selected);
dr[0].Delete();
taProjects.Update(ds1.ProjectsTable);
taProjects.Fill(ds1.ProjectsTable);
Label1.Text = "Deleted This Project Successfully";
Server.Transfer("OrgShowAllProj.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["user"] == null)
{
Server.Transfer("~/LoginPage.aspx");
}
else
{
Users user = (Users)Session["user"];
int projectid = Convert.ToInt32(Session["projectid"]);
pid.Text = " " + projectid;
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.ProjectsTableTableAdapter taProjects =
new DataSet1TableAdapters.ProjectsTableTableAdapter();
taProjects.Fill(ds.ProjectsTable);
DataTable table = ds.Tables["ProjectsTable"];
string expression = "projectid = " + projectid;
DataRow[] foundRows;
foundRows = table.Select(expression);
for (int i = 0; i < foundRows.Length; i++)
{
pid.Text = "" + foundRows[i][0];
ptitle.Text = "" + foundRows[i][1];
pmn.Text = "" + foundRows[i][2];
porg.Text = "" + foundRows[i][3];
pDate.Text = "" + foundRows[i][4];
pdesc.Text = "" + foundRows[i][5];
ploc.Text = "" + foundRows[i][6];
papps.Text = "" + foundRows[i][7];
pweb.Text = "" + foundRows[i][8];
pskills.Text = "" + foundRows[i][9];
pdur.Text = "" + foundRows[i][10];
pAssets.Text = "" + foundRows[i][12];
}
}
}
protected void btnUpdateProject_Click(object sender, EventArgs e)
{
//string projName = tbPName.Text;
//string projMngr = tbPMngr.Text;
//string orgName = tbOrgName.Text;
//string desc = tbDesc.Text;
//string loc = tbLoc.Text;
//string web = tbWeb.Text;
//string dur = tbDuration.Text;
//string skills = "";
//for (int i = 0; i < CheckBoxList1.Items.Count; i++)
//{
// if (CheckBoxList1.Items[i].Selected)
// {
// skills += CheckBoxList1.Items[i].Text + " ";
// }
//}
//skills += tbSkills.Text;
string compensateAssets = "";
if (cbAssets.Checked)
{
compensateAssets += tbAsset.Text + " ";
}
if (cbBudget.Checked)
{
compensateAssets += tbBudget.Text;
}
//DataSet1TableAdapters.ProjectsTableTableAdapter taProjects = new DataSet1TableAdapters.ProjectsTableTableAdapter();
//taProjects.Fill(ds1.ProjectsTable);
//int selected = project.projectid;
//DataRow[] dr = ds1.ProjectsTable.Select("projectid=" + selected);
//////dr[0]["ProjectName"] = projName;
//dr[0]["ProjectManager"] = projMngr;
//dr[0]["OrgName"] = orgName;
//dr[0]["Description"] = desc;
//dr[0]["Location"] = loc;
//dr[0]["Website"] = web;
//dr[0]["Skills"] = skills;
//dr[0]["Duration"] = dur;
//taProjects.Update(ds1.ProjectsTable);
string skills = "";
for (int i = 0; i < CheckBoxListSkills.Items.Count; i++)
{
if (CheckBoxListSkills.Items[i].Selected)
{
skills += CheckBoxListSkills.Items[i].Text + " ";
}
}
skills += tbOtherSkills.Text;
DataSet1 ds1 = new DataSet1();
DataSet1TableAdapters.ProjectsTableTableAdapter taProjects =
new DataSet1TableAdapters.ProjectsTableTableAdapter();
taProjects.Fill(ds1.ProjectsTable);
Project project = (Project)Session["project"];
int selected = project.projectid;
//int selected = Convert.ToInt32(session["project"]);
DataRow[] dr = ds1.ProjectsTable.Select("projectid=" + selected);
dr[0]["ProjectName"] = tbPName.Text;
dr[0]["ProjectManager"] = tbPMngr.Text;
dr[0]["OrgName"] = tbOrgName.Text;
dr[0]["Description"] = tbDesc.Text;
dr[0]["Location"] = tbLoc.Text;
dr[0]["Website"] = tbWeb.Text;
dr[0]["Skills"] = skills;
dr[0]["Duration"] = tbDuration.Text;
dr[0]["CompensateAssets"] = compensateAssets;
taProjects.Update(ds1.ProjectsTable);
Label3.Text = "Successfully Updated";
}
