public ResponseMessage getStudentsList(student_details slist) { if (slist.section_id.Equals(0) || slist.class_id.Equals(0) || slist.school_id.Equals(0)) { rs.code = 100; rs.message = "Enter proper details"; return(rs); } else { var entryPoint = (from ep in entt.student_details join e in entt.school_details on slist.school_id equals e.school_id where ep.school_id == slist.school_id where ep.class_id == slist.class_id where ep.section_id == slist.section_id select new { ep.student_image, ep.student_id, studentName = ep.student_first_name + ep.student_last_name, student_grade }); rs.Data = entryPoint; rs.code = 200; rs.message = "Data success"; return(rs); } }
public ResponseMessage perticularStudent(student_details sdata) { var entryPoint = (from ep in entt.student_details where ep.school_id == sdata.school_id where ep.student_id == sdata.student_id where ep.class_id == sdata.class_id where ep.section_id == sdata.section_id select new { ep.school_id, ep.student_admission_date, ep.student_area, ep.student_buliding_name, ep.student_chiled_no, ep.student_city, ep.student_dob, ep.student_father_mobile_no, ep.student_father_name, ep.student_father_occupation, ep.student_first_name, ep.student_flat_no, ep.student_gender, ep.student_image, ep.student_last_name, ep.student_mother_mobile_no, ep.student_mother_name, ep.student_mother_occupation, ep.student_no_of_siblings, ep.student_pincode, ep.student_roll_no, ep.student_admission_id, ep.student_class, ep.student_section, ep.student_state, ep.Student_status, ep.student_street, ep.student_street1, ep.student_id, ep.class_id, ep.section_id }); rs.Data = entryPoint; rs.code = 200; rs.message = "Data success"; return(rs); }
public IHttpActionResult updateStudents(student_details sdetails) { Boolean pp = new StudentDetailsRelated().updateStudentsList(sdetails); if (pp) { rs.code = 200; rs.message = "succesfully data has been updated"; return(Content(HttpStatusCode.OK, rs)); } else { rs.code = 100; rs.message = "failed to update"; return(Content(HttpStatusCode.OK, rs)); } }
public IHttpActionResult deleteStudent(student_details sdelete) { Boolean t = new StudentDetailsRelated().deleteStudent(sdelete); if (t) { rs.code = 200; rs.message = "succesfully data has been deleted"; return(Content(HttpStatusCode.OK, rs)); } else { rs.code = 100; rs.message = "failure to delete"; return(Content(HttpStatusCode.OK, rs)); } }
public IHttpActionResult addingStudentDetails(student_details sdetails) { Boolean a = new StudentDetailsRelated().addingStudentDetails(sdetails); if (a) { sdetails.insert_date = DateTime.Now; entt.student_details.Add(sdetails); entt.SaveChanges(); rs.code = 200; rs.message = "succesfully data has been inserted"; return(Content(HttpStatusCode.OK, rs)); } else { rs.code = 100; rs.message = "failed to insert data"; return(Content(HttpStatusCode.OK, rs)); } }
protected void login_Click(object sender, EventArgs e) { if (txt_emailid.Text.Length > 0 && txt_password.Text.Length > 0) { if (dd_login.Text == "Faculty") { st = "select * from Faculty where email='" + txt_emailid.Text + "' and Password='******'"; dt = get_datatable(st); if (dt.Rows.Count > 0) { int session_faculty = dt.Rows[0]["faculty_id"].GetHashCode(); Session["session_faculty"] = session_faculty; Session["faculty"] = dt.Rows[0][0].ToString(); Faculty_details obj = new Faculty_details(); obj.EmailID = dt.Rows[0]["email"].ToString(); obj.name = dt.Rows[0]["name"].ToString(); Session["faculty_details"] = obj; Response.Redirect("Faculty/dashboard.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Login failed');", true); } } else if (dd_login.Text == "Student") { st = "select * from student where email='" + txt_emailid.Text + "' and Password='******'"; dt = get_datatable(st); Session["std"] = txt_emailid.Text; Session["std1"] = txt_password.Text; if (dt.Rows.Count > 0) { int session_std = dt.Rows[0]["Reg_number"].GetHashCode(); int sem = dt.Rows[0]["sem"].GetHashCode(); Session["sem"] = sem; Session["dept"] = dt.Rows[0]["dept"].ToString(); Session["session_std"] = session_std; Session["student"] = dt.Rows[0][0].ToString(); student_details obj = new student_details(); obj.EmailID = dt.Rows[0]["email"].ToString(); obj.name = dt.Rows[0]["fullname"].ToString(); Session["student_details"] = obj; Response.Redirect("student/dashboard.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Login failed');", true); } } else if (dd_login.Text == "Admin") { st = "select * from admin where email='" + txt_emailid.Text + "' and Password='******'"; dt = get_datatable(st); if (dt.Rows.Count > 0) { int session_admin = dt.Rows[0]["admin_id"].GetHashCode(); Session["session_admin"] = session_admin; Session["admin"] = dt.Rows[0][0].ToString(); Adminlogin_details objAdminlogin_details = new Adminlogin_details(); objAdminlogin_details.fullname = dt.Rows[0]["Name"].ToString(); Session["Adminlogin_details"] = objAdminlogin_details; Response.Redirect("Admin/dashboard.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Login failed');", true); } } } }