public static void InsertUnit_Type(Model.Unit_Type type)
        {
            string query =
                "BEGIN " +
                "unit_type_pkg.insert_unit_type('" + type.Name + "', '" + type.Symbol + "'); " +
                "END;";

            DB_Handler.ExecuteQuery(query);
        }
        public static void UpdateUnit_Type(Model.Unit_Type type)
        {
            string query =
                "BEGIN " +
                "unit_type_pkg.update_unit_type(" + type.Id + ", '" + type.Name + "', '" + type.Symbol + "'); " +
                "END;";

            DB_Handler.ExecuteQuery(query);
        }
 public static Model.Unit_Type RowToEntity(DataRow row)
 {
     Model.Unit_Type type = new Model.Unit_Type
     {
         Id     = Int32.Parse(row["Id"].ToString()),
         Name   = row["Name"].ToString(),
         Symbol = row["Symbol"].ToString()
     };
     return(type);
 }