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(); } }