public List <ReorderStockListVM> ReorderStockLists(string status)
{
List <ReorderStockListVM> reorderStockLists = new List <ReorderStockListVM>();
SqlDataReader data = null;
try
{
string sql = @"SELECT po.ID, po.Date, po.Status, e.Name
FROM PurchaseOrder po, Employee e
WHERE Status = @status
AND po.EmpID = e.ID";
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@status", status);
connection.Open();
data = cmd.ExecuteReader();
ReorderStockListVM stocks = null;
while (data.Read())
{
stocks = new ReorderStockListVM()
{
Id = Convert.ToInt32(data["ID"]),
RequestedDate = Convert.ToDateTime(data["Date"]),
Status = data["Status"].ToString(),
EmpName = data["Name"].ToString()
};
reorderStockLists.Add(stocks);
}
}
finally {
if (data != null)
{
data.Close();
}
connection.Close();
}
return(reorderStockLists);
}
public List <ReorderStockListVM> ApprovedReorderStockList()
{
List <ReorderStockListVM> reorderStockLists = new List <ReorderStockListVM>();
SqlDataReader data = null;
try
{
string sql = @"SELECT * FROM PurchaseOrder WHERE Status = 'Approved'";
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
data = cmd.ExecuteReader();
ReorderStockListVM stocks = null;
while (data.Read())
{
stocks = new ReorderStockListVM()
{
Id = Convert.ToInt32(data["ID"]),
RequestedDate = Convert.ToDateTime(data["Date"]),
Status = data["Status"].ToString()
};
reorderStockLists.Add(stocks);
}
}
finally
{
if (data != null)
{
data.Close();
}
connection.Close();
}
return(reorderStockLists);
}
public List <ReorderStockListVM> PurchaseOrderHistory()
{
List <ReorderStockListVM> purchaseOrders = new List <ReorderStockListVM>();
SqlDataReader data = null;
ReorderStockListVM purchaseOrder = null;
try
{
string sql = @"SELECT *
FROM PurchaseOrder
WHERE Status IN ('Ordered', 'Delivered', 'Processing')";
SqlCommand cmd = new SqlCommand(sql, connection);
connection.Open();
data = cmd.ExecuteReader();
while (data.Read())
{
purchaseOrder = new ReorderStockListVM()
{
Id = Convert.ToInt32(data["ID"]),
RequestedDate = Convert.ToDateTime(data["Date"]),
Status = data["Status"].ToString()
};
purchaseOrders.Add(purchaseOrder);
}
}
finally
{
if (data != null)
{
data.Close();
}
connection.Close();
}
return(purchaseOrders);
}
