protected void btnsarch_Click(object sender, EventArgs e) { try { DataTable StuDT = StudentMst.GetAllActiveData(); if (StuDT != null) { DataTable Student_dt = StuDT.Select("DivId= " + drpdiv.SelectedValue).CopyToDataTable(); if (Student_dt != null && Student_dt.Rows.Count > 0) { GvStudent.DataSource = Student_dt; GvStudent.DataBind(); } } } catch { } //else //{ // //MultiView1.ActiveViewIndex = -1; //} }
private void loaddata(int id) { try { DataRow dr = StudentResult.GetDataByKey(id); if (dr != null) { txttotalMarks.Text = dr["TotalMarks"].ToString(); txtObtainMarks.Text = dr["ObtainMarks"].ToString(); if (!string.IsNullOrEmpty(dr["ExamId"].ToString())) { drpExam.SelectedValue = dr["ExamId"].ToString(); // drpstd.SelectedValue = dr["StdId"].ToString(); } if (!string.IsNullOrEmpty(dr["StudentId"].ToString())) { DataRow drStd = StudentMst.GetDataByKey(int.Parse(dr["StudentId"].ToString())); if (drStd != null) { drpdiv.SelectedValue = drStd["DivId"].ToString(); bindStudent(); drpstudent.SelectedValue = drStd["SID"].ToString(); } ResultID = id; // drpstd.SelectedValue = dr["StdId"].ToString(); } btnadd.Text = "Update"; } } catch { } }
protected void GvStudent_RowDeleting(object sender, GridViewDeleteEventArgs e) { StudentMst.Delete(Convert.ToInt32(GvStudent.DataKeys[e.RowIndex].Value)); DataTable StudentDT = StudentMst.GetAllActiveData(); GvStudent.DataSource = StudentDT; GvStudent.DataBind(); }
public ActionResult Create(StudentMst student) { if (!ModelState.IsValid) { return(View()); } return(View()); }
protected void Button8_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 1; DataRow Studr = StudentMst.GetDataByKey(int.Parse(Session["SID"].ToString())); //StuAdapter.Select_UNAME(Session["sname"].ToString()); DataTable LeaveDT = LeaveMst.GetAllActiveData().Select("studentId = '" + Studr["SID"].ToString() + "'").CopyToDataTable(); GridView1.DataSource = LeaveDT; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { int studentId = int.Parse(Session["SID"].ToString()); DataRow studentdr = StudentMst.GetDataByKey(studentId); if (studentdr != null) { Image4.ImageUrl = studentdr["image"].ToString(); Label1.Text = studentdr["name"].ToString(); } } }
protected void bindStudent() { DataTable dt = StudentMst.GetAllActiveData(); if (dt != null && dt.Rows.Count > 0) { drpstudent.DataSource = dt; drpstudent.DataTextField = "rollno"; drpstudent.DataValueField = "sid"; drpstudent.DataBind(); drpstudent.Items.Insert(0, "SELECT"); } }
protected void drpdiv_SelectedIndexChanged(object sender, EventArgs e) { if (drpdiv.SelectedIndex > 0) { DataTable dt = StudentMst.GetAllResultDataByDivID(int.Parse(drpdiv.SelectedValue)); if (dt != null && dt.Rows.Count > 0) { drpstudent.DataSource = dt; drpstudent.DataTextField = "rollno"; drpstudent.DataValueField = "sid"; drpstudent.DataBind(); drpstudent.Items.Insert(0, "SELECT"); } } }
protected void btnstudenlogin_Click(object sender, EventArgs e) { DataRow StuDr = StudentMst.StdLogin(txtstuuname.Text, txtstupass.Text); if (StuDr != null) { Session["sname"] = txtstuuname.Text; Session["SID"] = StuDr["SID"].ToString(); Response.Redirect("Student/Main.aspx"); } else { lblstuerror.Text = "Login Error !!"; } }
private void loaddata(int id) { try { DataRow dr = StudentMst.GetDataByKey(id); if (dr != null) { txtadd.Text = dr["Add"].ToString(); txtcity.Text = dr["Name"].ToString(); txtemail.Text = dr["Email"].ToString(); txtmobi.Text = dr["Mobile"].ToString(); txtroll.Text = dr["RollNo"].ToString(); // txtmobile.Text = dr["Mobile"].ToString(); txtname.Text = dr["Name"].ToString(); txtpin.Text = dr["Pincode"].ToString(); // txtqual.Text = dr["Qualification"].ToString(); txtuname.Text = dr["Uname"].ToString(); txt_MachineId.Text = dr["MachineCode"].ToString(); if (!string.IsNullOrEmpty(dr["DOB"].ToString())) { DateTime date = Convert.ToDateTime(dr["DOB"].ToString()); drpdd.SelectedItem.Text = date.ToString("dd"); drpmm.SelectedItem.Text = date.ToString("MM"); drpyyyy.SelectedItem.Text = date.ToString("yyyy"); } if (!string.IsNullOrEmpty(dr["StdId"].ToString())) { drpstd.SelectedValue = dr["StdId"].ToString(); } if (!string.IsNullOrEmpty(dr["DivId"].ToString())) { binddiv(int.Parse(dr["StdId"].ToString())); drpdiv.SelectedValue = dr["DivId"].ToString(); } // DropDownList1.SelectedItem.Text = dr["Gender"].ToString(); StudentId = id; btnstuadd.Text = "Update"; } } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { DataTable StdDT = StdMst.GetAllActiveData(); drpstd.DataSource = StdDT; drpstd.DataTextField = "StdName"; drpstd.DataValueField = "Sid"; drpstd.DataBind(); drpstd.Items.Insert(0, "SELECT"); drpstudent.Items.Insert(0, "SELECT"); DataTable Student_dt = StudentMst.GetAllActiveData(); GvStudent.DataSource = Student_dt; GvStudent.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { int id = 1; DataRow Studr = StudentMst.GetDataByKey(id); if (Studr != null) { lblname.Text = Studr["Name"].ToString(); lblroll.Text = Studr["rollno"].ToString(); txtemail.Text = Studr["email"].ToString(); txtmobile.Text = Studr["mobile"].ToString(); txtadd.Text = Studr["add"].ToString(); txtcity.Text = Studr["city"].ToString(); txtpin.Text = Studr["pincode"].ToString(); Imgprofile.ImageUrl = Studr["image"].ToString(); ViewState["sid"] = Studr["SID"].ToString(); } } }
protected void btnappluleave_Click(object sender, EventArgs e) { try { DataRow StuDT = StudentMst.GetDataByKey(int.Parse(Session["SID"].ToString())); //St StuAdapter.Select_UNAME(Session["sname"].ToString()); LeaveMst leaveobj = new LeaveMst(); leaveobj.LID = LeaveMst.GetNewLID(); leaveobj.Name = StuDT["Name"].ToString(); leaveobj.StudentId = int.Parse(Session["SID"].ToString()); leaveobj.Nodays = DropDownList1.SelectedIndex > 0 ? int.Parse(DropDownList1.SelectedValue) : 1; leaveobj.Rollno = ""; leaveobj.Message = txtmsg.Text; leaveobj.Insert(); lbl.Text = "Apply for leave successfully"; txtmsg.Text = ""; DropDownList1.SelectedIndex = 0; } catch (Exception ex) { lbl.Text = "Apply for leave failed"; } }
private void getRollNo() { int rno = 0; DataRow studentdt = StudentMst.GetMaxRow(); //int rstu = Convert.ToInt32(DivDT.Rows[0]["Seat"].ToString()) - Convert.ToInt32(StuDT.Rows.Count.ToString()); //lblstudent.Text = "Total Admitted =" + StuDT.Rows.Count.ToString() + " , Remaining Student = " + rstu; //string stddd = lblstd.Text.Substring(0, 1); if (studentdt != null) { rno = Convert.ToInt32(studentdt["RollNo"].ToString()) + 1; } if (rno.ToString().Length < 2) { string newrno = DateTime.Now.ToString("YY") + "000" + rno.ToString(); txtroll.Text = newrno; } else { txtroll.Text = rno.ToString(); } }
protected void btnsarch_Click(object sender, EventArgs e) { DataRow StuDr = StudentMst.GetDataByKey(Convert.ToInt32(drpstudent.SelectedValue)); if (StuDr != null) { lblroll.Text = StuDr["rollno"].ToString(); lblname.Text = StuDr["name"].ToString(); lblemail.Text = StuDr["email"].ToString(); lblmobile.Text = StuDr["mobile"].ToString(); lbldob.Text = StuDr["dob"].ToString(); lbladd.Text = StuDr["add"].ToString(); lblcity.Text = StuDr["city"].ToString(); lblpin.Text = StuDr["pincode"].ToString(); lbluname.Text = StuDr["uname"].ToString(); //lblpass.Text = StuDr["pass"].ToString(); imgg.ImageUrl = StuDr["image"].ToString(); MultiView1.ActiveViewIndex = 0; } else { MultiView1.ActiveViewIndex = -1; } }
protected void btnchangepass_Click(object sender, EventArgs e) { try { int studentId = 1; DataRow dr = StudentMst.GetDataByKey(studentId); if (dr != null && dr["Pass"].ToString() == txtcurrent.Text) { StudentMst studentObj = new StudentMst(); studentObj.Name = dr["Name"].ToString(); studentObj.StdName = dr["StdName"].ToString(); studentObj.DivName = dr["DivName"].ToString(); studentObj.DOB = dr["DOB"].ToString(); studentObj.EDate = dr["DOB"].ToString() != "" ? (DateTime?)Convert.ToDateTime(dr["DOB"].ToString()) : null; studentObj.Email = dr["Email"].ToString(); studentObj.Mobile = dr["Mobile"].ToString(); studentObj.RollNo = dr["RollNo"].ToString(); studentObj.Pincode = dr["Pincode"].ToString(); studentObj.Uname = dr["Uname"].ToString(); studentObj.Pass = txtnewpass.Text; studentObj.City = dr["City"].ToString(); studentObj.Add = dr["Add"].ToString(); studentObj.Image = dr["Image"].ToString(); studentObj.UpdateDataByKey(); lbl.Text = "Password Changed"; } else { lbl.Text = "Invalid Current Password"; } } catch (Exception ex) { lbl.Text = "update password fail"; } }
protected void btnstuadd_Click(object sender, EventArgs e) { try { DataTable studentDT = StudentMst.GetAllActiveData(); if (string.IsNullOrEmpty(txtroll.Text)) { lblmsg.Text = "Roll can't be null !!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); return; } if (string.IsNullOrEmpty(txtname.Text) || string.IsNullOrEmpty(txtemail.Text)) { lblmsg.Text = "Name and email can't be null !!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); return; } if (string.IsNullOrEmpty(txtuname.Text) || string.IsNullOrEmpty(txtpass.Text)) { lblmsg.Text = "user name and and password can't be null !!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); return; } else { DateTime bdate = Convert.ToDateTime(drpdd.SelectedItem.Text + " " + drpmm.SelectedItem.Text + " " + drpyyyy.SelectedItem.Text); StudentMst stdobj = new StudentMst(); stdobj.Name = txtname.Text; // stdobj.StdName = lblstd.Text; // stdobj.DivName = drpdiv.SelectedItem.Text; stdobj.DOB = bdate.GetDateTimeFormats()[8].ToString(); stdobj.EDate = DateTime.Now; stdobj.Email = txtemail.Text; stdobj.Mobile = txtmobi.Text; stdobj.RollNo = txtroll.Text; stdobj.Pincode = txtpin.Text; stdobj.Uname = txtuname.Text; stdobj.Pass = txtpass.Text; stdobj.City = txtcity.Text; stdobj.MachineCode = txt_MachineId.Text != "" ? (int?)Convert.ToInt32(txt_MachineId.Text): null; if (drpdiv.SelectedIndex > 0) { stdobj.DivName = drpdiv.SelectedItem.Text; stdobj.DivId = int.Parse(drpstd.SelectedValue); } if (drpstd.SelectedIndex > 0) { stdobj.StdName = drpdiv.SelectedItem.Text; stdobj.StdId = int.Parse(drpstd.SelectedValue); } if (!string.IsNullOrEmpty(FileUpload1.FileName)) { FileUpload1.SaveAs(Server.MapPath("~/Studentimg/" + FileUpload1.FileName)); stdobj.Image = "~/Studentimg/" + FileUpload1.FileName; } if (StudentId != null) { stdobj.SID = int.Parse(StudentId.ToString()); if (stdobj.UpdateDataByKey()) { lblmsg.Text = "Record updated Successfully"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); resret(); Response.Redirect("StudentReport.aspx", false); } } else { if (studentDT != null && studentDT.Rows.Count == 1) { lblmsg.Text = "UserName alredy exists !!"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); } stdobj.SID = StudentMst.GetNewSID(); stdobj.Insert(); lblmsg.Text = "Record Added Successfully"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); resret(); } } } catch (Exception ex) { lblmsg.Text = "Fail to Add record"; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "fadeLabelOut()", true); } }