public List<OrderSummary> getOrders(string email)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetOrders";
cmd.Parameters.AddWithValue("@email", email);
DataTable dt = db.Execute(cmd);
List<OrderSummary> orders = new List<OrderSummary>();
foreach (DataRow dr in dt.Rows)
{
OrderSummary ordersummary = new OrderSummary
{
OrderID = Int32.Parse(dr["OrderNo"].ToString()),
OrderDate = DateTime.Parse(dr["OrderDate"].ToString()),
ShipDate = DateTime.Parse(dr["ShipDate"].ToString()).Date,
OrderStatus = dr["OrderStatus"].ToString(),
BillingStatus = dr["BillingStatus"].ToString(),
OrderType = dr["OrderType"].ToString(),
OrderAmount = double.Parse(dr["OrderAmount"].ToString())
};
orders.Add(ordersummary);
}
return orders;
}
public OrderSummary getOrder(int OrderID)
{
DB db = new DB();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetOrder";
cmd.Parameters.AddWithValue("@OrderNo", OrderID);
DataTable dt = db.Execute(cmd);
DataRow dr = dt.Rows[0];
OrderSummary ordersummary = new OrderSummary
{
OrderID = Int32.Parse(dr["OrderNo"].ToString()),
OrderDate = DateTime.Parse(dr["OrderDate"].ToString()),
ShipDate = DateTime.Parse(dr["ShipDate"].ToString()).Date,
OrderStatus = dr["OrderStatus"].ToString(),
BillingStatus = dr["BillingStatus"].ToString(),
OrderType = dr["OrderType"].ToString(),
OrderAmount = double.Parse(dr["OrderAmount"].ToString())
};
return ordersummary;
}