public void Dis_data()
{
userID = (int)Session["U_ID"];
Text = "select * from PROJECT2 where UserID = " + userID;
Dbm.ConnectDB();
Dbm.GetCommend(Text);
Dbm.ExeQuery();
EmpGridView.DataSource = Dbm.QueryEX();
EmpGridView.DataBind();
Dbm.CloseDB();
}
public void DataBlinding()
{
int u_id = (int)Session["U_ID"];
DBm.ConnectDB();
Text = "Select USERTABLE.Fname, USERTABLE.Lname, USERTABLE.School, FACULTY.Field_Exp "
+ "from USERTABLE "
+ "LEFT JOIN FACULTY ON FACULTY.U_ID = USERTABLE.U_ID"
+ " WHERE USERTABLE.U_ID =" + u_id;
DBm.GetCommend(Text);
DBm.ExeQuery();
EmpGridView.DataSource = DBm.QueryEX();
EmpGridView.DataBind();
DBm.ConnectDB();
}
protected void DataBlinding()
{
int u_id = (int)Session["U_ID"];
DBm.ConnectDB();
Text = "Select USERTABLE.Fname, USERTABLE.Lname, USERTABLE.School, STUDENT.Major, STUDENT.Grad_Date "
+ "from USERTABLE "
+ "LEFT JOIN STUDENT ON STUDENT.U_ID = USERTABLE.U_ID"
+ " WHERE USERTABLE.U_ID =" + u_id;
DBm.GetCommend(Text);
DBm.ExeQuery();
EmpGridView.DataSource = DBm.QueryEX();
EmpGridView.DataBind();
EmpGridView.RowStyle.VerticalAlign = VerticalAlign.Middle;
DBm.CloseDB();
}
protected void DataBlinding()
{
int u_id = (int)Session["U_ID"];
Text = "Select USERTABLE.Fname, USERTABLE.Lname, USERTABLE.School, USERTABLE.email, SUPERVISER.S_UID, PROJECT2.P_Name"
+ " from SUPERVISER "
+ " INNER JOIN FACULTY ON FACULTY.U_ID = SUPERVISER.Superviser_ID "
+ " INNER JOIN STUDENT ON STUDENT.U_ID = SUPERVISER.S_UID "
+ " INNER JOIN USERTABLE ON USERTABLE.U_ID = STUDENT.U_ID "
+ " INNER JOIN PROJECT2 ON PROJECT2.UserID = STUDENT.U_ID "
+ "WHERE Superviser_ID = " + u_id;
Dbm.ConnectDB();
Dbm.GetCommend(Text);
Dbm.ExeQuery();
EmpGridView.DataSource = Dbm.QueryEX();
EmpGridView.DataBind();
Dbm.CloseDB();
}
private void insertrowdata(String empId, string eName, string ePhone, string eEmail, string eAddress, string ePostal, string eLoginId, string ePass, string eRole)
{
int result1, result2;
string constr = ConfigurationManager.ConnectionStrings["ZenithCapstoneDBConnectionString"].ConnectionString;
using (SqlConnection sqlCon = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("INSERT INTO Employee (EmpId, EmpName, EmpPhone, EmpEmail, EmpAddress, EmpPostalCode) VALUES (@empId, @empName, @empPhone, @empEmail, @empAddress, @empPostalCode)");
cmd.Parameters.AddWithValue("@empId", Convert.ToInt32(empId));
cmd.Parameters.AddWithValue("@empName", eName);
cmd.Parameters.AddWithValue("@empPhone", ePhone);
cmd.Parameters.AddWithValue("@empEmail", eEmail);
cmd.Parameters.AddWithValue("@empAddress", eAddress);
cmd.Parameters.AddWithValue("@empPostalCode", ePostal);
cmd.Connection = sqlCon;
sqlCon.Open();
result1 = cmd.ExecuteNonQuery();
sqlCon.Close();
}
using (SqlConnection sqlCon2 = new SqlConnection(constr))
{
SqlCommand cmd = new SqlCommand("INSERT INTO EmployeeLogin (EmployeeLoginId, EmpId, Role, Pass) VALUES (@empLoginId, @empId, @empRole, @empPass)");
cmd.Parameters.AddWithValue("@empLoginId", eLoginId);
cmd.Parameters.AddWithValue("@empId", Convert.ToInt32(empId));
cmd.Parameters.AddWithValue("@empPass", ePass);
cmd.Parameters.AddWithValue("@empRole", eRole);
cmd.Connection = sqlCon2;
sqlCon2.Open();
result2 = cmd.ExecuteNonQuery();
sqlCon2.Close();
}
if (result1 == 1 && result2 == 1)
{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:alert('Record with employee id " + empId + " Updated Successfully');", true);
}
EmpGridView.DataBind();
}
