public override ListRecipeModel GetByIdListRecipe(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_LISTRECIPE_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())
{
ListRecipeModel model = new ListRecipeModel {
(int)reader["id"],
(int)reader["IdCate"],
reader["Title"].ToString,
reader["Image"].ToString,
reader["Description"].ToString,
reader["Detail"].ToString,
(float)reader["Price"],
(float)reader["Discount"],
(int)reader["STATUS"]
};
}
else
{
return(null);
}
}
}
public override ListRecipeModel GetByIdListRecipe(int id)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_GET_LISTRECIPE_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())
{
ListRecipeModel model = new ListRecipeModel {
(int)reader["id"],
(int)reader["IdCate"],
reader["Title"].ToString,
reader["Image"].ToString,
reader["Description"].ToString,
reader["Detail"].ToString,
(float)reader["Price"],
(float)reader["Discount"],
(int)reader["STATUS"]
};
}
else
return null;
}
}
public override bool InsertListRecipe(ListRecipeModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_ADD_LISTRECIPE", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@Id_Cate", SqlDbType.Int).Value = model.IdCate;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = model.Title;
cmd.Parameters.Add("@Image", SqlDbType.NVarChar).Value = model.Image;
cmd.Parameters.Add("@Descriotion", SqlDbType.NVarChar).Value = model.Description;
cmd.Parameters.Add("@Detail", SqlDbType.NVarChar).Value = model.Detail;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = model.Price;
cmd.Parameters.Add("@Discount", SqlDbType.Float).Value = model.Discount;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return(re == 1);
}
}
public override bool InsertListRecipe(ListRecipeModel model)
{
using (SqlConnection cn = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("proc_ADD_LISTRECIPE", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = model.Id;
cmd.Parameters.Add("@Id_Cate", SqlDbType.Int).Value = model.IdCate;
cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = model.Title;
cmd.Parameters.Add("@Image", SqlDbType.NVarChar).Value = model.Image;
cmd.Parameters.Add("@Descriotion", SqlDbType.NVarChar).Value = model.Description;
cmd.Parameters.Add("@Detail", SqlDbType.NVarChar).Value = model.Detail;
cmd.Parameters.Add("@Price", SqlDbType.Float).Value = model.Price;
cmd.Parameters.Add("@Discount", SqlDbType.Float).Value = model.Discount;
cmd.Parameters.Add("@STATUS", SqlDbType.Int).Value = model.Status;
cn.Open();
int re = ExecuteNonQuery(cmd);
return (re == 1);
}
}
public abstract int InsertListRecipe(ListRecipeModel model);
public abstract int InsertListRecipe(ListRecipeModel model);
