private int AddGroup(CreateGroupModel group) { string expressSql = "createStudyGroup"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(expressSql, connection) { CommandType = System.Data.CommandType.StoredProcedure }; SqlParameter namePar = new SqlParameter // parameter for enter name { ParameterName = "@nameSG", Value = group.NameStudyGroup }; command.Parameters.Add(namePar); // add SqlParameter idTeacherPar = new SqlParameter // parameter for id { ParameterName = "@IdTeach", Value = group.IdTeacher }; command.Parameters.Add(idTeacherPar); int result = (int)command.ExecuteScalar(); return(result); } }
public List <EmployeeModel> GetStudentsOfGroup(int IdGroup) { string expressSql = "GetStudentsInGroup"; List <EmployeeModel> students = new List <EmployeeModel>(); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(expressSql, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter idGroupPar = new SqlParameter // parameter for id { ParameterName = "@idSG", Value = IdGroup }; command.Parameters.Add(idGroupPar); var employee = command.ExecuteReader(); if (employee.HasRows) { while (employee.Read()) { EmployeeModel e = new EmployeeModel { IdEmployee = employee.GetInt32(0), NameEmployee = employee.GetString(1), NameOrganization = employee.GetString(2) }; students.Add(e); } } employee.Close(); return(students); } }
private TeachersModel GetTeacher(int IdGroup) { string expressSql = "getTeacher"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(expressSql, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter TeacherIdPar = new SqlParameter // parameter for id { ParameterName = "@IdGroup", Value = IdGroup }; command.Parameters.Add(TeacherIdPar); // add var g = command.ExecuteReader(); g.Read(); TeachersModel res = new TeachersModel { IdTeacher = g.GetInt32(0), NameTeacher = g.GetString(1) }; g.Close(); return(res); } }
public ActionResult CreateStudent(CreateStudentModel student) { string expressSql = "addStudent2"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(expressSql, connection) { CommandType = System.Data.CommandType.StoredProcedure }; SqlParameter namePar = new SqlParameter // parameter for enter name { ParameterName = "@idGroup", Value = student.IdStudyGroup }; command.Parameters.Add(namePar); // add SqlParameter idStudPar = new SqlParameter // parameter for id { ParameterName = "@idEmpl", Value = student.IdEmployee }; command.Parameters.Add(idStudPar); var result = command.ExecuteNonQuery(); } return(RedirectToAction("Edit", new { id = student.IdStudyGroup })); }
private string GetGroup(int IdGroup) { string expressSql = "getGroup"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(expressSql, connection); command.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter GroupIdPar = new SqlParameter // parameter for id { ParameterName = "@IdGroup", Value = IdGroup }; command.Parameters.Add(GroupIdPar); // add var g = command.ExecuteReader(); g.Read(); var res = g.GetString(0); g.Close(); return(res); } }