public void AddTableToDatabase(TypeOfBoards name, string token)
{
InformationBoards.Add(new Board
{
FunctionName = name,
Token = token
});
SaveChanges();
}
private void DeleteOldBoards(TypeOfBoards name)
{
var tempInformationBoards = InformationBoards.Where(x => x.FunctionName == name).ToList();
var tempInformationBoardsWithoutNewestBoard = tempInformationBoards.Where(x => x.ID < tempInformationBoards.OrderByDescending(y => x.ID).LastOrDefault().ID).ToList();
foreach (var board in tempInformationBoardsWithoutNewestBoard)
{
InformationBoards.Remove(board);
}
SaveChanges();
}
public void DeleteBoardFromDatabase(string token)
{
var board = InformationBoards.SingleOrDefault(x => x.Token == token);
try
{
InformationBoards.Remove(board);
SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
public GarageDBContext()
: base("name=GarageDBContext")
{
if (InformationBoards.Where(x => x.FunctionName == TypeOfBoards.EnterBoard).Count() > 1)
{
DeleteOldBoards(TypeOfBoards.EnterBoard);
}
if (InformationBoards.Where(x => x.FunctionName == TypeOfBoards.ExitBoard).Count() > 1)
{
DeleteOldBoards(TypeOfBoards.ExitBoard);
}
System.Data.Entity.Database.SetInitializer <GarageDBContext>(new CreateDatabaseIfNotExists <GarageDBContext>());
if (Prices.Count() == 0)
{
double[] defaultCosts = { 120, 50, 1.2, 3 };
int[] defaultMinutes = { 0, 0, 30, 60 };
int i = 0;
foreach (var price in Enum.GetValues(typeof(PriceEnum)))
{
Prices.Add(new PriceRates
{
PriceEnum = (PriceEnum)price,
Cost = defaultCosts[i],
Minutes = MakeNullableInt(defaultMinutes[i++])
});
}
SaveChanges();
}
if (GarageInformation.Count() == 0)
{
GarageInformation.Add(new Garage
{
Occupancy = 0,
Capacity = int.Parse(ConfigurationManager.AppSettings["DefaultGarageCapacity"])
});
}
}
public List <Board> GetListOfBoards()
{
return(InformationBoards.ToList());
}
public List <Board> GetListOfBoards(TypeOfBoards FunctionName)
{
var boards = InformationBoards.Where(x => x.FunctionName == FunctionName);
return(boards.ToList());
}
