public override bool InsertCategoryRecipe(CategoryRecipeModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_ADD_CATEGERYRECIPE", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@NAME", SqlDbType.NVarChar).Value = model.Name;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return (re == 1);
}
}
public override bool UpdateCategoryRecipe(CategoryRecipeModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_UPDATE_CATEGERYRECIPE", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@NAME", SqlDbType.NVarChar).Value = model.Name;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return(re == 1);
}
}
public override CategoryRecipeModel GetByIdCategoryRecipe(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_CATEGORYRECIPE_BY_ID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id;
cn.Open();
IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
CategoryRecipeModel model = new CategoryRecipeModel {
(int)reader["id"],
reader["name"].ToString,
(int)reader["STATUS"]
};
return model;
}
else
return null;
}
}
public override CategoryRecipeModel GetByIdCategoryRecipe(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_CATEGORYRECIPE_BY_ID", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = id;
cn.Open();
IDataReader reader = ExecuteReader(cmd, CommandBehavior.SingleRow);
if (reader.Read())
{
CategoryRecipeModel model = new CategoryRecipeModel {
(int)reader["id"],
reader["name"].ToString,
(int)reader["STATUS"]
};
return(model);
}
else
{
return(null);
}
}
}
public abstract int InsertCategoryRecipe(CategoryRecipeModel model);
