public void GetSubjects() { List <addstudent> listStdInfo = new List <addstudent>(); listStdInfo.Clear(); string cs = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("SELECT * FROM subjects", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { addstudent StdInfo = new addstudent(); StdInfo.std_id = Convert.ToInt32(rdr["subjects_id"]); StdInfo.std_name = rdr["subjects_name"].ToString(); StdInfo.std_class = rdr["total_marks"].ToString(); listStdInfo.Add(StdInfo); } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listStdInfo).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listStdInfo)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public async Task <ActionResult> EditStudent(string id, addstudent updatestudent) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://www.edujinni.in/"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Accept.Clear(); updatestudent.school_id = 1; updatestudent.student_section = "chess"; updatestudent.student_class = "1"; updatestudent.section_id = 3; updatestudent.class_id = 6; updatestudent.student_admission_id = "123"; updatestudent.insert_by = ""; updatestudent.update_by = "sai"; updatestudent.student_admission_date = DateTime.Now; updatestudent.Student_status = "sai"; HttpResponseMessage response = await client.PostAsJsonAsync("updateStudentDetails", updatestudent); if (response.IsSuccessStatusCode) { Response.Write("<script>alert('Student Details Updated')</script>"); return(RedirectToAction("StudentsOverView")); } else { Response.Write("<script>alert('Error Updating the Student')</script>"); } } return(View(updatestudent)); }
public void EditTecherInfo(addstudent ObjEditStdInfo) { List <recexist> listrecexist = new List <recexist>(); listrecexist.Clear(); string cs = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection connection = new SqlConnection(cs)) { connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction("SampleTransaction"); command.Connection = connection; command.Transaction = transaction; string varPassword = GetMD5HashData(ObjEditStdInfo.std_password); command.CommandText = "UPDATE addteacher SET t_name ='" + ObjEditStdInfo.std_name + "',t_lastname ='" + ObjEditStdInfo.std_lastname + "', t_father ='" + ObjEditStdInfo.std_father + "',t_gender ='" + ObjEditStdInfo.std_gender + "', t_phone_no ='" + ObjEditStdInfo.std_phone_no + "' WHERE t_id= '" + ObjEditStdInfo.std_id + "'"; command.ExecuteNonQuery(); command.CommandText = "UPDATE login SET login_name ='" + ObjEditStdInfo.std_name + "',login_email ='" + ObjEditStdInfo.std_email + "',login_password ='******' WHERE member_id= '" + ObjEditStdInfo.std_id + "'"; command.ExecuteNonQuery(); transaction.Commit(); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listrecexist).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listrecexist)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public void GetTecherInfo() { List <addstudent> listStdInfo = new List <addstudent>(); listStdInfo.Clear(); string cs = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("SELECT * FROM addteacher ,login where login.member_id=addteacher.t_id ", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { addstudent StdInfo = new addstudent(); StdInfo.std_id = Convert.ToInt32(rdr["t_id"]); StdInfo.std_name = rdr["t_name"].ToString(); StdInfo.std_father = rdr["t_father"].ToString(); StdInfo.std_phone_no = rdr["t_phone_no"].ToString(); StdInfo.std_gender = rdr["t_gender"].ToString(); StdInfo.std_lastname = rdr["t_lastname"].ToString(); StdInfo.std_email = rdr["login_email"].ToString(); StdInfo.std_password = rdr["login_password"].ToString(); listStdInfo.Add(StdInfo); } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listStdInfo).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listStdInfo)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public ActionResult EditStudent(string id, string name, addstudent studedetails) { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://www.edujinni.in/"); studedetails.school_id = 1; studedetails.student_id = id; studedetails.class_id = 6; studedetails.section_id = 3; var upd = client.PostAsJsonAsync <addstudent>("perticularStudent", studedetails); upd.Wait(); var result = upd.Result; if (result.IsSuccessStatusCode) { var resultt = result.Content.ReadAsStringAsync().Result; JObject o = JObject.Parse(resultt); JArray a = (JArray)o["Data"]; IList <addstudent> stu = a.ToObject <IList <addstudent> >(); foreach (var item in stu) { if (id == item.student_id) { at.student_first_name = item.student_first_name; at.student_last_name = item.student_last_name; at.student_section = item.student_section; at.student_admission_date = item.student_admission_date; at.student_gender = item.student_gender; at.student_father_mobile_no = item.student_father_mobile_no; at.student_dob = item.student_dob; at.student_father_name = item.student_father_name; at.student_father_occupation = item.student_father_occupation; at.student_mother_name = item.student_mother_name; at.student_mother_mobile_no = item.student_mother_mobile_no; at.student_mother_occupation = item.student_mother_occupation; at.student_chiled_no = item.student_chiled_no; at.student_no_of_siblings = item.student_no_of_siblings; at.student_flat_no = item.student_flat_no; at.student_buliding_name = item.student_buliding_name; at.student_street = item.student_street; at.student_area = item.student_area; at.student_city = item.student_city; at.student_state = item.student_state; at.student_pincode = item.student_pincode; at.student_roll_no = item.student_roll_no; at.student_id = item.student_id; } } } else { Response.Write("<script>alert('Error Retreiving Details');</script>"); } } ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator."); return(View(at)); }
public void DelClasses(addstudent ObjDelStdInfo) { string connectionCS = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection objconn = new SqlConnection(connectionCS)) { objconn.Open(); SqlCommand cmd3 = new SqlCommand("DELETE FROM classes WHERE classes_id = '" + ObjDelStdInfo.std_id + "'", objconn); cmd3.ExecuteNonQuery(); objconn.Close(); } }
public void fnAddSubject(addstudent ObjAddStd) { List <recexist> listrecexist = new List <recexist>(); listrecexist.Clear(); string cs = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection connection = new SqlConnection(cs)) { connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction("SampleTransaction"); command.Connection = connection; command.Transaction = transaction; string exist = ""; command.CommandText = "SELECT * FROM subjects WHERE subjects_name ='" + ObjAddStd.std_name + "'"; SqlDataAdapter objadp = new SqlDataAdapter(command.CommandText, connection); objadp.SelectCommand.Transaction = transaction; DataTable dtr = new DataTable(); objadp.Fill(dtr); foreach (DataRow dtrow in dtr.Rows) { recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "found"; listrecexist.Add(Objrecexist); exist = "found"; } if (exist == "") { command.CommandText = "INSERT INTO subjects (subjects_name, total_marks) VALUES ('" + ObjAddStd.std_name + "', '" + ObjAddStd.std_lastname + "')" + "SELECT SCOPE_IDENTITY()"; string insertedID = command.ExecuteScalar().ToString(); recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "Not Found"; listrecexist.Add(Objrecexist); } transaction.Commit(); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listrecexist).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listrecexist)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public void DelTecherInfo(addstudent ObjDelStdInfo) { string connectionCS = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection objconn = new SqlConnection(connectionCS)) { objconn.Open(); SqlCommand cmd3 = new SqlCommand("DELETE FROM addteacher WHERE t_id = '" + ObjDelStdInfo.std_id + "'", objconn); cmd3.ExecuteNonQuery(); objconn.Close(); objconn.Open(); SqlCommand cmd4 = new SqlCommand("DELETE FROM login WHERE member_id = '" + ObjDelStdInfo.std_id + "'", objconn); cmd4.ExecuteNonQuery(); objconn.Close(); } }
public void UpdateSubject(addstudent ObjEditStdInfo) { List <recexist> listrecexist = new List <recexist>(); listrecexist.Clear(); string ConnectionString = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection objcon = new SqlConnection(ConnectionString)) { //objcon.Open(); //SqlCommand cmd3 = new SqlCommand("SELECT subjects_name FROM subjects WHERE subjects_name ='" + ObjEditStdInfo.std_name + "'", objcon); //SqlDataReader re = null; //re = cmd3.ExecuteReader(); //if (re.HasRows) //{ // recexist Objrecexist = new recexist(); // Objrecexist.Dataexist = "found"; // listrecexist.Add(Objrecexist); //} //else //{ objcon.Close(); objcon.Open(); SqlCommand cmnd2 = new SqlCommand("UPDATE subjects SET subjects_name ='" + ObjEditStdInfo.std_name + "',total_marks ='" + ObjEditStdInfo.std_lastname + "' WHERE subjects_id= '" + ObjEditStdInfo.std_id + "'", objcon); cmnd2.ExecuteNonQuery(); objcon.Close(); recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "Not Found"; listrecexist.Add(Objrecexist); //} //objcon.Close(); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listrecexist).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listrecexist)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public void Addclasses(addstudent ObjAddStd) { List <recexist> listrecexist = new List <recexist>(); listrecexist.Clear(); string ConnectionString = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection objcon = new SqlConnection(ConnectionString)) { objcon.Open(); SqlCommand cmd3 = new SqlCommand("SELECT classes_name FROM classes WHERE classes_name ='" + ObjAddStd.std_name + "'", objcon); SqlDataReader re = null; re = cmd3.ExecuteReader(); if (re.HasRows) { recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "found"; listrecexist.Add(Objrecexist); } else { objcon.Close(); objcon.Open(); SqlCommand cmnd2 = new SqlCommand("INSERT INTO classes (classes_name) VALUES ('" + ObjAddStd.std_name + "')", objcon); cmnd2.ExecuteNonQuery(); objcon.Close(); recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "Not Found"; listrecexist.Add(Objrecexist); } objcon.Close(); } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listrecexist).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listrecexist)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
public async Task <ActionResult> AddStudent(addstudent model) { List <SelectListItem> li = new List <SelectListItem>(); using (HttpClient client = new HttpClient()) { client.BaseAddress = new Uri("http://www.edujinni.in/"); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); client.DefaultRequestHeaders.Accept.Clear(); model.school_id = 1; model.class_id = 5; model.section_id = 4; model.student_section = "c"; model.student_chiled_no = 1; model.insert_by = "ss"; model.insert_date = DateTime.Now; model.update_by = ""; model.update_date = DateTime.Now; model.student_section = "c"; model.student_admission_date = DateTime.Now; model.Student_status = "sai"; model.student_class = "1st class"; model.student_admission_id = "1234"; model.student_password = "******"; model.parent_password = "******"; HttpResponseMessage response = await client.PostAsJsonAsync("addingStudentDetails", model); HttpResponseMessage classes = await client.PostAsJsonAsync("classNames/classDetailsList", model); HttpResponseMessage sections = await client.PostAsJsonAsync("sectionList", model); if (classes.IsSuccessStatusCode == true) { var classnames = classes.Content.ReadAsStringAsync().Result; JObject cl = JObject.Parse(classnames); JArray cll = (JArray)cl["Data"]; IList <addstudent> classdetails = cll.ToObject <IList <addstudent> >(); ViewBag.clsname = classdetails; List <Edujinni.Models.addstudent> p = (List <Edujinni.Models.addstudent>)classdetails; foreach (var item in p) { li.Add(new SelectListItem() { Text = item.student_class, Value = item.class_id.ToString() }); } } if (response.IsSuccessStatusCode == true) { Response.Write("<script>alert('Student Added successfully')</script>"); return(RedirectToAction("StudentsOverView")); } else { Response.Write("<script>alert('Error adding Student')</script>"); ModelState.AddModelError(string.Empty, "Server Error. Please contact administrator."); } } return(View(model)); }
public void fnAddStd(addstudent ObjAddStd) { List <recexist> listrecexist = new List <recexist>(); listrecexist.Clear(); string cs = ConfigurationManager.ConnectionStrings["student_data"].ConnectionString; using (SqlConnection connection = new SqlConnection(cs)) { connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; transaction = connection.BeginTransaction("SampleTransaction"); command.Connection = connection; command.Transaction = transaction; string varPassword = GetMD5HashData(ObjAddStd.std_password); string exist = ""; command.CommandText = "SELECT std_name FROM add_std_info WHERE std_name ='" + ObjAddStd.std_name + "' AND std_father ='" + ObjAddStd.std_father + "' AND classes_id ='" + ObjAddStd.std_class + "' AND std_gender ='" + ObjAddStd.std_gender + "' AND std_phone_no ='" + ObjAddStd.std_phone_no + "'"; objadp = new SqlDataAdapter(command.CommandText, connection); objadp.SelectCommand.Transaction = transaction; dtr = new DataTable(); objadp.Fill(dtr); foreach (DataRow dtrow in dtr.Rows) { recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "found"; listrecexist.Add(Objrecexist); exist = "found"; } if (exist == "") { command.CommandText = "INSERT INTO add_std_info (std_name, std_lastname,std_father,std_gender, classes_id, std_phone_no) VALUES ('" + ObjAddStd.std_name + "', '" + ObjAddStd.std_lastname + "','" + ObjAddStd.std_father + "', '" + ObjAddStd.std_gender + "', '" + ObjAddStd.std_class + "', '" + ObjAddStd.std_phone_no + "')" + "SELECT SCOPE_IDENTITY()"; string insertedID = command.ExecuteScalar().ToString(); command.CommandText = "SELECT login_email FROM login WHERE login_email ='" + ObjAddStd.std_email + "' "; objadp = new SqlDataAdapter(command.CommandText, connection); objadp.SelectCommand.Transaction = transaction; dtr = new DataTable(); objadp.Fill(dtr); foreach (DataRow dtrow in dtr.Rows) { recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "found_email"; listrecexist.Add(Objrecexist); exist = "found_email"; } if (exist == "") { command.CommandText = "INSERT INTO login (login_email, login_password,login_name,login_type,member_id) VALUES ( '" + ObjAddStd.std_email + "', '" + varPassword + "','" + ObjAddStd.std_name + "','student','" + insertedID + "')"; command.ExecuteNonQuery(); recexist Objrecexist = new recexist(); Objrecexist.Dataexist = "Not Found"; listrecexist.Add(Objrecexist); transaction.Commit(); } } } JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Clear(); Context.Response.ContentType = "application/json"; Context.Response.AddHeader("content-length", js.Serialize(listrecexist).Length.ToString()); Context.Response.Flush(); Context.Response.Write(js.Serialize(listrecexist)); HttpContext.Current.ApplicationInstance.CompleteRequest(); }