public List <Ingridient> GetIngridients()
{
List <Ingridient> ingridientsList = new List <Ingridient>();
_executerIngridientCmd executer = new _executerIngridientCmd(ExecuteIngridientSqlCmd);
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetIngridients", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
ingridientsList = executer(sqlConnection, cmd);
}
}
return(ingridientsList);
}
public Ingridient GetIngridientById(int ingridientId)
{
Ingridient ingridient = new Ingridient();
if (ingridientId > 0)
{
_executerIngridientCmd executer = new _executerIngridientCmd(ExecuteIngridientSqlCmd);
using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("GetIngridientById", sqlConnection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@IngridientId", ingridientId);
ingridient = executer(sqlConnection, cmd).FirstOrDefault();
}
}
}
return(ingridient);
}
