public WorkOrderCollection GetTop5WorkOrders()
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetTop5WorkOrders())
{
while (dr.Read())
{
workOrderCollection.Add(PopulateReader(dr));
}
dr.Close();
}
return workOrderCollection;
}
public int GetMaxId()
{
int maxId = 0;
using (IDataReader dr = new WorkOrderDataAdapter().GetMaxId())
{
if (dr.Read())
{
maxId = Convert.ToInt32(dr["id"]);
}
dr.Close();
}
return maxId;
}
public WorkOrder GetWorkOrder(int workOrderId)
{
WorkOrder workOrder = new WorkOrder();
using (IDataReader dr = new WorkOrderDataAdapter().GetWorkOrderById(workOrderId))
{
if (dr.Read())
{
workOrder = PopulateReader(dr);
}
dr.Close();
}
return workOrder;
}
public WorkOrderCollection GetTop5Materials()
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetTop5Materials())
{
while (dr.Read())
{
WorkOrder workOrder = new WorkOrder();
workOrder.MaterialId = dr["MaterialId"].ToString();
workOrderCollection.Add(workOrder);
}
dr.Close();
}
return workOrderCollection;
}
public WorkOrderCollection GetTop5Customers()
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetTop5Customers())
{
while (dr.Read())
{
WorkOrder workOrder = new WorkOrder();
workOrder.CustomerId = Convert.ToInt32(dr["CustomerId"]);
workOrderCollection.Add(workOrder);
}
dr.Close();
}
return workOrderCollection;
}
public bool IsWorkOrderExist(int id)
{
bool exist = false;
using (IDataReader dr = new WorkOrderDataAdapter().GetWorkOrderById(id))
{
if (dr.Read())
exist = true;
dr.Close();
}
return exist;
}
public WorkOrderCollection GetWorkOrdersByCustomerName(string name)
{
WorkOrderCollection workOrderCollection = new WorkOrderCollection();
using (IDataReader dr = new WorkOrderDataAdapter().GetWorkOrdersByCustomerName(name))
{
while (dr.Read())
{
workOrderCollection.Add(PopulateReader(dr));
}
dr.Close();
}
return workOrderCollection;
}
