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