// Make a stock movement
public string InOrOutStock(List <AppProducts> EditProductsList, string InOrOutString, string StockOrSaleString, int TotalPrice)
{
// Parameters
var NewStockProductsTable = DataTableExtensions.CreateDataTable(EditProductsList);
var ParameterNewStockProductsTable = new SqlParameter("@NewStockProductsTable", SqlDbType.Structured);
ParameterNewStockProductsTable.Value = NewStockProductsTable;
ParameterNewStockProductsTable.TypeName = "[dbo].[AspNetProductsType]"; // Products Table Type
var ParameterInOrOutString = new SqlParameter("@InOrOut", InOrOutString);
var ParameterStockOrSaleString = new SqlParameter("@StockOrSale", StockOrSaleString);
var ParameterTotalPrice = new SqlParameter("@TotalPrice", TotalPrice);
// Update stock in database
var AddOrDeleteStockResponse = this.Database
.ExecuteSqlCommand("EXEC [dbo].[SPInOrOutStock] @NewStockProductsTable, @InOrOut, @StockOrSale, @TotalPrice",
ParameterNewStockProductsTable,
ParameterInOrOutString,
ParameterStockOrSaleString,
ParameterTotalPrice);
// If any product stock was updated
if (AddOrDeleteStockResponse > 0)
{
// Get the new stock from the database
var NewStock = this.AppProducts.FromSql("SPGetProducts @NewStockProductsTable", ParameterNewStockProductsTable).ToList();
return(JsonConvert.SerializeObject(NewStock));
}
return("");
}
// Get last sold products by specific day in month
public string PreviousSoldProducts(List <AppProducts> MovementProductList, string DateToPredict)
{
// Parameters
var ProductsToPredictTable = DataTableExtensions.CreateDataTable(MovementProductList);
var ParameterProductsToPredictTable = new SqlParameter("@ProductsToPredictTable", SqlDbType.Structured);
ParameterProductsToPredictTable.Value = ProductsToPredictTable;
ParameterProductsToPredictTable.TypeName = "[dbo].[AspNetProductsType]"; // Products Table Type
var ParameterDateToPredict = new SqlParameter("@DateToPredict", DateToPredict);
// Update stock in database
var PreviousSoldProductsResponse = this.AppProductsToPredict
.FromSql("SPPreviousSoldProducts @ProductsToPredictTable, @DateToPredict",
ParameterProductsToPredictTable,
ParameterDateToPredict).AsNoTracking().ToList();
return(JsonConvert.SerializeObject(PreviousSoldProductsResponse));
}
