/// <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); } }