public IEnumerable <Employee> GetAll()
{
try
{
List <Employee> employees = new List <Employee>();
SqlCommand command = context.CreateCommand();
command.CommandText = GetEmployeesCommand;
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Employee emp = new Employee();
emp.EmployeeId = Convert.ToInt32(reader["EmployeeId"]);
emp.Name = reader["Name"].ToString();
emp.Position = reader["Position"].ToString();
employees.Add(emp);
}
}
else
{
return(null);
}
reader.Close();
return(employees);
}
catch (Exception exc)
{
throw exc;
}
}
public IEnumerable <Deliverer> GetAll()
{
try
{
List <Deliverer> deliverers = new List <Deliverer>();
SqlCommand command = context.CreateCommand();
command.CommandText = GetDeliverersCommand;
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Deliverer deliverer = new Deliverer();
deliverer.DelivererId = Convert.ToInt32(reader["DelivererId"]);
deliverer.DelivererName = reader["DelivererName"].ToString();
deliverers.Add(deliverer);
}
}
else
{
return(null);
}
reader.Close();
return(deliverers);
}
catch (Exception exc)
{
throw exc;
}
}
public IEnumerable <Machine> GetAll()
{
List <Machine> machines = new List <Machine>();
try
{
SqlCommand command = context.CreateCommand();
command.CommandText = GetMachinesCommand;
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Machine machine = new Machine();
machine.MachineId = Convert.ToInt32(reader["MachineId"]);
machine.MachineName = reader["MachineName"].ToString();
machine.Price = (float)reader["Price"];
machine.DateOfDelivery = (DateTime)reader["DateOfDelivery"];
machine.DelivererId = (int)(reader["DelivererId"]);
machines.Add(machine);
}
}
reader.Close();
}
catch { }
return(machines);
}
public IEnumerable <Request> GetAll()
{
try
{
List <Request> requests = new List <Request>();
SqlCommand command = context.CreateCommand();
command.CommandText = GetRequestsCommand;
command.CommandType = CommandType.Text;
var reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Request request = new Request();
request.RequestId = Convert.ToInt32(reader["RequestId"]);
request.RequestCreatorId = (int)reader["RequestCreatorId"];
if (reader["RequestHandlerId"] != DBNull.Value)
{
request.RequestHandlerId = (int)reader["RequestHandlerId"];
}
else
{
request.RequestHandlerId = null;
}
request.DateOfCreate = (DateTime)reader["DateOfCreate"];
request.MachineId = (int)(reader["MachineId"]);
request.RequestStatusId = (int)(reader["RequestStatusId"]);
if (reader["InnerRequestId"] != DBNull.Value)
{
request.InnerRequestId = (int)(reader["InnerRequestId"]);
}
else
{
request.InnerRequestId = null;
}
requests.Add(request);
}
}
else
{
return(null);
}
reader.Close();
return(requests);
}
catch (Exception exc)
{
throw exc;
}
}