public static void InsertFood_Type(Model.Food_Type food_Type)
{
string query =
"BEGIN " +
"food_type_pkg.insert_food_type('" + food_Type.Type_Name + "', '" + food_Type.Description + "'); " +
"END;";
DB_Handler.ExecuteQuery(query);
}
public static void UpdateFood_Type(Model.Food_Type food_Type)
{
string query =
"BEGIN " +
"food_type_pkg.update_food_type(" + food_Type.Id + ", '" + food_Type.Type_Name + "', '" + food_Type.Description + "'); " +
"END;";
DB_Handler.ExecuteQuery(query);
}
public static Model.Food_Type RowToEntity(DataRow row)
{
Model.Food_Type food_Type = new Model.Food_Type
{
Id = Int32.Parse(row["Id"].ToString()),
Type_Name = row["Type_Name"].ToString(),
Description = row["Description"].ToString()
};
return(food_Type);
}
