/// <summary>
/// Searches for the relating username in all DbSets and removes all content related to it
/// </summary>
/// <param name="UserName">Seeked username</param>
public void RemoveUser(string UserName)
{
foreach (Car Car in CarDb)
{
if (Car.DisplayName == UserName)
{
foreach (var it in FuelDb)
{
if (it.PlateNumber == Car.PlateNumber)
{
FuelDb.Remove(it);
}
}
foreach (var it in RepairDb)
{
if (it.Plate == Car.PlateNumber)
{
RepairDb.Remove(it);
}
}
foreach (var it in NotebookDb)
{
if (it.Plate == Car.PlateNumber)
{
NotebookDb.Remove(it);
}
}
CarDb.Remove(Car);
}
}
SaveChanges();
}
/// <summary>
/// Removes objects of all types with matching plate number value from all DbSets
/// </summary>
/// <param name="Plate">Plate number to be cleared</param>
public void RemoveAllByPlate(string Plate)
{
foreach (Car Car in CarDb)
{
if (Car.PlateNumber == Plate)
{
foreach (var it in FuelDb)
{
if (it.PlateNumber == Plate)
{
FuelDb.Remove(it);
}
}
foreach (var it in RepairDb)
{
if (it.Plate == Plate)
{
RepairDb.Remove(it);
}
}
foreach (var it in NotebookDb)
{
if (it.Plate == Plate)
{
NotebookDb.Remove(it);
}
}
CarDb.Remove(Car);
}
}
this.SaveChanges();
}
public void Add(Topic item)
{
using (NotebookDb db = new NotebookDb())
{
db.Topics.Add(item);
db.SaveChanges();
}
}
public IEnumerable <Topic> GetAll()
{
IEnumerable <Topic> topics = new List <Topic>();
using (NotebookDb db = new NotebookDb())
{
topics = db.Topics.ToList();
}
return(topics);
}
/// <summary>
/// Searches for Notebook-type object with matching plate number and content and removes it
/// </summary>
/// <param name="Plate">Seeked plate number</param>
/// <param name="Note">Seekend content</param>
public void RemoveNote(string Plate, string Note)
{
foreach (var note in NotebookDb)
{
if (note.Plate == Plate && note.Text == Note)
{
NotebookDb.Remove(note);
}
}
SaveChanges();
}
/// <summary>
/// Removes all items from all DbSets
/// </summary>
public void ClearCollection()
{
foreach (Car it in CarDb)
{
CarDb.Remove(it);
}
foreach (var it in NotebookDb)
{
NotebookDb.Remove(it);
}
foreach (var it in RepairDb)
{
RepairDb.Remove(it);
}
foreach (var it in FuelDb)
{
FuelDb.Remove(it);
}
this.SaveChanges();
}
