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