public static items_recipes_handler Read(int id)
{
string sql = $"select id, id_craftable, id_crafting_item from items_recipe where id = {id}";
var result = db_handler.instance.query(sql);
var item_recipe = new items_recipes_handler();
if (result.Rows.Count > 0)
{
item_recipe.id = result.Rows[0].Field <int>(0);
item_recipe.id_craftable = result.Rows[0].Field <int>(1);
item_recipe.id_crafting_item = result.Rows[0].Field <int>(2);
item_recipe.item_recipe_dt = result;
}
return(item_recipe);
}
public static List <items_recipes_handler> ReadAllList()
{
string sql = "select * from items_recipe";
var list = new List <items_recipes_handler>();
var item = new items_recipes_handler();
var result = db_handler.instance.query(sql);
foreach (DataRow obj in result.Rows)
{
item = new items_recipes_handler();
item.id = obj.Field <int>(0);
item.id_craftable = obj.Field <int>(1);
item.id_crafting_item = obj.Field <int>(2);
list.Add(item);
}
return(list);
}
