protected void getDetails()
{
try
{
string _ProcName = "getResultDetails";
SqlParameter[] _parameter =
{
new SqlParameter("@LoginID", Session["user"].ToString())
};
DataTable dbtable = new DataTable();
dbtable = db.GetDataTable(_ProcName, _parameter);
if (dbtable.Rows.Count > 0)
{
labelCourse.Text = dbtable.Rows[0]["CourseName"].ToString();
labelmarksObtain.Text = dbtable.Rows[0]["Marks"].ToString();
labelResult.Text = dbtable.Rows[0]["Status"].ToString();
labelStudentID.Text = dbtable.Rows[0]["UserName"].ToString();
labelName.Text = (dbtable.Rows[0]["FirstName"].ToString()) + " " + (dbtable.Rows[0]["LastName"].ToString());
labelDOB.Text = dbtable.Rows[0]["DOB"].ToString();
}
}
catch (Exception)
{
}
}
public void call()
{
try
{
string _ProcName = "getExamCourseDetails";
SqlParameter[] _parameter =
{
new SqlParameter("@LoginID", Session["user"].ToString())
};
DataTable dbtable = new DataTable();
dbtable = db.GetDataTable(_ProcName, _parameter);
if (dbtable.Rows.Count > 0)
{
Label1.Text = dbtable.Rows[0]["CourseName1"].ToString();
Label2.Text = dbtable.Rows[0]["CourseName2"].ToString();
Label3.Text = dbtable.Rows[0]["CourseName3"].ToString();
flag1 = Convert.ToInt16(dbtable.Rows[0]["flag1"]);
flag2 = Convert.ToInt16(dbtable.Rows[0]["flag2"]);
flag3 = Convert.ToInt16(dbtable.Rows[0]["flag3"]);
}
}
catch (Exception ex)
{
LabelErrorMessage.Text = ex.Message;
}
}
public void CustomerProfile()
{
try
{
string _ProcName = "getUserDeatils";
SqlParameter[] _parameter =
{
new SqlParameter("@LoginID", Session["user"].ToString())
};
DataTable dbtable = new DataTable();
dbtable = db.GetDataTable(_ProcName, _parameter);
if (dbtable.Rows.Count > 0)
{
FirstName.Text = dbtable.Rows[0]["FirstName"].ToString();
LastName.Text = dbtable.Rows[0]["LastName"].ToString();
LoginId.Text = dbtable.Rows[0]["LoginID"].ToString();
Email.Text = dbtable.Rows[0]["Email"].ToString();
phone.Text = dbtable.Rows[0]["phone"].ToString();
RadioButtonListGender.SelectedValue = dbtable.Rows[0]["Gender"].ToString();
dob.Text = dbtable.Rows[0]["DOB"].ToString();
address.Text = dbtable.Rows[0]["address"].ToString();
PinCode.Text = dbtable.Rows[0]["PinCoad"].ToString();
}
}
catch (Exception ex)
{
LabelErrorMessage.Text = ex.Message;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] parameter =
{
new SqlParameter("@UserName", txtUserName.Text),
new SqlParameter("@Password", txtPassword.Text),
};
DataTable ds = new DataTable();
ds = db.GetDataTable("ValidateLogin", parameter);
if (ds.Rows.Count > 0)
{
if (ds.Rows[0]["role"].ToString().Equals("2"))
{
Session["User"] = txtUserName.Text;
Response.Write("<script>alert('Login Successfully..!!')</script>");
Response.Redirect("Home.aspx");
}
else if (ds.Rows[0]["role"].ToString().Equals("1"))
{
Session["User1"] = txtUserName.Text;
Response.Redirect("Admin/AdminHomePage.aspx");
}
}
else
{
lblErrorMessage.Text = "Invalid User Name and Password..!!";
}
}
catch (SqlException ex)
{
lblErrorMessage.Text = ex.Message;
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
SqlParameter[] parameter =
{
new SqlParameter("@UserName", txtUserName.Text),
new SqlParameter("@Password", txtPassword.Text),
};
DataTable ds = new DataTable();
ds = db.GetDataTable("ValidateSellerLogin", parameter);
if (ds.Rows.Count > 0)
{
if (ds.Rows[0]["role"].ToString().Equals("3"))
{
Session["User2"] = txtUserName.Text;
Response.Redirect("~/Seller/SellerPage.aspx");
LinkButton4.Visible = true;
}
}
else
{
lblErrorMessage.Text = "You are not a Seller!!";
}
}
catch (SqlException ex)
{
lblErrorMessage.Text = ex.Message;
}
catch (Exception ex)
{
lblErrorMessage.Text = ex.Message;
}
}
