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);
}
}
