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