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