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