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()); }