public ActionResult Create([Bind(Exclude = "Amount,datesold")] MembershipBill membershipBill)
{
if (ModelState.IsValid)
{
membershipBill.Amount = 500;
membershipBill.datesold = DateTime.Now;
db.MembershipBills.Add(membershipBill);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeesID = new SelectList(db.Employees, "EmployeesID", "fname", membershipBill.EmployeesID);
ViewBag.MemberID = new SelectList(db.Members, "MemberID", "fname", membershipBill.MemberID);
return(View(membershipBill));
}
public void TestCleanup()
{
var optionsBuilder = new DbContextOptionsBuilder <SalonContext>();
optionsBuilder.UseMySQL("server=localhost;database=todd_aden_test;user=root;password=root;port=3306;");
using (var db = new SalonContext(optionsBuilder.Options))
{
db.Stylists.RemoveRange(db.Stylists.ToArray());
db.Clients.RemoveRange(db.Clients.ToArray());
db.Specialties.RemoveRange(db.Specialties.ToArray());
db.StylistSpecialties.RemoveRange(db.StylistSpecialties.ToArray());
db.SaveChanges();
}
}
public ActionResult CutHair(int id)
{
var db = new SalonContext();
Client client = db.client.Find(id);
Stylist stylist = db.stylist.Find(client.stylist);
stylist.CutHair(client.id);
client = db.client.Find(id);
if (client.hair <= 0)
{
//Client died
db.client.Remove(client);
stylist.GetDrop();
db.SaveChanges();
return(RedirectToAction("Replace", "Stylist", new { id = stylist.id }));
}
return(RedirectToAction("Show", new { id = id }));
}
public ActionResult Create(Client client)
{
_db.Clients.Add(client);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Client new_client)
{
_dataBase.Add(new_client);
_dataBase.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Stylist stylist)
{
_db.Stylist.Add(stylist);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Stylist new_stylist) // Add new stylist object into table.
{
_dataBase.Stylists.Add(new_stylist);
_dataBase.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Client client)
{
_db.Client.Add(client);
_db.SaveChanges();
return RedirectToAction("Details", "Stylist", new { id = client.StylistId});
}
public int JobDone()
{
return(_context.SaveChanges());
}
public static void Initialize(SalonContext context)
{
context.Database.EnsureCreated();
if (!context.Treatment.Any())
{
var treatments = new Treatment[]
{
new Treatment {
Name = "Manicure hybrydowy", Duration = new TimeSpan(1, 0, 0), Price = 80, Category = 1
},
new Treatment {
Name = "Manicure żelowy - założenie", Duration = new TimeSpan(2, 0, 0), Price = 120, Category = 1
},
new Treatment {
Name = "Manicure żelowy - korekta", Duration = new TimeSpan(1, 30, 0), Price = 90, Category = 1
},
new Treatment {
Name = "Manicure japoński", Duration = new TimeSpan(0, 30, 0), Price = 60, Category = 1
},
new Treatment {
Name = "Pedicure hybrydowy", Duration = new TimeSpan(1, 0, 0), Price = 80, Category = 1
},
new Treatment {
Name = "Pedicure klasyczny", Duration = new TimeSpan(1, 0, 0), Price = 60, Category = 1
},
new Treatment {
Name = "Przedłużanie rzęs - założenie", Duration = new TimeSpan(1, 30, 0), Price = 150, Category = 2
},
new Treatment {
Name = "Przedłużanie rzęs - korekta", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 2
},
new Treatment {
Name = "Henna brwi / rzęs", Duration = new TimeSpan(0, 15, 0), Price = 20, Category = 2
},
new Treatment {
Name = "Regulacja brwi", Duration = new TimeSpan(0, 15, 0), Price = 10, Category = 2
},
new Treatment {
Name = "Opalanie natryskowe", Duration = new TimeSpan(0, 45, 0), Price = 80, Category = 3
},
new Treatment {
Name = "Mikrodermabrazja", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 4
},
new Treatment {
Name = "Zabieg Anti Aging", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Acne", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Dry", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Zabieg Anti Rouge", Duration = new TimeSpan(1, 0, 0), Price = 120, Category = 4
},
new Treatment {
Name = "Masaż twarzy", Duration = new TimeSpan(0, 30, 0), Price = 60, Category = 4
},
new Treatment {
Name = "Masaż gorącymi kamieniami", Duration = new TimeSpan(1, 0, 0), Price = 100, Category = 3
}
};
foreach (Treatment t in treatments)
{
context.Treatment.Add(t);
}
context.SaveChanges();
}
if (!context.Users.Any())
{
var users = new AppUser[]
{
new AppUser {
FirstName = "Adam", LastName = "Małysz", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "FD4VTY7VO3NXLA6RDQZ7UUTMICJGQAL6", ConcurrencyStamp = "f47689b9-d29c-44e4-af26-00152339e041",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Robert", LastName = "Kubica", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "ET5UKGXLXLEDNX54H6ZI6XYIP3PVNOKB", ConcurrencyStamp = "37d393db-0376-46d1-85fc-85cb799ec6cd",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Justyna", LastName = "Kowalczyk", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "JDU5TXBYQPKHLIC32L2QW5WQPMUUE2JW", ConcurrencyStamp = "48049f66-d6c3-4f3d-a6c8-3d94ccc0bd57",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
},
new AppUser {
FirstName = "Basia", LastName = "Szweda", UserName = "******",
NormalizedUserName = "******", Email = "*****@*****.**", NormalizedEmail = "*****@*****.**",
PasswordHash = "AQAAAAEAACcQAAAAEF2+bzkrQQJxx/o91I+qPiZo+hx5kd9BbVUsvEWk3S7s6yxnrUoyGh4GjZaxUd58VQ==",
SecurityStamp = "JNVZNOMSXX63POQWXOIBZGMUSFKDTQRV", ConcurrencyStamp = "ac38b4a1-5880-41b5-ae9f-a59998608f2d",
PhoneNumber = "123456789", LockoutEnabled = true, AccessFailedCount = 0
}
};
foreach (AppUser u in users)
{
context.Users.Add(u);
}
context.SaveChanges();
}
if (!context.Employee.Any())
{
var emps = new Employee[]
{
new Employee {
UserId = 1
},
new Employee {
UserId = 2
},
new Employee {
UserId = 3
},
new Employee {
UserId = 4
}
};
foreach (Employee e in emps)
{
context.Employee.Add(e);
}
context.SaveChanges();
}
if (!context.TreatmentAssignment.Any())
{
var treatmentAssignments = new TreatmentAssignment[]
{
new TreatmentAssignment {
EmployeeId = 1, TreatmentId = 1
},
new TreatmentAssignment {
EmployeeId = 1, TreatmentId = 2
},
new TreatmentAssignment {
EmployeeId = 2, TreatmentId = 3
},
new TreatmentAssignment {
EmployeeId = 2, TreatmentId = 4
},
new TreatmentAssignment {
EmployeeId = 3, TreatmentId = 5
},
new TreatmentAssignment {
EmployeeId = 3, TreatmentId = 6
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 7
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 8
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 9
},
new TreatmentAssignment {
EmployeeId = 4, TreatmentId = 10
}
};
foreach (TreatmentAssignment ta in treatmentAssignments)
{
context.TreatmentAssignment.Add(ta);
}
context.SaveChanges();
}
if (!context.Enrollment.Any())
{
var enrollments = new Enrollment[]
{
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 16, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 20, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 1, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 2, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 3, 10, 0, 0), Active = false
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 5, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 14, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 23, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 24, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 1, 28, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 2, 2, 10, 0, 0), Active = true
},
new Enrollment {
UserId = 3, TreatmentAssignmentId = 1, Date = new DateTime(2020, 2, 8, 10, 0, 0), Active = true
}
};
foreach (Enrollment en in enrollments)
{
context.Enrollment.Add(en);
}
context.SaveChanges();
}
}