예제 #1
0
    public static DataTable pricefill(Object fillprice)
    {
        SqlCommand cmd = new SqlCommand("Select_Products");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #2
0
    public static DataTable PendingOrder(Object OrderPending)
    {
        SqlCommand cmd = new SqlCommand("Fill_PendingOrders");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #3
0
    public static DataTable SelectOrderId(Object OrderIdSelect)
    {
        SqlCommand cmd = new SqlCommand("Select_OrderId");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #4
0
    public static DataTable categoryfill(Object fillcategory)
    {
        SqlCommand cmd = new SqlCommand("Fill_Category");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #5
0
    public static DataTable ViewSale(Object SaleView)
    {
        SqlCommand cmd = new SqlCommand("Select_Sales");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #6
0
    public static DataTable ViewUser(Object UserView)
    {
        SqlCommand cmd = new SqlCommand("View_User");
        DataTable  dt  = DBLAYER.ExecuteGetDataTable(cmd);

        return(dt);
    }
예제 #7
0
    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);
    }
예제 #8
0
    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);
    }