/// <summary>
/// Realiza uma query(consulta) com base nos parametros
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <CatalogType> CatalogTypeById(int id)
{
var parameterProc = new Dictionary <string, object>();
parameterProc.Add("@id", id);
return(JsonConvert.DeserializeObject <CatalogType>(_database.GetResponse("pr_locate_type_id_sel", parameterProc)));
}
/// <summary>
/// Recupera uma marca de produto conforme o id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <CatalogBrand> CatalogBrandIdAsync(int id)
{
var parameterProc = new Dictionary <string, object>();
parameterProc.Add("@id", id);
var response = _database.GetResponse("pr_locate_brand", parameterProc);
if (string.IsNullOrEmpty(response))
{
return(null);
}
return(JsonConvert.DeserializeObject <CatalogBrand>(response));
}
/// <summary>
/// Cria um novo produto
/// </summary>
/// <param name="product"></param>
/// <returns></returns>
public bool CreateProductAsync(CatalogItem product)
{
var parameterProc = new Dictionary <string, object>();
parameterProc.TryAdd("@name", product.Name);
parameterProc.TryAdd("@description", product.Description);
parameterProc.TryAdd("@price", product.Price);
parameterProc.TryAdd("@catalogTypeId", product.CatalogTypeId);
parameterProc.TryAdd("@catalogBrandId", product.CatalogBrandId);
parameterProc.TryAdd("@restockThreshold", product.RestockThreshold);
parameterProc.TryAdd("@maxStockThreshold", product.MaxStockThreshold);
try
{
_database.GetResponse("pr_create_product_ins", parameterProc);
return(true);
}
catch (Exception e)
{
Console.Error.Write($"Erro: {e}");
return(false);
}
}
