/// <summary>
/// Метод редагує та зберігає Book, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="bookSelect"></param>
public void EditBook(ref AssistantContext db, ref Book bookSelect)
{
if (bookSelect == null)
{
return;
}
Book book = bookSelect as Book;
MessageView message = new MessageView(book.NameBook);
if (message.ShowDialog() == true)
{
book.NameBook = message.Message;
db.Entry(book).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Метод редагує та зберігає Section, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="sectionSelect"></param>
public void EditSection(ref AssistantContext db, ref Section sectionSelect)
{
if (sectionSelect == null)
{
return;
}
Section section = sectionSelect as Section;
MessageView message = new MessageView(section.NameSection);
if (message.ShowDialog() == true)
{
section.NameSection = message.Message;
db.Entry(section).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Метод редагує та зберігає Topic, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="topicSelect"></param>
public void EditTopic(ref AssistantContext db, ref Topic topicSelect)
{
if (topicSelect == null)
{
return;
}
Topic topic = topicSelect as Topic;
MessageView message = new MessageView(topic.NameTopic);
if (message.ShowDialog() == true)
{
topic.NameTopic = message.Message;
db.Entry(topic).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Метод видаляє виділену Book та всіх хто на неї зсилається, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="bookSelect"></param>
public void DelBook(ref AssistantContext db, ref Book bookSelect)
{
if (bookSelect == null)
{
return;
}
Book b = bookSelect as Book;
var examples = db.Examples.Where(e => e.Section.Topic.BookId == b.Id);
var sections = db.Sections.Where(s => s.Topic.BookId == b.Id);
var topics = db.Topics.Where(t => t.BookId == b.Id);
db.Examples.RemoveRange(examples);
db.Sections.RemoveRange(sections);
db.Topics.RemoveRange(topics);
db.Books.Remove(b);
db.SaveChanges();
}
/// <summary>
/// Метод створює нову Topic та підвязує її до виділеної Book, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="bookSelect"></param>
public void AddTopic(ref AssistantContext db, ref Book bookSelect)
{
if (bookSelect == null)
{
return;
}
Book book = bookSelect as Book;
MessageView message = new MessageView("");
if (message.ShowDialog() == true)
{
Topic topic = new Topic();
topic.NameTopic = message.Message;
topic.Book = book;
db.Topics.Add(topic);
db.SaveChanges();
}
}
/// <summary>
/// Add a business process to the database
/// </summary>
/// <param name="businessProcess">The business process to add</param>
public void Add(BusinessProcess businessProcess)
{
try
{
_logger.LogInformation($"Add a business process ({businessProcess.Source} - {businessProcess.Process} - {businessProcess.Destination}) to the database");
_context.BusinessProcessDbSet.Add(businessProcess);
_context.SaveChanges();
}
catch (Exception ex)
{
_logger.LogError($"Could not add business process ({businessProcess.Source} - {businessProcess.Process} - {businessProcess.Destination}) to database", ex);
}
}
public void LoadExistingPackagedSolutionTest()
{
new AssistantContext().Database.Delete();
ctx = new AssistantContext();
PackagedSolution pack = new PackagedSolution()
{
CreationDate = DateTime.Now
};
pack.ApplianceInstances.Add(new ApplianceInstance()
{
Appliance = app1
});
pack.ApplianceInstances.Add(new ApplianceInstance()
{
Appliance = app2
});
ctx.PackagedSolutions.Add(pack);
ctx.SaveChanges();
model.LoadExistingPackagedSolution(pack.Id);
Assert.IsTrue((model.AppliancesInPackagedSolutionView.Cast <object>().Count() == 2));
}
/// <summary>
/// Метод створює нову Section та підвязує її до виділеної Topic, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
/// <param name="topicSelect"></param>
public void AddSection(ref AssistantContext db, ref Topic topicSelect)
{
if (topicSelect == null)
{
return;
}
Topic topic = topicSelect as Topic;
MessageView message = new MessageView("");
if (message.ShowDialog() == true)
{
Section section = new Section();
Example example = new Example();
section.NameSection = message.Message;
section.Topic = topic;
example.Notes = "";
example.Section = section;
db.Sections.Add(section);
db.Examples.Add(example);
db.SaveChanges();
}
}
public CompanyInfoDialogViewModel(Action <CompanyInfoDialogViewModel> closeHandler, Action <CompanyInfoDialogViewModel> completionHandler)
{
LoadDataFromDatabase();
PropertyChanged += OnInputReceived;
OnPropertyChanged(); //Make save button clickable if information is already there
SaveCommand = new RelayCommand(x =>
{
completionHandler(this);
// Save changes to database
using (var ctx = new AssistantContext())
{
ctx.Entry(CompanyInformation).State = EntityState.Modified;
ctx.CompanyInformation.AddOrUpdate(CompanyInformation);
ctx.SaveChanges();
}
}, x => hasRequiredInformation);
CloseCommand = new RelayCommand(x =>
{
closeHandler(this);
});
}
private void TestSeed()
{
using (var ctx = new AssistantContext())
{
if (ctx.Appliances.Any())
{
return;
}
ctx.Appliances.Add(new Appliance("Cerapur", new HeatingUnitDataSheet()
{
WattUsage = 20, AFUE = 93, AFUEColdClima = 98.2f, AFUEWarmClima = 87.8f
}, ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("LoganoPlusSB105", new HeatingUnitDataSheet()
{
AFUE = 91, WattUsage = 18, AFUEColdClima = 99.2f, AFUEWarmClima = 92.5f
},
ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("EuroPurACUWater", new HeatingUnitDataSheet()
{
AFUE = 91,
WattUsage = 18,
AFUEColdClima = 96.5f,
AFUEWarmClima = 87.7f,
WaterHeatingEffiency = 82,
UseProfile = UseProfileType.XL,
Vbu = 0
},
ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Condens9000Water", new HeatingUnitDataSheet()
{
AFUE = 94,
WattUsage = 29,
AFUEColdClima = 98.7f,
AFUEWarmClima = 88.5f,
WaterHeatingEffiency = 82,
UseProfile = UseProfileType.XL,
Vbu = 1
},
ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("EuroPurUnitSolar", new HeatingUnitDataSheet()
{
AFUE = 92,
WattUsage = 13,
AFUEColdClima = 98.1f,
AFUEWarmClima = 87.8f,
WaterHeatingEffiency = 85,
UseProfile = UseProfileType.XL,
Vbu = 34,
StandingLoss = 92.5f
,
Vnorm = 204,
Psb = 4
}, ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Condens5000", new HeatingUnitDataSheet()
{
UseProfile = UseProfileType.XXL,
WattUsage = 24,
Vbu = 110,
Psb = 2,
WaterHeatingEffiency = 78,
AFUEColdClima = 98,
AFUEWarmClima = 87.8f
}, ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitodens 200", new HeatingUnitDataSheet()
{
AFUE = 94, WattUsage = 42
}, ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitoladens 300-W", new HeatingUnitDataSheet()
{
AFUE = 91, WattUsage = 18, InternalTempControl = "3"
},
ApplianceTypes.Boiler)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SBT100-3", new SolarStationDataSheet()
{
SolStandbyConsumption = 2.72f, SolPumpConsumption = 45
}, ApplianceTypes.SolarStation)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SBT65-3", new SolarStationDataSheet()
{
SolStandbyConsumption = 2.72f, SolPumpConsumption = 35f
}, ApplianceTypes.SolarStation)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SBT35-3", new SolarStationDataSheet()
{
SolStandbyConsumption = 2.72f, SolPumpConsumption = 30f
}, ApplianceTypes.SolarStation)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SBT160-3", new SolarStationDataSheet()
{
SolStandbyConsumption = 2.72f, SolPumpConsumption = 70f
}, ApplianceTypes.SolarStation)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Compress7000", new HeatingUnitDataSheet()
{
AFUE = 158, AFUEColdClima = 164, AFUEWarmClima = 151, WattUsage = 10
}, ApplianceTypes.HeatPump)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitocal 200-S", new HeatingUnitDataSheet()
{
AFUE = 118, AFUEColdClima = 100, AFUEWarmClima = 183, WattUsage = 9, InternalTempControl = "2"
}, ApplianceTypes.HeatPump)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Compress 5000", new HeatingUnitDataSheet()
{
AFUE = 133, AFUEColdClima = 135, AFUEWarmClima = 132, WattUsage = 43, InternalTempControl = "7"
}, ApplianceTypes.HeatPump)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitocal 350-A", new HeatingUnitDataSheet()
{
AFUE = 112, AFUEColdClima = 98, AFUEWarmClima = 138, WattUsage = 10, InternalTempControl = "3"
}, ApplianceTypes.HeatPump)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Compress6000 AW-5", new HeatingUnitDataSheet()
{
AFUE = 139, AFUEColdClima = 130, AFUEWarmClima = 164, WattUsage = 4
}, ApplianceTypes.HeatPump)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("LogasolSKN", new SolarCollectorDataSheet()
{
Area = 2.25f,
Efficency = 61,
N0 = 0.766f,
a1 = 3.22f,
a2 = 0.015f,
IAM = 0.92f
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("FKC25", new SolarCollectorDataSheet()
{
Area = 2.25f,
Efficency = 61,
N0 = 0.766f,
a1 = 3.22f,
a2 = 0.015f,
IAM = 0.92f
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitosol 300-T", new SolarCollectorDataSheet()
{
Area = 3.19f, Efficency = 72
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Logasol SKN 4.0", new SolarCollectorDataSheet()
{
Area = 2.25f, Efficency = 61
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitosol 200-T", new SolarCollectorDataSheet()
{
Area = 1.33f, Efficency = 67.5f
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitosol 200-T SP2A", new SolarCollectorDataSheet()
{
Area = 3.19f, Efficency = 67.4f
}, ApplianceTypes.SolarPanel)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SomeContiner", new ContainerDataSheet()
{
Volume = 500, Classification = "B", StandingLoss = 80
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("BST 500", new ContainerDataSheet()
{
Volume = 481, Classification = "C", StandingLoss = 100
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SM 500", new ContainerDataSheet()
{
Volume = 500, Classification = "B", StandingLoss = 80
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitocell 140-E 400l", new ContainerDataSheet()
{
Volume = 400, Classification = "B", StandingLoss = 75
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitocell 140-E 950l", new ContainerDataSheet()
{
Volume = 950, Classification = "C"
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitocell 300-B", new ContainerDataSheet()
{
Volume = 300, Classification = "C", StandingLoss = 80
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("BST 500/80", new ContainerDataSheet()
{
Volume = 489.3f, Classification = "E", StandingLoss = 163
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("SW 750", new ContainerDataSheet()
{
Volume = 741f, Classification = "E", StandingLoss = 179
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("BST 500/80", new ContainerDataSheet()
{
Volume = 93.0f, Classification = "C", StandingLoss = 50
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("BST 500-6", new ContainerDataSheet()
{
Volume = 495.0f, Classification = "B", StandingLoss = 82
}, ApplianceTypes.Container)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("FB100", new TemperatureControllerDataSheet()
{
Class = "5"
}, ApplianceTypes.TemperatureController)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("CW400", new TemperatureControllerDataSheet()
{
Class = "6"
}, ApplianceTypes.TemperatureController)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitotronic 200", new TemperatureControllerDataSheet()
{
Class = "3"
}, ApplianceTypes.TemperatureController)
{
CreationDate = DateTime.Now
});
ctx.Appliances.Add(new Appliance("Vitobloc 200", new HeatingUnitDataSheet()
{
AFUE = 140, WattUsage = 39, InternalTempControl = "3"
}, ApplianceTypes.CHP)
{
CreationDate = DateTime.Now
});
ctx.SaveChanges();
}
}
/// <summary>
/// Add a new update row.
/// </summary>
/// <param name="update">Update object.</param>
public void AddNew(Update update)
{
_db.Updates.Add(update);
_db.SaveChanges();
}
/// <summary>
/// Метод зберігає всі зміни в Example, обовязкова передача по ref !!! Так як метод змінює існуючий контекст.
/// </summary>
/// <param name="db"></param>
public void SaveExample(ref AssistantContext db)
{
db.SaveChanges();
}
/// <summary>
/// Add new statistic row from client.
/// </summary>
/// <param name="monitoringValue">Monitoring value object.</param>
public void Add(MonitoringValue monitoringValue)
{
monitoringValue.EventDateTime = DateTime.Now;
_db.MonitoringValues.Add(monitoringValue);
_db.SaveChanges();
}
