public static AssignmentRole Factory()
{
AssignmentRole result = new AssignmentRole(
id: -1,
name: "",
isCompany: false
);
return(result);
}
public static AssignmentRole Factory(SQLiteDataReader reader)
{
AssignmentRole result = new AssignmentRole(
id: Convert.ToInt32(reader["id"]),
name: (string)reader["name"],
isCompany: Convert.ToBoolean(reader["isCompany"])
);
return(result);
}
public static AssignmentRole Factory(int id, string name,
bool isCompany)
{
AssignmentRole result = new AssignmentRole(
id: id,
name: name,
isCompany: isCompany
);
return(result);
}
/// <summary>
/// Gets a role by ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static AssignmentRole FetchById(int id)
{
Datamodel.AssignmentRole ar = null;
if (Datamodel.AssignmentRole.FetchById(ref ar, id))
{
return(new AssignmentRole(ar));
}
else
{
return(null);
}
}
/// <summary>
/// Fetches an assignment role by ID
/// </summary>
/// <param name="output"></param>
/// <param name="id"></param>
/// <returns></returns>
public static bool FetchById(ref AssignmentRole output, int id)
{
SQLiteDataReader reader = DBI.DoPreparedQuery(
@"SELECT * FROM AssignmentRole
WHERE id = @id LIMIT 1;" ,
new Tuple <string, object>("@id", id));
if (reader != null && reader.Read())
{
output = AssignmentRole.Factory(reader);
return(true);
}
return(false);
}
/// <summary>
/// Fetches a role by name
/// </summary>
/// <param name="output"></param>
/// <param name="name"></param>
/// <returns></returns>
public static bool FetchByName(ref AssignmentRole output, string name)
{
SQLiteDataReader reader = DBI.DoPreparedQuery(
@"SELECT * FROM AssignmentRole
WHERE name = @name LIMIT 1;" ,
new Tuple <string, object>("@name", name));
if (reader != null && reader.Read())
{
output = AssignmentRole.Factory(reader);
return(true);
}
return(false);
}
/// <summary>
/// Fetches all possible assignment roles
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public static bool FetchAll(ref List <AssignmentRole> output)
{
output = new List <AssignmentRole>();
SQLiteDataReader reader = DBI.DoQuery(
"SELECT * FROM AssignmentRole;");
while (reader != null && reader.Read())
{
AssignmentRole ar = AssignmentRole.Factory(reader);
output.Add(ar);
}
return(true);
}
/// <summary>
/// Creates a new assignment role
/// </summary>
/// <param name="output"></param>
/// <param name="name"></param>
/// <param name="isCompany"></param>
/// <returns></returns>
public static bool Create(ref AssignmentRole output, string name,
bool isCompany)
{
int result = DBI.DoPreparedAction(
@"INSERT INTO AssignmentRole (name, isCompany)
VALUES (@name, @company);" ,
new Tuple <string, object>("@name", name),
new Tuple <string, object>("@company", isCompany));
if (result == 1)
{
return(AssignmentRole.FetchById(ref output,
DBI.LastInsertRowId));
}
return(false);
}
/// <summary>
/// Updates a role in the table
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public static bool Store(AssignmentRole input)
{
int result = DBI.DoPreparedAction(
@"UPDATE AssignmentRole
SET name = @name, isCompany = @company
WHERE id = @id;" ,
new Tuple <string, object>("@name", input.name),
new Tuple <string, object>("@company", input.isCompany),
new Tuple <string, object>("@id", input.id));
if (result == 1)
{
return(true);
}
return(false);
}
private Assignment(Datamodel.Assignment a)
{
id = a.id;
_userId = a.user;
_shipId = a.ship;
Vessel ship = Vessel.FetchById(_shipId);
if (ship == null)
{
throw new ArgumentException(
"Assignment does not have valid ship ID");
}
shipName = ship.name;
shipHullNumber = ship.fullHullNumber;
_roleId = a.role;
Datamodel.AssignmentRole role = null;
if (!Datamodel.AssignmentRole.FetchById(ref role, _roleId))
{
throw new ArgumentException(
"Assignment does not have valid role ID");
}
roleName = role.name;
roleIsCompany = role.isCompany;
startDate = DateTimeOffset.FromUnixTimeSeconds(a.from).DateTime;
if (a.until != -1)
{
hasEndDate = true;
endDate = DateTimeOffset.FromUnixTimeSeconds(a.until).DateTime;
}
else
{
hasEndDate = false;
}
}
private AssignmentRole(Datamodel.AssignmentRole ar)
{
id = ar.id;
name = ar.name;
isCompany = ar.isCompany;
}