Beispiel #1
0
        private Hull(Datamodel.Hull h)
        {
            id       = h.id;
            name     = h.series;
            symbol   = h.symbol;
            ordering = h.ordering;

            _roleId = h.role;
            Datamodel.HullRole hr = null;
            if (!Datamodel.HullRole.FetchById(ref hr, _roleId))
            {
                throw new ArgumentException(
                          "Hull does not have valid role ID");
            }
            role = hr.name;

            _vendorId = h.vendor;
            Datamodel.HullVendor hv = null;
            if (!Datamodel.HullVendor.FetchById(ref hv, _vendorId))
            {
                throw new ArgumentException(
                          "Hull does not have valid vendor ID");
            }
            vendor = hv.name;
        }
Beispiel #2
0
        public static HullVendor Factory(SQLiteDataReader reader)
        {
            HullVendor result = new HullVendor(
                id: Convert.ToInt32(reader["id"]),
                name: (string)reader["name"],
                abrv: (string)reader["abrv"],
                icon: (string)reader["icon"]
                );

            return(result);
        }
Beispiel #3
0
        public static HullVendor Factory()
        {
            HullVendor result = new HullVendor(
                id: -1,
                name: "",
                abrv: "",
                icon: ""
                );

            return(result);
        }
Beispiel #4
0
        public static HullVendor Factory(int id, string name, string abrv,
                                         string icon)
        {
            HullVendor result = new HullVendor(
                id: id,
                name: name,
                abrv: abrv,
                icon: icon
                );

            return(result);
        }
Beispiel #5
0
        /// <summary>
        /// Gets a vendor by ID
        /// </summary>
        /// <param name="output"></param>
        /// <param name="id"></param>
        /// <returns></returns>
        public static bool FetchById(ref HullVendor output, int id)
        {
            SQLiteDataReader reader = DBI.DoPreparedQuery(
                @"SELECT * FROM HullVendor 
				WHERE id = @id LIMIT 1;"                ,
                new Tuple <string, object>("@id", id));

            if (reader != null && reader.Read())
            {
                output = HullVendor.Factory(reader);
                return(true);
            }
            return(false);
        }
Beispiel #6
0
        /// <summary>
        /// Gets a vendor by name
        /// </summary>
        /// <param name="output"></param>
        /// <param name="name"></param>
        /// <returns></returns>
        public static bool FetchByName(ref HullVendor output, string name)
        {
            SQLiteDataReader reader = DBI.DoPreparedQuery(
                @"SELECT * FROM HullVendor 
				WHERE name = @name LIMIT 1;"                ,
                new Tuple <string, object>("@name", name));

            if (reader != null && reader.Read())
            {
                output = HullVendor.Factory(reader);
                return(true);
            }
            return(false);
        }
Beispiel #7
0
        /// <summary>
        /// Creates a new Hull Vendor
        /// </summary>
        /// <param name="output"></param>
        /// <param name="name"></param>
        /// <param name="abrv"></param>
        /// <param name="icon"></param>
        /// <returns></returns>
        public static bool Create(ref HullVendor output, string name,
                                  string abrv, string icon = "")
        {
            int result = DBI.DoPreparedAction(
                @"INSERT INTO HullVendor (name, abrv, icon) 
				VALUES (@name, @abrv, @icon);"                ,
                new Tuple <string, object>("@name", name),
                new Tuple <string, object>("@abrv", abrv),
                new Tuple <string, object>("@icon", icon));

            if (result == 1)
            {
                return(HullVendor.FetchById(ref output, DBI.LastInsertRowId));
            }
            return(false);
        }
Beispiel #8
0
        /// <summary>
        /// Updates a vendor
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public static bool Store(HullVendor input)
        {
            int result = DBI.DoPreparedAction(
                @"UPDATE HullVendor 
				SET name = @name, abrv = @abrv, icon = @icon
				WHERE id = @id;"                ,
                new Tuple <string, object>("@name", input.name),
                new Tuple <string, object>("@abrv", input.abrv),
                new Tuple <string, object>("@icon", input.icon),
                new Tuple <string, object>("@id", input.id));

            if (result == 1)
            {
                return(true);
            }
            return(false);
        }