public string Load()
{
try {
db.BuisinessUnit();
string sql = "SELECT * FROM BuisinessUnit";
List <NewUnit> xx = new List <NewUnit>();
NewUnit all = new NewUnit();
all.code = null;
all.id = null;
all.title = g.allUnitsTitle;
xx.Add(all);
using (SqlConnection connection = new SqlConnection(g.connectionString)) {
connection.Open();
using (SqlCommand command = new SqlCommand(sql, connection)) {
using (SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
NewUnit x = ReadData(reader);
xx.Add(x);
}
}
}
connection.Close();
}
return(JsonConvert.SerializeObject(xx, Formatting.None));
}catch (Exception e) {
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public string Save(NewUnit x)
{
try {
db.BuisinessUnit();
string sql = string.Format(@"BEGIN TRAN
IF EXISTS (SELECT * from BuisinessUnit WITH (updlock,serializable) WHERE id = '{0}')
BEGIN
UPDATE BuisinessUnit SET code = '{1}', title = '{2}' WHERE id = '{0}'
END
ELSE
BEGIN
INSERT INTO BuisinessUnit (id, code, title)
VALUES ('{0}', '{1}', '{2}')
END
COMMIT TRAN", x.id, x.code, x.title);
using (SqlConnection connection = new SqlConnection(g.connectionString)) {
connection.Open();
using (SqlCommand command = new SqlCommand(sql, connection)) {
command.ExecuteNonQuery();
}
connection.Close();
}
return(JsonConvert.SerializeObject("Spremljeno", Formatting.None));
} catch (Exception e) {
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public NewUnit Get(string code)
{
NewUnit x = new NewUnit();
try {
db.BuisinessUnit();
string sql = string.Format("SELECT * FROM BuisinessUnit WHERE code = '{0}'", code);
using (SqlConnection connection = new SqlConnection(g.connectionString)) {
connection.Open();
using (SqlCommand command = new SqlCommand(sql, connection)) {
using (SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
x = ReadData(reader);
}
}
}
connection.Close();
}
if (string.IsNullOrEmpty(code))
{
x.code = null;
x.id = null;
x.title = g.allUnitsTitle;
}
return(x);
} catch (Exception e) {
return(x);
}
}
public void CommissionedUnitCubicFeetShouldNotExceedIntMaxValue()
{
var unitStoreMock = new UnitStoreMock();
var tenancyStoreMock = new TenancyStoreMock();
var facade = new Facade(unitStoreMock, new CustomerStoreDummy(), tenancyStoreMock, new DateServiceDummy());
facade.CommissionNewUnit(new NewUnit()
{
UnitNumber = "1A",
Length = 10,
Width = 10,
Height = 10,
IsClimateControlled = true,
IsVehicleAccessible = true,
PricePerMonth = 90
});
facade.CommissionNewUnit(new NewUnit()
{
UnitNumber = "2B",
IsClimateControlled = true,
IsVehicleAccessible = true,
PricePerMonth = 90
});
var failUnit1 = new NewUnit()
{
UnitNumber = "3C",
Length = int.MaxValue / 2,
Width = int.MaxValue / 2,
Height = 2,
IsClimateControlled = false,
IsVehicleAccessible = false,
};
Assert.Throws <ArgumentOutOfRangeException>(() => facade.CommissionNewUnit(failUnit1));
var failUnit2 = new NewUnit()
{
UnitNumber = "4B",
Length = 1,
IsClimateControlled = false,
IsVehicleAccessible = false,
};
Assert.Throws <ArgumentException>(() => facade.CommissionNewUnit(failUnit2));
var failUnit3 = new NewUnit()
{
UnitNumber = "4B",
Length = 1,
Width = 5,
Height = 0,
IsClimateControlled = false,
IsVehicleAccessible = false,
};
Assert.Throws <ArgumentException>(() => facade.CommissionNewUnit(failUnit3));
}
public string Init()
{
NewUnit x = new NewUnit();
x.id = Guid.NewGuid().ToString();
x.code = null;
x.title = null;
return(JsonConvert.SerializeObject(x, Formatting.None));
}
NewUnit ReadData(SqlDataReader reader)
{
NewUnit x = new NewUnit();
x.id = reader.GetValue(0) == DBNull.Value ? null : reader.GetString(0);
x.code = reader.GetValue(1) == DBNull.Value ? null : reader.GetString(1);
x.title = reader.GetValue(2) == DBNull.Value ? null : reader.GetString(2);
return(x);
}
public void BuildUnit(int index)
{
//Index wird via Button Event übergeben, welcher eine liste an möglichen baubaren units enthält
if (mg.Resource > building.SpawnUnit[index].cost && GG.Supply < GG.MaxSupply)
{
GameObject NewUnit;
Debug.Log("Building a unit");
NewUnit = (GameObject)Instantiate(building.SpawnUnit[index].original, transform.position, transform.rotation);
NewUnit.GetComponent <NavMeshAgent>().speed = building.SpawnUnit[index].speed;
NewUnit.GetComponent <NavMeshAgent>().acceleration = 1000f;
mg.Resource -= building.SpawnUnit[index].cost;
}
}
public void Create(NewUnitModel newUnit)
{
var unit = new NewUnit()
{
UnitNumber = newUnit.UnitNumber,
Length = newUnit.Length,
Width = newUnit.Width,
Height = newUnit.Height,
IsClimateControlled = newUnit.IsClimateControlled,
IsVehicleAccessible = newUnit.IsVehicleAccessible,
PricePerMonth = newUnit.PricePerMonth
};
facade.CommissionNewUnit(unit);
}
public void Create(NewUnit newUnit) => Units.Add(mapper.Map <NewUnit, Unit>(newUnit));
public void Create(NewUnit newUnit) => throw new NotSupportedException();
