public async Task <Ingredient_Supplier> GetById(string supplier, string ing_name)
{
using (NpgsqlConnection sql = new NpgsqlConnection(_connectionString))
{
using (NpgsqlCommand cmd = new NpgsqlCommand("\"spIngredient_Supplier_GetById\"", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new NpgsqlParameter("supplier", NpgsqlDbType.Varchar));
cmd.Parameters.Add(new NpgsqlParameter("ing_name", NpgsqlDbType.Varchar));
cmd.Parameters[0].Value = supplier;
cmd.Parameters[1].Value = ing_name;
Ingredient_Supplier response = null;
await sql.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
while (await reader.ReadAsync())
{
response = MapToValue(reader);
}
}
return(response);
}
}
}
public async Task Insert(Ingredient_Supplier ing_sup)
{
using (NpgsqlConnection sql = new NpgsqlConnection(_connectionString))
{
using (NpgsqlCommand cmd = new NpgsqlCommand("\"spIngredient_Supplier_InsertValue\"", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new NpgsqlParameter("supplier", NpgsqlDbType.Varchar));
cmd.Parameters.Add(new NpgsqlParameter("ing_name", NpgsqlDbType.Varchar));
cmd.Parameters[0].Value = ing_sup.Supplier;
cmd.Parameters[1].Value = ing_sup.Ing_Name;
await sql.OpenAsync();
await cmd.ExecuteNonQueryAsync();
return;
}
}
}
public async Task <ActionResult> Post([FromBody] Ingredient_Supplier ing_sup)
{
ing_sup.Ing_Name = textInfo.ToTitleCase(ing_sup.Ing_Name.ToLower());
try
{
// Inserting record in the Ingredient_Supplier table
await _repository.Insert(ing_sup);
return(Ok("Ingredient_Supplier record inserted successfully\n"));
}
catch (Npgsql.PostgresException ex)
{
// Postgres threw an exception
return(BadRequest(ex.Message.ToString()));
}
catch
{
// Unknown error
return(BadRequest("Error: Ingredient_Supplier record was not inserted\n"));
}
}
