public List<Student> GetAllStudents() { try { using (conn) { empList = new List<Student>(); conn = new SqlConnection(connString); command = new SqlCommand(); command.Connection = conn; command.Connection.Open(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "up_getAllStudents"; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Student objStudent = new Student(); objStudent.Nombre = reader.GetString(0); objStudent.ApellidoPaterno = reader.GetString(1); objStudent.ApellidoMaterno = reader.GetString(2); objStudent.Edad = reader.GetInt32(3); objStudent.Codigo = reader.GetInt32(4); empList.Add(objStudent); } command.Connection.Close(); return empList; } } catch (Exception ex) { //err.ErrorMessage = ex.Message.ToString(); throw; } }
public Student UpdateStudent(string ID, Student updatePerson) { return objDal.UpdateStudent(ID,updatePerson); }
public Student CreateStudent(Student createPerson) { return objDal.saveStudent(createPerson); }
public Student UpdateStudent(String ID, Student emp) { try { using (conn) { Student objStudent = new Student(); conn = new SqlConnection(connString); command = new SqlCommand(); command.Connection = conn; command.Connection.Open(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "up_updateStudent"; SqlParameter codigo = new SqlParameter("@Codigo", ID); SqlParameter nombres = new SqlParameter("@Nombre", emp.Nombre); SqlParameter apePat = new SqlParameter("@ApellidoPaterno", emp.ApellidoPaterno); SqlParameter apeMat = new SqlParameter("@ApellidoMaterno", emp.ApellidoMaterno); SqlParameter edad = new SqlParameter("@Edad", emp.Edad); command.Parameters.AddRange(new SqlParameter[] { codigo, nombres, apePat, apeMat, edad }); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { objStudent.Nombre = reader.GetString(0); objStudent.ApellidoPaterno = reader.GetString(1); objStudent.ApellidoMaterno = reader.GetString(2); objStudent.Edad = reader.GetInt32(3); objStudent.Codigo = reader.GetInt32(4); } } command.Connection.Close(); return objStudent; } } catch (Exception ex) { //err.ErrorMessage = ex.Message.ToString(); throw; } }
public Student GetStudentByID(String ID) { try { Student objStudent = new Student(); conn = new SqlConnection(connString); command = new SqlCommand(); command.Connection = conn; command.Connection.Open(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "up_getStudentByID"; SqlParameter IDparam = new SqlParameter("@Codigo", ID); command.Parameters.Add(IDparam); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { objStudent.Nombre = reader.GetString(0); objStudent.ApellidoPaterno = reader.GetString(1); objStudent.ApellidoMaterno = reader.GetString(2); objStudent.Edad = reader.GetInt32(3); objStudent.Codigo = reader.GetInt32(4); } } command.Connection.Close(); return objStudent; } catch (Exception ex) { //err.ErrorMessage = ex.Message.ToString(); throw; } }