private void DbFillEmployees(SqlConnector connector, ADepartament departament, int index)
{
var sqlQuery = $@"SELECT * FROM Employees
WHERE DepartamentId = {index}";
using (var reader = connector.GetData(sqlQuery))
{
while (reader.Read())
{
var currentEmployee = ConvertSqlData.ToEmployee(reader, departament);
if (currentEmployee != null)
{
departament.AddEmployee(currentEmployee);
}
}
}
}
/// <summary>
/// Конвертирует данные Сотрудника
/// </summary>
/// <param name="reader"></param>
/// <param name="departament"></param>
/// <returns></returns>
public static Employee ToEmployee(SqlDataReader reader, ADepartament departament)
{
try
{
var id = (int)reader[0];
var fName = (string)reader[1];
var lName = (string)reader[2];
var phone = (long)reader[3];
return(new Employee(departament, fName, lName, phone, id));
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(null);
}
public static Employee GetLastEmployee(SqlConnectionStringBuilder stringBuilder, ADepartament departament)
{
var sqlQuery = @"SELECT TOP 1 *
FROM Employees
ORDER BY ID DESC";
Employee lastEmployee = null;
using (var connector = new SqlConnector(stringBuilder))
{
var reader = connector.GetData(sqlQuery);
while (reader.Read())
{
lastEmployee = ConvertSqlData.ToEmployee(reader, departament);
}
}
return(lastEmployee);
}
public static Employee GetEmployeeById(SqlConnectionStringBuilder stringBuilder, int id, ADepartament departament)
{
var sqlQuery = $@"SELECT * FROM Employees
WHERE Id = {id}";
Employee lastEmployee = null;
using (var connector = new SqlConnector(stringBuilder))
{
var reader = connector.GetData(sqlQuery);
while (reader.Read())
{
lastEmployee = ConvertSqlData.ToEmployee(reader, departament);
}
}
return(lastEmployee);
}
