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