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; }
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); }
public static HullVendor Factory() { HullVendor result = new HullVendor( id: -1, name: "", abrv: "", icon: "" ); return(result); }
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); }
/// <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); }
/// <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); }
/// <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); }
/// <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); }