public CustomerAppliance(int applianceId, string alias, int customerId, ApplianceType applianceType)
{
ApplianceId = applianceId;
Alias = alias;
CustomerId = customerId;
ApplianceType = applianceType;
}
public ApplianceInfo(ApplianceType type, Vector2 gridPosition, List <Modifier> modifiers, ApplianceData data)
{
ApplianceType = type;
GridPosition = gridPosition;
Modifiers = modifiers;
Data = data;
}
public Appliance(ApplianceType type, string n, int c, int kwh)
{
applianceType = type;
name = n;
cost = c;
kwhPerMonth = kwh;
}
public Appliance(ApplianceType type, ITime clock, Rating rating, bool isApplianceOn = ApplianceState.Off)
{
On = isApplianceOn;
_id = Guid.NewGuid().ToString();
_type = type;
_rating = rating;
clock.Ticked += UpdateUsage;
}
private void createAppliance(InfoPanel infoPanel, ApplianceType type, GameObject appliancePrefab, ApplianceSpriteDictionary spriteOfAppliance)
{
GameObject applianceGO = MonoBehaviour.Instantiate(appliancePrefab) as GameObject;
applianceGO.transform.GetChild(0).GetComponent <Image>().sprite = spriteOfAppliance[type];
applianceGO.transform.SetParent(infoPanel.applianceParent.transform);
applianceGO.GetComponent <RectTransform>().localScale = Vector3.one;
applianceGO.GetComponent <RectTransform>().offsetMin = Vector2.zero;
applianceGO.GetComponent <RectTransform>().offsetMax = Vector2.zero;
applianceGO.transform.localPosition = new Vector3(applianceGO.transform.localPosition.x, applianceGO.transform.localPosition.y, 0);
}
public Appliance(
ApplianceType Type,
string FullName,
string Phrase,
TimeSpan Time)
{
this.Name = "TimerTile" + Guid.NewGuid().ToString().Replace("-", "");
this.FullName = FullName;
this.Phrase = Phrase;
this.mtsTime = Time;
this.Type = Type;
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
ApplianceType applianceType = await db.ApplianceTypes.FindAsync(id);
string comment = $"Id: {applianceType.Id} NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeDelete", comment, null, false);
db.ApplianceTypes.Remove(applianceType);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public Appliance(int id, string name)
{
this.id = id;
this.Name = name;
if (Enum.IsDefined(typeof(ApplianceType), this.Name))
{
applianceType = (ApplianceType)Enum.Parse(typeof(ApplianceType), this.Name);
}
else
{
applianceType = (ApplianceType)Enum.Parse(typeof(ApplianceType), "Other");
}
}
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ApplianceType applianceType = await db.ApplianceTypes.FindAsync(id);
if (applianceType == null)
{
return(HttpNotFound());
}
return(View(applianceType));
}
/// <summary>
/// Sets the appliance type associated with this appliance.
/// </summary>
/// <param name="callSign">The callsign to change</param>
/// <param name="type">The new appliance type</param>
/// <returns>True if the change was successful, otherwise false.</returns>
/// <remarks>
/// Appliance types determine what incidents an appliance is mobilised to -
/// if an incident requires 2 appliances of type 'Aerial', then this property is checked for all resources.
/// If it contains a type called 'Aerial' then the appliance is considered for mobilisation.
/// </remarks>
public bool SetType(string callSign, ApplianceType type)
{
//build the SQL command
string statement = "UPDATE Appliance " +
"SET ApplianceTypeName = @type " +
"WHERE CallSign = @callsign;";
MySqlCommand command = new MySqlCommand(statement, connection);
command.Parameters.AddWithValue("@callsign", callSign);
command.Parameters.AddWithValue("@type", type);
return(executeNonQuery(command));
}
public async Task <ActionResult> Create([Bind(Include = "Id,NameEN,NameKZ,NameRU")] ApplianceType applianceType)
{
if (ModelState.IsValid)
{
db.ApplianceTypes.Add(applianceType);
await db.SaveChangesAsync();
string comment = $"Id: {applianceType.Id} NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeCreate", comment, null, false);
return(RedirectToAction("Index"));
}
return(View(applianceType));
}
public static GameObject GetAppliance(ApplianceType type)
{
switch (type)
{
case ApplianceType.PowerSwitch:
return(GetPowerSwitch());
case ApplianceType.Target:
return(GetTarget());
default:
Debug.LogError("Appliance type not found: " + type);
return(null);
}
}
private void Reset(ApplianceType applianceType)
{
switch (applianceType)
{
case ApplianceType.HeatPump:
_applianceManager = new HeatPumpManager();
break;
case ApplianceType.FanCoilUnit:
_applianceManager = new FanCoilUnitManager();
break;
default:
throw new InvalidOperationException("Appliance manager type not recognised");
}
}
public void AddAppliance(int applianceCount, ApplianceType type)
{
int count = appliances.Count;
for (int i = 0; i < applianceCount; i++)
{
Appliance appliance = type switch
{
ApplianceType.FAN => new Fan(++count),
ApplianceType.AC => new AC(++count),
ApplianceType.BULB => new Bulb(++count),
_ => null,
};
appliances.Add(appliance);
SwitchBoard.AddSwitch(appliance.Id);
}
}
public Switch(ApplianceType type)
{
switch (type)
{
case ApplianceType.Fan:
appliance = new Fan(random.Next());
break;
case ApplianceType.Light:
appliance = new Light(random.Next());
break;
case ApplianceType.AC:
appliance = new AC(random.Next());
break;
default:
break;
}
InitializeLogs();
}
public async Task <ActionResult> Edit([Bind(Include = "Id,NameEN,NameKZ,NameRU")] ApplianceType applianceType)
{
if (ModelState.IsValid)
{
ApplianceType at = null;
using (var dblocal = new NpgsqlContext())
{
at = dblocal.ApplianceTypes.Where(a => a.Id == applianceType.Id).FirstOrDefault();
dblocal.Dispose();
GC.Collect();
}
string comment = $"Id: {at.Id} NameEN: {at.NameEN} NameKZ: {at.NameKZ} NameRU: {at.NameRU}";
comment += $" -> NameEN: {applianceType.NameEN} NameKZ: {applianceType.NameKZ} NameRU: {applianceType.NameRU}";
SystemLog.New("ApplianceTypeEdit", comment, null, false);
db.Entry(applianceType).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(applianceType));
}
public async Task GetAppliances_ValidRequest_Succeeds()
{
using (var context = _factory.GetKIOTContext())
{
var type = context.ApplianceTypes.SingleOrDefault(x => x.ApplianceTypeId == 1);
if (type == null)
{
type = new ApplianceType(1, "TestAppliance");
context.ApplianceTypes.Add(type);
context.SaveChanges();
}
context.CustomerAppliances.Add(new CustomerAppliance(20501, "TestAlias", -1, type));
context.SaveChanges();
}
(await _client.AuthenticateUserAsync("mwilson", "password")).AddAuthorization(_httpClient);
CustomerAppliancesDto response = null;
Assert.Null(await Record.ExceptionAsync(async() => response = await _client.Customer_GetAppliancesAsync()));
Assert.NotNull(response);
Assert.NotEmpty(response.Appliances);
Assert.Contains(response.Appliances, x => x.ApplianceId == 20501 && x.ApplianceName == "TestAlias");
}
public Appliance(ApplianceType type)
{
this.Type = type;
}
internal void SetApplianceType(ApplianceType applianceType)
{
this.applianceType = applianceType;
}
public RatedAppliance(ApplianceType applianceType, Rating rating)
{
ApplianceType = applianceType;
Rating = rating;
}
/// <summary>
/// Retrieves a resource using its unique call sign
/// </summary>
/// <param name="callSign">The call sign to retrieve</param>
/// <returns>An object representing the resource.
/// Note that this is the abstract base class and the returned object should be cast to an Appliance or Officer object.</returns>
public Appliance GetAppliance(string callSign)
{
string statement = "SELECT * FROM resource, appliance, address_resource, address, resource_status, status, ApplianceType, Base" + Environment.NewLine +
"INNER JOIN address AS base_address ON base.Id = base_address.Id" + Environment.NewLine +
"WHERE resource.CallSign = appliance.CallSign" + Environment.NewLine +
"AND resource.CallSign = address_resource.ResourceCallSign" + Environment.NewLine +
"AND address_resource.DateTime = ((SELECT MAX(Address_Resource.DateTime) FROM Address_Resource WHERE Address_Resource.ResourceCallSign = resource.CallSign))" + Environment.NewLine +
"AND address_resource.AddressId = address.Id" + Environment.NewLine +
"AND resource.CallSign = resource_status.ResourceCallSign" + Environment.NewLine +
"AND resource_status.StatusCode = status.Code" + Environment.NewLine +
"AND resource_status.DateTime = (SELECT MAX(resource_status.DateTime) FROM resource_status WHERE resource_status.ResourceCallSign = resource.CallSign)" + Environment.NewLine +
"AND appliance.ApplianceTypeName = ApplianceType.Name" + Environment.NewLine +
"AND resource.BaseLocationId = base.Id" + Environment.NewLine +
"AND resource.CallSign = @callsign;";
MySqlCommand command = new MySqlCommand(statement, connection);
command.Parameters.AddWithValue("@callsign", callSign);
//execute the query
MySqlDataReader myReader = null;
try
{
// open the connection only if it is currently closed
if (command.Connection.State == System.Data.ConnectionState.Closed)
{
command.Connection.Open();
}
//close the reader if it currently exists
if (myReader != null && !myReader.IsClosed)
{
myReader.Close();
}
myReader = command.ExecuteReader();
//read the data sent back from MySQL server
while (myReader.Read())
{
string name = myReader.GetString(2);
string mobile = string.Empty;
if (!myReader.IsDBNull(3))
{
mobile = myReader.GetString(3);
}
int attachedIncident = -1;
if (!myReader.IsDBNull(4))
{
attachedIncident = myReader.GetInt32(4);
}
string oic = string.Empty;
if (!myReader.IsDBNull(7))
{
oic = myReader.GetString(7);
}
int crew = -1;
if (!myReader.IsDBNull(8))
{
crew = myReader.GetInt32(8);
}
int ba = -1;
if (!myReader.IsDBNull(9))
{
ba = myReader.GetInt32(9);
}
#region Address Data
int addressId = -1;
if (!myReader.IsDBNull(14))
{
addressId = myReader.GetInt32(14);
}
string building = string.Empty;
if (!myReader.IsDBNull(15))
{
building = myReader.GetString(15);
}
string number = string.Empty;
if (!myReader.IsDBNull(16))
{
number = myReader.GetString(16);
}
string street = string.Empty;
if (!myReader.IsDBNull(17))
{
street = myReader.GetString(17);
}
string town = string.Empty;
if (!myReader.IsDBNull(18))
{
town = myReader.GetString(18);
}
string postcode = string.Empty;
if (!myReader.IsDBNull(19))
{
postcode = myReader.GetString(19);
}
string county = string.Empty;
if (!myReader.IsDBNull(20))
{
county = myReader.GetString(20);
}
double latitude = myReader.GetDouble(21);
double longitude = myReader.GetDouble(22);
Address address = new Address(addressId, building, number, street, town, postcode, county, longitude, latitude);
#endregion
#region Status Data
int code = -1;
if (!myReader.IsDBNull(27))
{
code = myReader.GetInt32(27);
}
string codeDescription = string.Empty;
if (!myReader.IsDBNull(28))
{
codeDescription = myReader.GetString(28);
}
bool isAvail = false;
if (!myReader.IsDBNull(29))
{
isAvail = myReader.GetBoolean(29);
}
bool isMob = false;
if (!myReader.IsDBNull(30))
{
isMob = myReader.GetBoolean(30);
}
ResourceLogTime log = ResourceLogTime.Ignore;
if (!myReader.IsDBNull(31))
{
log = (ResourceLogTime)myReader.GetInt32(31);
}
ResourceStatus status = new ResourceStatus(code, codeDescription, isAvail, isMob, log);
#endregion
#region Appliance Type Data
string typeName = string.Empty;
if (!myReader.IsDBNull(32))
{
typeName = myReader.GetString(32);
}
string typeDescription = string.Empty;
if (!myReader.IsDBNull(33))
{
typeDescription = myReader.GetString(33);
}
ApplianceType type = new ApplianceType(typeName, typeDescription);
#endregion
#region Base Data
int baseId = -1;
if (!myReader.IsDBNull(34))
{
baseId = myReader.GetInt32(34);
}
int baseAddressId = -1;
if (!myReader.IsDBNull(35))
{
baseAddressId = myReader.GetInt32(35);
}
string office = string.Empty;
if (!myReader.IsDBNull(36))
{
office = myReader.GetString(36);
}
string baseName = string.Empty;
if (!myReader.IsDBNull(37))
{
name = myReader.GetString(37);
}
string baseBuilding = string.Empty;
if (!myReader.IsDBNull(39))
{
building = myReader.GetString(39);
}
string baseNumber = string.Empty;
if (!myReader.IsDBNull(40))
{
number = myReader.GetString(40);
}
string baseStreet = string.Empty;
if (!myReader.IsDBNull(41))
{
street = myReader.GetString(41);
}
string baseTown = string.Empty;
if (!myReader.IsDBNull(42))
{
town = myReader.GetString(42);
}
string basePostcode = string.Empty;
if (!myReader.IsDBNull(43))
{
postcode = myReader.GetString(43);
}
string baseCounty = string.Empty;
if (!myReader.IsDBNull(44))
{
county = myReader.GetString(44);
}
double baseLatitude = myReader.GetDouble(45);
double baseLongitude = myReader.GetDouble(46);
Address baseAddress = new Address(baseId, baseBuilding, baseNumber, baseStreet, baseTown, basePostcode, baseCounty, baseLongitude, baseLatitude);
Base baseLocation = new Base(baseId, office, baseAddress, baseName);
#endregion
ApplianceInfo info = new ApplianceInfo(name, mobile, baseLocation, address, status, oic, crew, ba, type, attachedIncident);
return(new Appliance(callSign, info));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
if (myReader != null)
{
myReader.Close();
}
command.Connection.Close();
}
return(null);
}
public ApplianceItem(string description, int sku, decimal price, ApplianceType applianceType) : base(description, sku, price)
{
ApplianceType = applianceType;
}
public Appliance MakeAppliance(ApplianceType applianceType)
{
return(All.Single(appliance => appliance.ApplianceType == applianceType));
}
/// <summary>
/// Retrieves all appliance information from the database.
/// </summary>
/// <param name="callSign">The unique appliance call sign to retrieve the information for.</param>
/// <returns>An container class that stores all the information</returns>
public ApplianceInfo GetApplianceInfo(string callSign)
{
string statement = "SELECT resource.Name, resource.MobilePhoneNumber, " + Environment.NewLine +
"base.id, base.name, base.OfficePhoneNumber," + Environment.NewLine +
"base_address.id, base_address.building, base_address.number, base_address.street, base_address.town, base_address.postcode, base_address.county, base_address.longitude, base_address.latitude," + Environment.NewLine +
"current_address.id, current_address.building, current_address.number, current_address.street, current_address.town, current_address.postcode, current_address.county, current_address.longitude, current_address.latitude," + Environment.NewLine +
"status.code, status.Description, status.IsAvailable, status.IsMobile, status.ResourceLogEnumeration, resource_status.DateTime, resource_status.OperatorId," + Environment.NewLine +
"appliance.OfficerInCharge, appliance.CrewNumber, appliance.BaNumber," + Environment.NewLine +
"appliancetype.Name, appliancetype.Description, resource.AttachedIncidentNumber" + Environment.NewLine +
"FROM resource" + Environment.NewLine +
"INNER JOIN base ON resource.BaseLocationId = base.Id" + Environment.NewLine +
"INNER JOIN address AS base_address ON base.AddressId = base_address.Id" + Environment.NewLine +
"INNER JOIN Address_Resource ON Address_Resource.ResourceCallSign = resource.CallSign" + Environment.NewLine +
"INNER JOIN address AS current_address ON address_resource.AddressId = current_address.Id" + Environment.NewLine +
"INNER JOIN resource_status ON resource_status.ResourceCallSign = resource.CallSign" + Environment.NewLine +
"INNER JOIN status ON resource_status.StatusCode = status.Code" + Environment.NewLine +
"INNER JOIN appliance ON resource.CallSign = appliance.CallSign" + Environment.NewLine +
"INNER JOIN appliancetype ON appliance.ApplianceTypeName = appliancetype.Name" + Environment.NewLine +
"WHERE Address_Resource.DateTime = (SELECT MAX(DateTime) FROM Address_Resource WHERE ResourceCallSign = resource.CallSign)" + Environment.NewLine +
"AND resource_status.DateTime = (SELECT MAX(DateTime) FROM resource_status WHERE ResourceCallSign = resource.CallSign)" + Environment.NewLine +
"AND resource.CallSign = @callsign;";
//object that will execute the query
MySqlCommand command = new MySqlCommand(statement, connection);
command.Parameters.AddWithValue("@callsign", callSign);
//execute
MySqlDataReader myReader = null; //reads the database data
try
{
// open the connection only if it is currently closed
if (command.Connection.State == System.Data.ConnectionState.Closed)
{
command.Connection.Open();
}
//close the reader if it currently exists
if (myReader != null && !myReader.IsClosed)
{
myReader.Close();
}
myReader = command.ExecuteReader(); //execute the select statement
//read the data sent back from MySQL server and create the Appliance objects
while (myReader.Read())
{
//read all the data returned from the database - each information area is split into a different region below
string resourceName = myReader.GetString(0);
string mobileNo = myReader.GetString(1);
#region Base Address Data
int baseId = myReader.GetInt32(2);
string baseName = myReader.GetString(3);
string officeNo = myReader.GetString(4);
int baseAddressId = myReader.GetInt32(5);
string baseBuilding = string.Empty;
if (!myReader.IsDBNull(6))
{
baseBuilding = myReader.GetString(6);
}
string baseNumber = string.Empty;
if (!myReader.IsDBNull(7))
{
baseNumber = myReader.GetString(7);
}
string baseStreet = string.Empty;
if (!myReader.IsDBNull(8))
{
baseStreet = myReader.GetString(8);
}
string baseTown = string.Empty;
if (!myReader.IsDBNull(9))
{
baseTown = myReader.GetString(9);
}
string basePostcode = string.Empty;
if (!myReader.IsDBNull(10))
{
basePostcode = myReader.GetString(10);
}
string baseCounty = string.Empty;
if (!myReader.IsDBNull(11))
{
baseCounty = myReader.GetString(11);
}
double baseLong = myReader.GetDouble(12);
double baseLat = myReader.GetDouble(13);
Address baseAddress = new Address(baseAddressId, baseBuilding, baseNumber, baseStreet, baseTown, basePostcode, baseCounty, baseLong, baseLat);
Base baseLocation = new Base(baseId, officeNo, baseAddress, baseName);
#endregion
#region Current Address Data
int currentId = myReader.GetInt32(14);
string currentBuilding = string.Empty;
if (!myReader.IsDBNull(15))
{
currentBuilding = myReader.GetString(15);
}
string currentNumber = string.Empty;
if (!myReader.IsDBNull(16))
{
currentNumber = myReader.GetString(16);
}
string currentStreet = string.Empty;
if (!myReader.IsDBNull(17))
{
currentStreet = myReader.GetString(17);
}
string currentTown = string.Empty;
if (!myReader.IsDBNull(18))
{
currentTown = myReader.GetString(18);
}
string currentPostcode = string.Empty;
if (!myReader.IsDBNull(19))
{
currentPostcode = myReader.GetString(19);
}
string currentCounty = string.Empty;
if (!myReader.IsDBNull(20))
{
currentCounty = myReader.GetString(20);
}
double currentLong = myReader.GetDouble(21);
double currentLat = myReader.GetDouble(22);
Address currentAddress = new Address(currentId, currentBuilding, currentNumber, currentStreet, currentTown, currentPostcode, currentCounty, currentLong, currentLat);
#endregion
#region Status Code Data
int statusCode = -1;
if (!myReader.IsDBNull(23))
{
statusCode = myReader.GetInt32(23);
}
string statusDescription = string.Empty;
if (!myReader.IsDBNull(24))
{
statusDescription = myReader.GetString(24);
}
bool isAvail = false;
if (!myReader.IsDBNull(25))
{
isAvail = myReader.GetBoolean(25);
}
bool isMobile = false;
if (!myReader.IsDBNull(26))
{
isMobile = myReader.GetBoolean(26);
}
int resourceLogEnumeration = -1;
if (!myReader.IsDBNull(27))
{
resourceLogEnumeration = myReader.GetInt32(27);
}
ResourceLogTime incidentLogAction = ResourceLogTime.Ignore;
if (Enum.IsDefined(typeof(ResourceLogTime), resourceLogEnumeration))
{
incidentLogAction = (ResourceLogTime)resourceLogEnumeration;
}
ResourceStatus status = new ResourceStatus(statusCode, statusDescription, isAvail, isMobile, incidentLogAction);
#endregion
#region Appliance Data
string oic = string.Empty;
if (!myReader.IsDBNull(30))
{
oic = myReader.GetString(30);
}
int crew = -1;
if (!myReader.IsDBNull(31))
{
crew = myReader.GetInt32(31);
}
int ba = -1;
if (!myReader.IsDBNull(32))
{
ba = myReader.GetInt32(32);
}
string applianceTypeName = string.Empty;
if (!myReader.IsDBNull(33))
{
applianceTypeName = myReader.GetString(33);
}
string applianceTypeDescription = string.Empty;
if (!myReader.IsDBNull(34))
{
applianceTypeDescription = myReader.GetString(34);
}
int assignedIncident = -1;
if (!myReader.IsDBNull(35))
{
assignedIncident = myReader.GetInt32(35);
}
ApplianceType type = new ApplianceType(applianceTypeName, applianceTypeDescription);
#endregion
return(new ApplianceInfo(resourceName, mobileNo, baseLocation, currentAddress, status, oic, crew, ba, type, assignedIncident));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
MessageBox.Show(statement);
}
finally
{
//close the connections
if (myReader != null)
{
myReader.Close();
}
command.Connection.Close();
}
return(null);
}
public ApplianceManagerBuilder(ApplianceType applianceType)
{
Reset(applianceType);
}
