public static DataTable pricefill(Object fillprice)
{
SqlCommand cmd = new SqlCommand("Select_Products");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable PendingOrder(Object OrderPending)
{
SqlCommand cmd = new SqlCommand("Fill_PendingOrders");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable SelectOrderId(Object OrderIdSelect)
{
SqlCommand cmd = new SqlCommand("Select_OrderId");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable categoryfill(Object fillcategory)
{
SqlCommand cmd = new SqlCommand("Fill_Category");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ViewSale(Object SaleView)
{
SqlCommand cmd = new SqlCommand("Select_Sales");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable ViewUser(Object UserView)
{
SqlCommand cmd = new SqlCommand("View_User");
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable groceryfill(Object fillgrocery)
{
SqlCommand cmd = new SqlCommand("Fill_Grocery");
cmd.Parameters.AddWithValue("@categoryid", fillgrocery.Category_Id);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}
public static DataTable PendingStatus(Object StatusPending)
{
SqlCommand cmd = new SqlCommand("Select_DeliveryStatus");
cmd.Parameters.AddWithValue("@orderid", StatusPending.Order_Id);
DataTable dt = DBLAYER.ExecuteGetDataTable(cmd);
return(dt);
}