public DepartmentsController(DepartmentsContext context) { db = context; if (!db.Departments.Any()) { db.Departments.Add(new Department { Name = "Technical" }); db.Departments.Add(new Department { Name = "Marketing" }); db.Departments.Add(new Department { Name = "IT" }); db.Departments.Add(new Department { Name = "Bookkering" }); db.Departments.Add(new Department { Name = "Legal" }); db.Departments.Add(new Department { Name = "Maintenance" }); db.SaveChanges(); } }
static void Main() { using (var db = new DepartmentsContext()) { DropCreateDatabase(db); } }
public static void UpdateNoTracking() { Department departments = context.Departments.Find(1); departments.Name = "Katedra za IT"; using (DepartmentsContext newContext = new DepartmentsContext()) { newContext.Departments.Update(departments); newContext.SaveChanges(); } }
public static void UpdateSubjectNoTracking() { Subject s = context.Subject.Include(s => s.Items).Single(s => s.SubjectId == 11); s.Items[0].Name = "Izmena 2"; using (DepartmentsContext newContext = new DepartmentsContext()) { //newContext.Update(s); newContext.Attach(s); newContext.Entry(s.Items[0]).State = EntityState.Modified; newContext.SaveChanges(); } }
public UsersController(UsersContext context, DepartmentsContext contextDeps) { db = context; dbDeps = contextDeps; if (!db.Users.Any()) { // Fill departments Department technical = new Department { Name = "Technical" }; Department marketing = new Department { Name = "Marketing" }; Department IT = new Department { Name = "IT" }; Department bookkering = new Department { Name = "Bookkering" }; Department legal = new Department { Name = "Legal" }; Department maintenance = new Department { Name = "Maintenance" }; dbDeps.AddRange(technical, marketing, IT, bookkering, legal, maintenance); dbDeps.SaveChanges(); // Fill users db.Users.Add(new User { Name = "Andrew Thomas", Department = technical }); db.Users.Add(new User { Name = "Bill Moore", Department = technical }); db.Users.Add(new User { Name = "Keiran Moyer", Department = marketing }); db.Users.Add(new User { Name = "Isobella Walmsley", Department = marketing }); db.Users.Add(new User { Name = "Miruna Bullock", Department = IT }); db.Users.Add(new User { Name = "Kier Almond", Department = IT }); db.Users.Add(new User { Name = "Huzaifa Petersen", Department = bookkering }); db.Users.Add(new User { Name = "Akash Roberts", Department = bookkering }); db.Users.Add(new User { Name = "Gino Zhang", Department = legal }); db.Users.Add(new User { Name = "Kya Mcpherson", Department = legal }); db.Users.Add(new User { Name = "Olli Conroy", Department = maintenance }); db.Users.Add(new User { Name = "Fynn Orozco", Department = maintenance }); db.SaveChanges(); } }
public FolioPatternRepository(DepartmentsContext dbContext) : base(dbContext) { }
public Repository(DepartmentsContext context) { Db = context; DbSet = Db.Set <TEntity>(); }
public static void Initialize(DepartmentsContext cntxt) { if (!cntxt.DepartmentGroups.Any()) { var dg = DepartmentGroup.Create("MIS", "Miscellaneous"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("LAU", "Laundry"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("ROR", "Room Revenue"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("F&B", "Food & Beverage"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("SAF", "SAF Group"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("ADJ", "Adjustment (+)"); cntxt.DepartmentGroups.Add(dg); dg = DepartmentGroup.Create("TAX", "Taxes "); cntxt.DepartmentGroups.Add(dg); cntxt.SaveChanges(); } if (!cntxt.Departments.Any()) { var mis = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "MIS"); var lau = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "LAU"); var ror = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "ROR"); var fb = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "F&B"); var saf = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "ADJ"); var tax = cntxt.DepartmentGroups.SingleOrDefault(l => l.Code == "TAX"); var d = Department.Create(Guid.NewGuid().ToString(), lau, DepartmentType.Debit, "Laundry", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Minibar", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Upgrade Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Collect Call", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Lunch ", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Extra Bed", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), tax, DepartmentType.Debit, "Room VAT", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "La Tasca F&B", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Pool Bar F&B", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Room Service F&B", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Dinner ", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Transfer Debit (DO NOT USE !)", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Room Discount", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Child in Bed with Parents", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room No Show", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Day Use", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Early Check-out", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Cancellation Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Upgrade Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), tax, DepartmentType.Debit, "Provincial Room Tax", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room No Show", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Day Use", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Cancellation Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Fino F&B", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Credit, "La Tasca Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Room Service Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Credit, "Pool Bar Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Early Check-out", false, 10, 0); cntxt.Departments.Add(d); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Late Check-in", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Lime Bar F&B", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Credit, "Lime Bar Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Correction ", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Tips", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Breakfast", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Halfboard Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "Fullboard Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), fb, DepartmentType.Debit, "All Inclusive Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Local Call", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Long Distance Call", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Oversea Call", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Fax", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Internet ", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Gala Dinner Christmas Eve", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Gala Dinner New Year Eve", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Special F&B Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Activities & Sport Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Wedding Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Meeting Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Spa Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Debit, "Transportation Package Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Airport Transfer", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Shuttle Bus", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Taxi Service & Transfer", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Excursion Tours", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Photocopy", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Meeting Equipment Rental", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "In Room Entertain Rental", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Gifts & Souvenir", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Spa Treatment/Service", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Outdoor Massage & Beauty", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Visitor/Joiner Register", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Doctor Visit Service", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Car/Bike Rental", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Golf Green Fee", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Missing or Broken Hotel Asset", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Pay Movie Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Other Miscellaneous Charge", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Credit, "MIS Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), saf, DepartmentType.Credit, "SAF Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Play & Chat", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Room Extra Teen (12-17 yrs)", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Minimarket", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Welcome Package", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Credit, "Minimarket Rebate", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Bambino Package", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Baby Cot", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Trolley TCNE (Weekly)", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Extra Adult (18 over)", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Trolley (Daily)", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Extra Bed", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Child in Bed", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Credit, "Rebate Room Discount", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), mis, DepartmentType.Debit, "Welcome Package", false, 10, 0); cntxt.Departments.Add(d); d = Department.Create(Guid.NewGuid().ToString(), ror, DepartmentType.Debit, "Room Extra Child (Under 12)", false, 10, 0); cntxt.Departments.Add(d); cntxt.SaveChanges(); } if (!cntxt.FolioPatterns.Any()) { var f = FolioPattern.Create("BAR", "Barter"); cntxt.FolioPatterns.Add(f); f = FolioPattern.Create("VOU", "Gift Voucher"); cntxt.FolioPatterns.Add(f); f = FolioPattern.Create("COR", "Corporate"); cntxt.FolioPatterns.Add(f); f = FolioPattern.Create("OWN", "Pay direct hotel"); cntxt.FolioPatterns.Add(f); f = FolioPattern.Create("AGT", "Agent Account"); cntxt.FolioPatterns.Add(f); cntxt.SaveChanges(); } }
public DepartmentRepository(DepartmentsContext dbContext) : base(dbContext) { }
private static void DropCreateDatabase(DepartmentsContext db) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); }
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory, IHttpContextAccessor accessor, DepartmentsContext deptoCntxt, RoomsContext cntxt) { loggerFactory.AddConsole(Configuration.GetSection("Logging")); loggerFactory.AddDebug(); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); app.UseDatabaseErrorPage(); app.UseBrowserLink(); } else { app.UseExceptionHandler("/Home/Error"); } app.UseStaticFiles(); app.UseIdentity(); app.UseFacebookAuthentication(new FacebookOptions() { AppId = "SetYourDataHere", AppSecret = "SetYourDataHere" }); app.UseMvc(routes => { routes.MapRoute( name: "default", template: "{controller=Home}/{action=welcome}/{id?}"); }); // Setting the IContainer interface for use like service locator for events. InMemoryBus.ContainerAccessor = () => accessor.HttpContext.RequestServices; //data seeding DepartmentsDataLayer.DbInitializer.Initialize(deptoCntxt); RoomsDataLayer.DbInitializer.Initialize(cntxt); }
public UnitOfWork(DepartmentsContext context) { _context = context; }
public DepartmentsController(DepartmentsContext context) { _context = context; }