protected void GvStaff_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
StaffAdapter.Delete(Convert.ToInt32(GvStaff.DataKeys[e.RowIndex].Value));
StaffDT = StaffAdapter.SelectStaff();
GvStaff.DataSource = StaffDT;
GvStaff.DataBind();
}
protected void btnadd_Click(object sender, EventArgs e)
{
StaffDT = StaffAdapter.Select_UNAME(txtuname.Text);
if (StaffDT.Rows.Count == 1)
{
lbl.Text = "UserName alredy exists !!";
}
else
{
FileUpload1.SaveAs(Server.MapPath("~/StaffImg/" + FileUpload1.FileName));
StaffAdapter.Insert(txtname.Text, drpstd.SelectedItem.Text, txtemail.Text, txtmobile.Text, "~/StaffImg/" + FileUpload1.FileName, txtqual.Text, txtadd.Text, txtcity.Text, txtpin.Text, txtuname.Text, txtpass.Text, DropDownList1.SelectedItem.Text);
lbl.Text = "Record Added Successfully";
txtadd.Text = "";
txtcity.Text = "";
txtemail.Text = "";
txtmobile.Text = "";
txtname.Text = "";
txtpin.Text = "";
txtqual.Text = "";
txtuname.Text = "";
drpstd.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.SelectStaff();
GvStaff.DataSource = StaffDT;
GvStaff.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.Select_UNAME(Session["uname"].ToString());
Image4.ImageUrl = StaffDT.Rows[0]["Image"].ToString();
Label1.Text = "Welcome " + StaffDT.Rows[0]["name"].ToString();
Session["std"] = StaffDT.Rows[0]["stdname"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.SelectStaff();
GvStaff.DataSource = StaffDT;
GvStaff.DataBind();
lblstaff.Text = GvStaff.Rows.Count.ToString();
}
}
protected void btnaddstd_Click(object sender, EventArgs e)
{
StaffDT = StaffAdapter.SELECT_BY_ID(Convert.ToInt32(drpstaff.SelectedValue));
txtname.Text = StaffDT.Rows[0]["Name"].ToString();
txtemail.Text = StaffDT.Rows[0]["Email"].ToString();
txtmobile.Text = StaffDT.Rows[0]["mobile"].ToString();
txtqual.Text = StaffDT.Rows[0]["qualification"].ToString();
txtadd.Text = StaffDT.Rows[0]["add"].ToString();
txtcity.Text = StaffDT.Rows[0]["city"].ToString();
txtpin.Text = StaffDT.Rows[0]["pincode"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.SelectStaff();
drpstaff.DataSource = StaffDT;
drpstaff.DataTextField = "Name";
drpstaff.DataValueField = "SID";
drpstaff.DataBind();
drpstaff.Items.Insert(0, "SELECT");
}
}
protected void btnstafflogin_Click(object sender, EventArgs e)
{
StaffDT = StaffAdapter.Select_LOGIN(txtstaffuname.Text, txtstaffpass.Text);
if (StaffDT.Rows.Count == 1)
{
Session["uname"] = txtstaffuname.Text;
Response.Redirect("Staff/Default.aspx");
}
else
{
lblstafferror.Text = "Login Error !!";
}
}
protected void btnchangepass_Click(object sender, EventArgs e)
{
StaffDT = StaffAdapter.Select_Current_Pass(txtcurrent.Text, Session["uname"].ToString());
if (StaffDT.Rows.Count == 1)
{
StaffAdapter.StaffMST_SELECT_ChangePass(txtnewpass.Text, Session["uname"].ToString());
lbl.Text = "Password Changed";
}
else
{
lbl.Text = "Invalid Current Pass";
}
}
protected void Page_Load(object sender, EventArgs e)
{
lbl.Text = "";
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.Select_UNAME(Session["uname"].ToString());
StdDT = StdAdapter.SelectStd();
drpstd.DataSource = StdDT;
drpstd.DataTextField = "STDName";
drpstd.DataValueField = "SID";
drpstd.DataBind();
drpstd.Items.Insert(0, "SELECT");
drpdiv.Items.Insert(0, "SELECT");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.Select_UNAME(Session["uname"].ToString());
lblstd.Text = StaffDT.Rows[0]["StdName"].ToString();
DivDT = DivAdapter.Select_By_STD(StaffDT.Rows[0]["StdName"].ToString());
drpdiv.DataSource = DivDT;
drpdiv.DataTextField = "DivName";
drpdiv.DataValueField = "DID";
drpdiv.DataBind();
drpdiv.Items.Insert(0, "SELECT");
drpstudent.Items.Insert(0, "SELECT");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
StaffDT = StaffAdapter.Select_UNAME(Session["uname"].ToString());
lblname.Text = StaffDT.Rows[0]["Name"].ToString();
//lblstd.Text = StaffDT.Rows[0]["stdname"].ToString();
txtemail.Text = StaffDT.Rows[0]["email"].ToString();
txtmobile.Text = StaffDT.Rows[0]["mobile"].ToString();
txtadd.Text = StaffDT.Rows[0]["add"].ToString();
txtcity.Text = StaffDT.Rows[0]["city"].ToString();
txtpin.Text = StaffDT.Rows[0]["pincode"].ToString();
Imgprofile.ImageUrl = StaffDT.Rows[0]["image"].ToString();
ViewState["sid"] = StaffDT.Rows[0]["SID"].ToString();
}
}
