/// <summary> /// Seed the database /// </summary> /// <param name="context">The database context</param> protected override void Seed(Data.DatabaseContext context) { // Add the list of states context.States.AddOrUpdate(x => x.Id, new Models.State { Id = 1, Name = "New York", Abbreviation = "NY" }, new Models.State { Id = 2, Name = "New Jersey", Abbreviation = "NJ" }); base.Seed(context); }
private void UpdateLessonsInDB(List <Lesson> lessons) { using (var context = new Data.DatabaseContext()) { foreach (var lesson in lessons) { if (!context.Lessons.Any(c => c.ID == lesson.ID)) { context.Lessons.Add(lesson); } else { context.Lessons.Update(lesson); } } context.SaveChanges(); } }
public void Add(int productId, long quantity) { using (var db = new Data.DatabaseContext()) { ShoppingCartItem cartItem = Items.SingleOrDefault(item => item.Product.Id == productId); if (cartItem == null) { Product productToAdd = db.Products.Find(productId); cartItem = new ShoppingCartItem(); cartItem.Product = productToAdd; cartItem.Quantity = quantity; Items.Add(cartItem); } else { cartItem.Quantity += quantity; } } }
public BaseApiControllerWithDatabase(Data.DatabaseContext databaseContext) : base() { MyDatabaseContext = databaseContext; }
static void Main(string[] args) { System.Console.WriteLine("1. Add User"); System.Console.WriteLine("2. Remove User"); System.Console.WriteLine("3. Find User"); System.Console.WriteLine("4. Show All"); System.Console.Write("Enter Option: "); int CheckOption = Convert.ToInt16(Console.ReadLine()); switch (CheckOption) { case 1: { System.Console.Write("Enter FullName: "); string Fullname = Console.ReadLine(); System.Console.Write("Enter Username: "******"Enter Password: "******"Enter Username or Fullname: "); string username = Console.ReadLine();; var UserList = database.Users.Where(u => u.Username == username || u.FullName == username).First(); database.Users.Remove(UserList); database.SaveChanges(); } break; case 3: { Data.DatabaseContext database = new Data.DatabaseContext(); System.Console.Write("Enter Username or Fullname: "); string username = Console.ReadLine();; var FindUsername = database.Users.Where(u => u.Username == username || u.FullName == username).Any(); if (FindUsername == true) { var UserList = database.Users.Where(u => u.Username == username || u.FullName == username).ToList(); foreach (var item in UserList) { System.Console.WriteLine($"FullName: {item.FullName} Username: {item.Username} Password: {item.Password}"); } } else { System.Console.WriteLine(" Not Find !"); } } break; case 4: { Data.DatabaseContext database = new Data.DatabaseContext(); var ShowAll = database.Users.ToList(); foreach (var item in ShowAll) { System.Console.WriteLine($"FullName: {item.FullName} Username: {item.Username} Password: {item.Password}"); } } break; } }
public ApplicationsController(Data.DatabaseContext databaseContext) : base(databaseContext) { }
public ReportController(Data.DatabaseContext context) { _context = context; StiLicense.LoadFromString("6vJhGtLLLz2GNviWmUTrhSqnOItdDwjBylQzQcAOiHl2AD0gPVknKsaW0un+3PuM6TTcPMUAWEURKXNso0e5OJN40hxJjK5JbrxU+NrJ3E0OUAve6MDSIxK3504G4vSTqZezogz9ehm+xS8zUyh3tFhCWSvIoPFEEuqZTyO744uk+ezyGDj7C5jJQQjndNuSYeM+UdsAZVREEuyNFHLm7gD9OuR2dWjf8ldIO6Goh3h52+uMZxbUNal/0uomgpx5NklQZwVfjTBOg0xKBLJqZTDKbdtUrnFeTZLQXPhrQA5D+hCvqsj+DE0n6uAvCB2kNOvqlDealr9mE3y978bJuoq1l4UNE3EzDk+UqlPo8KwL1XM+o1oxqZAZWsRmNv4Rr2EXqg/RNUQId47/4JO0ymIF5V4UMeQcPXs9DicCBJO2qz1Y+MIpmMDbSETtJWksDF5ns6+B0R7BsNPX+rw8nvVtKI1OTJ2GmcYBeRkIyCB7f8VefTSOkq5ZeZkI8loPcLsR4fC4TXjJu2loGgy4avJVXk32bt4FFp9ikWocI9OQ7CakMKyAF6Zx7dJF1nZw"); }
public FormFieldService(Data.DatabaseContext dbContext, IMapper mapper) { _dbContext = dbContext; _mapper = mapper; }
public SubmitService(Data.DatabaseContext dbContext, IMapper mapper, IFormService formService) { _dbContext = dbContext; _mapper = mapper; _formService = formService; }
public FormService(Data.DatabaseContext dbContext, IMapper mapper, IAuthService authService) { _dbContext = dbContext; _mapper = mapper; _authService = authService; }