private void BtnSavePayment_Click(object sender, EventArgs e)
{
if (!Validation())
{
MessageBox.Show("Fill All Fields, Please");
return;
}
Payment payment = new Payment();
payment.Price = decimal.Parse(txtPricePayment.Text);
payment.CreatedAt = Convert.ToDateTime(txtCreatedAtPayment.Text);
string customFullname = cmbxCustPayment.SelectedItem.ToString();
Customer customer = _context.Customers.FirstOrDefault(c => c.Firstname + " " + c.Lastname == customFullname);
payment.Customer = customer;
string packageName = cmbxPackPayment.SelectedItem.ToString();
Package package = _context.Packages.FirstOrDefault(p => p.Name + " " + p.Price == packageName);
payment.Package = package;
payment.PackageEntryQuantity = (int)quantity.Value;
payment.Status = true;
_context.Payments.Add(payment);
_context.SaveChanges();
FillPayment();
}
private void BtnSavePackage_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNamePackage.Text.Trim()) ||
string.IsNullOrEmpty(txtEntryPackage.Text.Trim()) ||
string.IsNullOrEmpty(txtPricePackage.Text.Trim())
)
{
MessageBox.Show("Fill All Fields, Please");
return;
}
Package package = new Package();
package.Name = txtNamePackage.Text.Trim();
package.Price = Convert.ToDecimal(txtPricePackage.Text.Trim());
package.EntryQuantity = Convert.ToInt32(txtEntryPackage.Text.Trim());
package.Status = chbxPackage.Checked;
_context.Packages.Add(package);
_context.SaveChanges();
MessageBox.Show($"{package.Name} {package.Price}azn package added");
txtNamePackage.Text = "";
txtPricePackage.Text = "";
txtEntryPackage.Text = "";
FillPackages();
}
private void BtnSaveCustomer_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtCustomersFirstname.Text.Trim()) ||
string.IsNullOrEmpty(txtCustomerLastname.Text.Trim()) ||
string.IsNullOrEmpty((txtCustomerPhone.Text.Trim()))
)
{
MessageBox.Show("Fill All Fields");
}
Customer custom = new Customer();
custom.Firstname = txtCustomersFirstname.Text.Trim();
custom.Lastname = txtCustomerLastname.Text.Trim();
custom.Birthday = dtpBirthday.Value;
custom.Phone = Convert.ToInt32(txtCustomerPhone.Text.Trim());
custom.Status = true;
_context.Customers.Add(custom);
_context.SaveChanges();
MessageBox.Show($"{custom.Firstname} {custom.Lastname} added to Customer List");
txtCustomersFirstname.Text = "";
txtCustomerLastname.Text = "";
txtCustomerPhone.Text = "";
FillCustomers();
}
private void Button1_Click(object sender, EventArgs e)
{
_context.MenuOrders.AddRange(orderitems);
_context.SaveChanges();
Reset();
dgvMenuOrder.Rows.Clear();
}
// Payment Created When clicked Save Button
private void BtnSave_Click(object sender, EventArgs e)
{
if ((cbxCustomer.SelectedIndex >= 0) || (cbxPackage.SelectedIndex >= 0) || !string.IsNullOrEmpty(txtPrice.Text.Trim()) || !string.IsNullOrEmpty(txtCreatedDate.Text.Trim()))
{
if (ValidatePayment())
{
Payment payment = new Payment();
SaveUpdate(payment);
List <Payment> payments = _context.Payments.Include("Customer").ToList();
foreach (Payment item in payments)
{
if (item.Status == true)
{
if (item.CustomerId == payment.CustomerId &&
item.CreatedAt.AddMonths(1) > DateTime.Now && item.PackageEntryQuantity > 0)
{
MessageBox.Show("Customer 's have a active Package");
payment = null;
return;
}
}
}
if (payment != null)
{
_context.Payments.Add(payment);
_context.SaveChanges();
FillPaymentList();
}
}
}
else
{
MessageBox.Show("Please, Fill all fields");
}
}
// Customer Created When clicked Save Button
private void BtnSave_Click(object sender, EventArgs e)
{
Fname = txtFname.Text.Trim();
Lname = txtLname.Text.Trim();
Bdate = txtBirthdate.Text.Trim();
Phone = txtPhone.Text.Trim();
Blnc = txtBalance.Text.Trim();
if (!string.IsNullOrEmpty(Fname) || !string.IsNullOrEmpty(Lname) || !string.IsNullOrEmpty(Bdate) || !string.IsNullOrEmpty(Phone) || !string.IsNullOrEmpty(Blnc))
{
if (ValidatePayment())
{
Customer customer = new Customer();
customer.Firstname = uniMetods.FirstCharToUpper(Fname);
customer.Lastname = uniMetods.FirstCharToUpper(Lname);
customer.Birthdate = DateTime.Parse(Bdate);
customer.Phone = uniMetods.FirstCharToUpper(Phone);
customer.Balance = double.Parse(Blnc);
customer.Status = true;
_context.Customers.Add(customer);
_context.SaveChanges();
FillCustomerList();
}
}
else
{
MessageBox.Show("Please, Fill all fields");
}
}
// Package Created When clicked Save Button
private void BtnSave_Click(object sender, EventArgs e)
{
string PackName = txtPackName.Text.Trim();
string PackQuantity = txtPackQuantity.Text.Trim();
string PackPrice = txtPackPrice.Text.Trim();
if (!string.IsNullOrEmpty(PackName) ||
!string.IsNullOrEmpty(PackQuantity) ||
!string.IsNullOrEmpty(PackPrice))
{
if (ValidatePackage())
{
Package package = new Package();
package.Name = uniMetods.FirstCharToUpper(PackName);
package.EntryQuantity = byte.Parse(uniMetods.FirstCharToUpper(PackQuantity));
package.Price = double.Parse(uniMetods.FirstCharToUpper(PackPrice));
package.Status = true;
_context.Packages.Add(package);
_context.SaveChanges();
FillPackageList();
}
}
else
{
MessageBox.Show("Please, Fill all fields");
}
}
public bool addGymer(GYMER gymer)
{
GYMER check = db.GYMERs.Add(gymer);
db.SaveChanges();
return(check == null ? false:true);
}
// Entry Qunatity falsed on Click Enter
private void BtnCheck_Click(object sender, EventArgs e)
{
if (cbxContinuityCustomer.SelectedIndex >= 0)
{
List <Payment> payments = _context.Payments.Include("Customer").Include("Package").ToList();
string[] arrCust = cbxContinuityCustomer.SelectedItem.ToString().Split('-');
string CustFname = arrCust[1].Trim();
string CustLname = arrCust[0].Trim();
foreach (Payment item in payments)
{
if (item.Status == true)
{
if ((item.Customer.Firstname == CustFname) && (item.Customer.Lastname == CustLname))
{
if (item.PackageEntryQuantity - 1 == 0)
{
MessageBox.Show($"Today is {item.Customer.Firstname.ToUpper()} {item.Customer.Lastname.ToUpper()} 's Last day ");
}
if (item.PackageEntryQuantity - 1 < 0)
{
MessageBox.Show("Entry Quantity ended. Please, buy new package");
return;
}
item.PackageEntryQuantity -= 1;
}
}
}
_context.SaveChanges();
FillContinuityList();
}
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
PopulateSelectLists();
return(Page());
}
customerToUpdate = _context.Customers.First(cust => cust.Id == UpdateCustomerForm.CustomerId);
// 1. Update Schedule
if (UpdateCustomerForm.ScheduleId.HasValue)
{
customerToUpdate.ScheduleId = UpdateCustomerForm.ScheduleId.Value;
}
// 2. Update Height
if (UpdateCustomerForm.Height.HasValue)
{
customerToUpdate.Height = UpdateCustomerForm.Height.Value;
}
// 3. Update Weight
if (UpdateCustomerForm.Weight.HasValue)
{
customerToUpdate.Weight = UpdateCustomerForm.Weight.Value;
}
_context.SaveChanges();
return(RedirectToPage("/customer/details", new { Id = customerToUpdate.Id }));
}
public IActionResult AddOpinion([FromBody] OpinionViewModel opinion)
{
if (opinion.GymId > 0 && !string.IsNullOrEmpty(opinion.Opinion))
{
var gym = gymDbContext.Gyms.FirstOrDefault(c => c.Id == opinion.GymId);
if (gym != null)
{
gym.Opinions.Add(new GymOpinion()
{
Author = User.Identity.Name,
Created = DateTime.Now,
IsVisible = true,
Opinion = opinion.Opinion
});
gymDbContext.SaveChanges();
}
}
return(Ok());
}
private void BtnSaveMenuitem_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNameMenuItem.Text.Trim()) ||
string.IsNullOrEmpty(txtPriceMenuItem.Text.Trim()))
{
MessageBox.Show("Fill All Fields, Please");
return;
}
Models.MenuItem menuItem = new Models.MenuItem();
menuItem.Price = decimal.Parse(txtPriceMenuItem.Text.Trim());
menuItem.Name = txtNameMenuItem.Text.Trim();
menuItem.Status = true;
_context.MenuItems.Add(menuItem);
_context.SaveChanges();
MessageBox.Show($"{menuItem.Name} {menuItem.Price}azn added");
txtNameMenuItem.Text = "";
txtPriceMenuItem.Text = "";
FillMenuItems();
}
// Product Created When clicked Save Button
private void BtnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtName.Text.Trim()) || !string.IsNullOrEmpty(txtPrice.Text.Trim()))
{
if (ValidateProduct())
{
MenuItem menuItem = new MenuItem();
string TxtName = txtName.Text.Trim();
string TxtPrice = txtPrice.Text.Trim();
menuItem.Name = uniMetods.FirstCharToUpper(TxtName);
double Price = double.Parse(TxtPrice);
menuItem.Price = Price;
menuItem.Status = true;
_context.MenuItems.Add(menuItem);
_context.SaveChanges();
FillProductList();
}
}
else
{
MessageBox.Show("Please, Fill all fields");
}
}
public bool CreateClient(Client client)
{
try
{
_dbContext.Clients.Add(client);
_dbContext.SaveChanges();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
Customer customer = _context.Customers.FirstOrDefault(c => c.Id == customerId);
double balance;
bool isdouble = double.TryParse(txtBalance.Text.Trim(), out balance);
if (!isdouble)
{
MessageBox.Show("Please, entered correctly Balance");
return;
}
customer.Balance += double.Parse(txtBalance.Text.Trim());
_context.SaveChanges();
FillCustomerinfo();
txtBalance.Visible = false;
btnAdd.Visible = false;
btnBalance.Visible = true;
btnCancel.Visible = false;
MessageBox.Show($"Balance {balance} (Azn) increased");
}
// Created new Order
private void BtnOrdered_Click(object sender, EventArgs e)
{
if (menuOrders != null)
{
foreach (var item in menuOrders)
{
item.Status = false;
}
_context.MenuOrders.AddRange(menuOrders);
_context.Customers.Find(selectedCustomer.Id).Balance -= totalSum;
cbxCustomer.Enabled = true;
_context.SaveChanges();
MessageBox.Show("The Order is being Prepared");
dgvMenuOrder.Rows.Clear();
cbxCustomer.SelectedIndex = -1;
lblTotalPrice.Text = "";
Reset();
btnOrdered.Enabled = false;
}
}
public IActionResult Signup(string username, string password, string repeatPassword)
{
var errors = new List <string>();
if (username == null || username.Length == 0)
{
errors.Add("Username is required.");
}
else if (_gymDb.Users.ToList().Find(user => user.Login == username) != null)
{
return(View(SignupViewModel.newErrorInstance("A user with that name already exists")));
}
else if (username.Length < 3)
{
errors.Add("Username too short.");
}
if (password == null || password.Length == 0)
{
errors.Add("Password is required.");
}
else if (password.Length < 8)
{
errors.Add("Password too short.");
}
else if (password != repeatPassword)
{
errors.Add("Different passwords were provided.");
}
if (errors.Count > 0)
{
return(View(SignupViewModel.newErrorInstance(string.Join(' ', errors))));
}
else
{
var user = new User(username, Cypher.sha256Hash(password));
_gymDb.Users.Add(user);
_gymDb.SaveChanges();
return(View(SignupViewModel.newSuccessInstance(username)));
}
}
private void TnSaveReporting_Click(object sender, EventArgs e)
{
string customFullname = cmbReporting.SelectedItem.ToString();
Customer customer = _context.Customers.FirstOrDefault(c => c.Firstname + " " + c.Lastname == customFullname);
Payment payment = _context.Payments.FirstOrDefault(p => p.CustomerId == customer.Id);
if (payment == null)
{
return;
}
if (payment.PackageEntryQuantity - 1 < 0)
{
MessageBox.Show("Entry limits expired");
return;
}
payment.PackageEntryQuantity -= 1;
_context.SaveChanges();
FillDgvReport();
cmbReporting.SelectedIndex = -1;
}
public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
PopulateSelectLists();
return(Page());
}
var trainer = _context.Trainers.FirstOrDefault(t => t.Id == AddScheduleForm.TrainerId);
var schedule = new Models.Schedule
{
Day = AddScheduleForm.Day,
ProgramName = trainer.Specialty,
StartTime = AddScheduleForm.StartTime,
EndTime = AddScheduleForm.EndTime,
TrainerId = AddScheduleForm.TrainerId
};
_context.Schedules.Add(schedule);
_context.SaveChanges();
return(RedirectToPage("/Schedule/details", new { Id = schedule.Id }));
}
/// <summary>
/// Initializes the specified service provider.
/// </summary>
/// <param name="serviceProvider">The service provider.</param>
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new GymDbContext(
serviceProvider.GetRequiredService <DbContextOptions <GymDbContext> >()))
{
// Look for any data recieved from DB.
if (context.Schedules.Any() && context.Membership.Any())
{
return; // DB has been seeded
}
// Add Schedules
context.Schedules.AddRange(
new Schedule
{
Id = 1,
Day = DayOfWeek.Monday,
StartTime = new DateTime(1, 1, 1, 7, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
ProgramName = "Yoga",
TrainerId = 1
},
new Schedule
{
Id = 2,
Day = DayOfWeek.Monday,
StartTime = new DateTime(1, 1, 1, 8, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 10, 0, 0), // consider only time and ignore days
ProgramName = "Zumba",
TrainerId = 2
},
new Schedule
{
Id = 3,
Day = DayOfWeek.Monday,
StartTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 12, 0, 0), // consider only time and ignore days
ProgramName = "Weight Training",
TrainerId = 3
},
new Schedule
{
Id = 4,
Day = DayOfWeek.Tuesday,
StartTime = new DateTime(1, 1, 1, 7, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
ProgramName = "Yoga",
TrainerId = 1
},
new Schedule
{
Id = 5,
Day = DayOfWeek.Tuesday,
StartTime = new DateTime(1, 1, 1, 8, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 10, 0, 0), // consider only time and ignore days
ProgramName = "Zumba",
TrainerId = 2
},
new Schedule
{
Id = 6,
Day = DayOfWeek.Tuesday,
StartTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 12, 0, 0), // consider only time and ignore days
ProgramName = "Weight Training",
TrainerId = 3
},
new Schedule
{
Id = 7,
Day = DayOfWeek.Wednesday,
StartTime = new DateTime(1, 1, 1, 7, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
ProgramName = "Yoga",
TrainerId = 1
},
new Schedule
{
Id = 8,
Day = DayOfWeek.Wednesday,
StartTime = new DateTime(1, 1, 1, 8, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 10, 0, 0), // consider only time and ignore days
ProgramName = "Zumba",
TrainerId = 2
},
new Schedule
{
Id = 9,
Day = DayOfWeek.Wednesday,
StartTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 12, 0, 0), // consider only time and ignore days
ProgramName = "Weight Training",
TrainerId = 3
},
new Schedule
{
Id = 10,
Day = DayOfWeek.Thursday,
StartTime = new DateTime(1, 1, 1, 7, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
ProgramName = "Yoga",
TrainerId = 1
},
new Schedule
{
Id = 11,
Day = DayOfWeek.Friday,
StartTime = new DateTime(1, 1, 1, 8, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 10, 0, 0), // consider only time and ignore days
ProgramName = "Zumba",
TrainerId = 2
},
new Schedule
{
Id = 12,
Day = DayOfWeek.Saturday,
StartTime = new DateTime(1, 1, 1, 9, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 12, 0, 0), // consider only time and ignore days
ProgramName = "Weight Training",
TrainerId = 3
},
new Schedule
{
Id = 13,
Day = DayOfWeek.Sunday,
StartTime = new DateTime(1, 1, 1, 7, 0, 0), // consider only time and ignore days
EndTime = new DateTime(1, 1, 1, 12, 0, 0), // consider only time and ignore days
ProgramName = "Jumbo Circuit Training",
TrainerId = 4
}
);
// Add Memberships
context.Membership.AddRange(
new Membership
{
Id = 1,
Duration = 30,
MembershipType = "Regular",
MembershipFee = 100
},
new Membership
{
Id = 2,
Duration = 90,
MembershipType = "Express",
MembershipFee = 275
},
new Membership
{
Id = 3,
Duration = 180,
MembershipType = "Premium",
MembershipFee = 550
},
new Membership
{
Id = 4,
Duration = 360,
MembershipType = "Platinum",
MembershipFee = 1000
}
);
// Add Trainers
context.Trainers.AddRange(
new Trainer
{
Id = 1,
FirstName = "John",
LastName = "Dan",
BirthDate = new DateTime(1985, 03, 15),
Gender = "Male",
StartDate = new DateTime(2012, 06, 01),
Salary = 15,
Specialty = "Yoga"
},
new Trainer
{
Id = 2,
FirstName = "Martha",
LastName = "Davis",
BirthDate = new DateTime(1995, 09, 24),
Gender = "Female",
StartDate = new DateTime(2017, 01, 15),
Salary = 20,
Specialty = "Zumba"
},
new Trainer
{
Id = 3,
FirstName = "Chang",
LastName = "Palva",
BirthDate = new DateTime(1988, 12, 09),
Gender = "Male",
StartDate = new DateTime(2016, 08, 01),
Salary = 25,
Specialty = "Weight Training"
},
new Trainer
{
Id = 4,
FirstName = "Freat",
LastName = "Galvo",
BirthDate = new DateTime(1992, 02, 09),
Gender = "Male",
StartDate = new DateTime(2015, 05, 01),
Salary = 30,
Specialty = "Jumbo Circuit Training"
}
);
// Add Customer
context.Customers.AddRange(
new Customer
{
Id = 1,
FirstName = "Abelson",
LastName = "Hal",
BirthDate = new DateTime(1996, 05, 09),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139674587",
ZipCode = "45210",
JoinDate = new DateTime(2017, 12, 02),
Height = 176,
Weight = 95,
MembershipId = 3,
ScheduleId = 3
},
new Customer
{
Id = 2,
FirstName = "Barry",
LastName = "Dave",
BirthDate = new DateTime(1996, 05, 09),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139374331",
ZipCode = "45212",
JoinDate = new DateTime(2018, 01, 20),
Height = 155,
Weight = 65,
MembershipId = 4,
ScheduleId = 2
},
new Customer
{
Id = 3,
FirstName = "Carolla",
LastName = "Adam",
BirthDate = new DateTime(1998, 09, 11),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132384344",
ZipCode = "45216",
JoinDate = new DateTime(2018, 09, 20),
Height = 165,
Weight = 65,
MembershipId = 2,
ScheduleId = 1
},
new Customer
{
Id = 4,
FirstName = "Dali",
LastName = "Salvador",
BirthDate = new DateTime(1997, 11, 01),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5131480374",
ZipCode = "45216",
JoinDate = new DateTime(2018, 09, 20),
Height = 152,
Weight = 62,
MembershipId = 2,
ScheduleId = 6
},
new Customer
{
Id = 5,
FirstName = "Fox",
LastName = "Gene",
BirthDate = new DateTime(1988, 10, 11),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139980986",
ZipCode = "45221",
JoinDate = new DateTime(2018, 06, 2),
Height = 182,
Weight = 98,
MembershipId = 4,
ScheduleId = 13
},
new Customer
{
Id = 6,
FirstName = "Martin",
LastName = "John",
BirthDate = new DateTime(1980, 10, 11),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139980186",
ZipCode = "45221",
JoinDate = new DateTime(2018, 05, 12),
Height = 172,
Weight = 74,
MembershipId = 4,
ScheduleId = 13
},
new Customer
{
Id = 7,
FirstName = "Paula",
LastName = "Sten",
BirthDate = new DateTime(1983, 09, 11),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132994224",
ZipCode = "45225",
JoinDate = new DateTime(2018, 09, 20),
Height = 165,
Weight = 70,
MembershipId = 1,
ScheduleId = 12
},
new Customer
{
Id = 8,
FirstName = "Jack",
LastName = "Miller",
BirthDate = new DateTime(1974, 03, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5132554224",
ZipCode = "45225",
JoinDate = new DateTime(2018, 03, 20),
Height = 162,
Weight = 90,
MembershipId = 4,
ScheduleId = 10
},
new Customer
{
Id = 9,
FirstName = "Alex",
LastName = "Ferguson",
BirthDate = new DateTime(1966, 10, 18),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5442554224",
ZipCode = "45226",
JoinDate = new DateTime(2017, 03, 20),
Height = 150,
Weight = 60,
MembershipId = 3,
ScheduleId = 8
},
new Customer
{
Id = 10,
FirstName = "Jose",
LastName = "Mourinho",
BirthDate = new DateTime(1984, 08, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5132554004",
ZipCode = "45625",
JoinDate = new DateTime(2018, 05, 19),
Height = 162,
Weight = 80,
MembershipId = 1,
ScheduleId = 7
},
new Customer
{
Id = 11,
FirstName = "Alex",
LastName = "Morgan",
BirthDate = new DateTime(1990, 04, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132553424",
ZipCode = "45228",
JoinDate = new DateTime(2018, 02, 20),
Height = 167,
Weight = 90,
MembershipId = 4,
ScheduleId = 3
},
new Customer
{
Id = 12,
FirstName = "Gal",
LastName = "Gadot",
BirthDate = new DateTime(1980, 08, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5100554224",
ZipCode = "45225",
JoinDate = new DateTime(2018, 06, 20),
Height = 162,
Weight = 90,
MembershipId = 2,
ScheduleId = 5
},
new Customer
{
Id = 13,
FirstName = "Lady",
LastName = "Gaga",
BirthDate = new DateTime(1988, 03, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132094224",
ZipCode = "45229",
JoinDate = new DateTime(2018, 09, 20),
Height = 162,
Weight = 90,
MembershipId = 4,
ScheduleId = 9
},
new Customer
{
Id = 14,
FirstName = "Kylie",
LastName = "Jenner",
BirthDate = new DateTime(1997, 03, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132559824",
ZipCode = "45220",
JoinDate = new DateTime(2018, 06, 20),
Height = 162,
Weight = 90,
MembershipId = 4,
ScheduleId = 5
},
new Customer
{
Id = 15,
FirstName = "Stephen",
LastName = "Curry",
BirthDate = new DateTime(1989, 03, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5138754224",
ZipCode = "45225",
JoinDate = new DateTime(2018, 01, 20),
Height = 190,
Weight = 90,
MembershipId = 3,
ScheduleId = 8
},
new Customer
{
Id = 16,
FirstName = "Raheem",
LastName = "Sterling",
BirthDate = new DateTime(1996, 03, 09),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139674587",
ZipCode = "45210",
JoinDate = new DateTime(2017, 12, 02),
Height = 176,
Weight = 95,
MembershipId = 2,
ScheduleId = 4
},
new Customer
{
Id = 17,
FirstName = "Gareth",
LastName = "Barry",
BirthDate = new DateTime(1992, 05, 09),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5166374331",
ZipCode = "45215",
JoinDate = new DateTime(2018, 11, 20),
Height = 155,
Weight = 65,
MembershipId = 3,
ScheduleId = 1
},
new Customer
{
Id = 18,
FirstName = "Priyanka",
LastName = "Chopra",
BirthDate = new DateTime(1985, 02, 11),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132377344",
ZipCode = "45218",
JoinDate = new DateTime(2016, 09, 20),
Height = 165,
Weight = 65,
MembershipId = 4,
ScheduleId = 11
},
new Customer
{
Id = 19,
FirstName = "Kendall",
LastName = "Jenner",
BirthDate = new DateTime(1997, 03, 01),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5130080374",
ZipCode = "45216",
JoinDate = new DateTime(2013, 09, 20),
Height = 152,
Weight = 62,
MembershipId = 1,
ScheduleId = 6
},
new Customer
{
Id = 20,
FirstName = "Bear",
LastName = "Grylls",
BirthDate = new DateTime(1989, 10, 11),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5139980906",
ZipCode = "45221",
JoinDate = new DateTime(2012, 06, 2),
Height = 182,
Weight = 98,
MembershipId = 4,
ScheduleId = 13
},
new Customer
{
Id = 21,
FirstName = "Chris",
LastName = "Martin",
BirthDate = new DateTime(1983, 10, 11),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5192980186",
ZipCode = "45229",
JoinDate = new DateTime(2015, 05, 12),
Height = 172,
Weight = 74,
MembershipId = 3,
ScheduleId = 10
},
new Customer
{
Id = 22,
FirstName = "Rakhi",
LastName = "Sawant",
BirthDate = new DateTime(1984, 09, 11),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132990924",
ZipCode = "45225",
JoinDate = new DateTime(2016, 09, 20),
Height = 165,
Weight = 70,
MembershipId = 1,
ScheduleId = 6
},
new Customer
{
Id = 23,
FirstName = "John",
LastName = "Terry",
BirthDate = new DateTime(1999, 03, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5137754224",
ZipCode = "45225",
JoinDate = new DateTime(2017, 03, 20),
Height = 162,
Weight = 90,
MembershipId = 1,
ScheduleId = 10
},
new Customer
{
Id = 24,
FirstName = "Cesc",
LastName = "Fabregas",
BirthDate = new DateTime(1982, 10, 18),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5422554224",
ZipCode = "45226",
JoinDate = new DateTime(2017, 03, 20),
Height = 150,
Weight = 60,
MembershipId = 3,
ScheduleId = 8
},
new Customer
{
Id = 25,
FirstName = "Paul",
LastName = "Pogba",
BirthDate = new DateTime(1987, 08, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5132507004",
ZipCode = "45625",
JoinDate = new DateTime(2014, 05, 19),
Height = 162,
Weight = 80,
MembershipId = 1,
ScheduleId = 7
},
new Customer
{
Id = 26,
FirstName = "Alexandra",
LastName = "Martin",
BirthDate = new DateTime(1994, 04, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132553424",
ZipCode = "45228",
JoinDate = new DateTime(2015, 02, 20),
Height = 167,
Weight = 90,
MembershipId = 4,
ScheduleId = 3
},
new Customer
{
Id = 27,
FirstName = "Jennifer",
LastName = "Lopez",
BirthDate = new DateTime(1981, 08, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5100994224",
ZipCode = "45228",
JoinDate = new DateTime(2017, 06, 20),
Height = 162,
Weight = 90,
MembershipId = 2,
ScheduleId = 9
},
new Customer
{
Id = 28,
FirstName = "Emma",
LastName = "Stone",
BirthDate = new DateTime(1993, 03, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5100094224",
ZipCode = "45221",
JoinDate = new DateTime(2014, 09, 20),
Height = 162,
Weight = 90,
MembershipId = 4,
ScheduleId = 9
},
new Customer
{
Id = 29,
FirstName = "Anna",
LastName = "Hathway",
BirthDate = new DateTime(1998, 03, 17),
Gender = "Female",
Email = "*****@*****.**",
PhoneNumber = "5132999824",
ZipCode = "45220",
JoinDate = new DateTime(2018, 06, 20),
Height = 162,
Weight = 90,
MembershipId = 4,
ScheduleId = 11
},
new Customer
{
Id = 30,
FirstName = "Lebron",
LastName = "James",
BirthDate = new DateTime(1983, 03, 17),
Gender = "Male",
Email = "*****@*****.**",
PhoneNumber = "5130954224",
ZipCode = "45225",
JoinDate = new DateTime(2014, 01, 20),
Height = 190,
Weight = 90,
MembershipId = 3,
ScheduleId = 8
}
);
context.SaveChanges();
}
}
public void TestAPIcontroller()
{
using (var context = new GymDbContext())
{
// Training Room
TrainingRoom tr1 = new TrainingRoom()
{
Name = "Main room",
};
context.TrainingRooms.Add(tr1);
// Classes
Class c1 = new Class()
{
Name = "Powerlifting",
Description = "Powerlifting class",
TimeTable = "From Monday to Friday 17-22. Sunday 16-21",
TrainingRoomName = "Main room",
};
Class c2 = new Class()
{
Name = "Weightlifting",
Description = "Weightlifting class",
TimeTable = "From Monday to Friday 8-14. Sunday 9-13",
TrainingRoomName = "Main room",
};
Class c3 = new Class()
{
Name = "Bodybuilding",
Description = "Bodybuilding class",
TimeTable = "Monday, Wednesday and Friday 8-14. Tuesday, Thursday and Sunday 17-21",
TrainingRoomName = "Main room",
};
Class c4 = new Class()
{
Name = "Crossfit",
Description = "Crossfit class",
TimeTable = "Monday, Wednesday and Friday 17-22. Tuesday, Thursday and Sunday 9-13.",
TrainingRoomName = "Main room",
};
context.Classes.Add(c1);
context.Classes.Add(c2);
context.Classes.Add(c3);
context.Classes.Add(c4);
// TrainingPrograms
for (int i = 0; i < 4; i++)
{
TrainingProgram tp = new TrainingProgram()
{
Id = i + 1,
Description = "Example " + (i + 1),
};
context.TrainingPrograms.Add(tp);
}
// Users
User u1 = new User()
{
Name = "Alessandro",
Surname = "Messina",
Address = "Via strada 4",
FC = "MSSLSN95C06D912E",
TrainingProgramId = 1,
};
User u2 = new User()
{
Name = "Dwayne",
Surname = "Johnson",
Address = "Via delle montagne",
FC = "JHNDYN72E02H501L",
TrainingProgramId = 1,
};
User u3 = new User()
{
Name = "Alberto",
Surname = "Angela",
Address = "Via delle Rose",
FC = "NGLLRT50E01A001N",
TrainingProgramId = 2,
};
User u4 = new User()
{
Name = "Piero",
Surname = "Angela",
Address = "Via degli ulivi",
FC = "NGLPRI87D17A026A",
TrainingProgramId = 2,
};
User u5 = new User()
{
Name = "Luke",
Surname = "Skywalker",
Address = "Via degli delle stelle",
FC = "SKYLKU70H30C351B",
TrainingProgramId = 3,
};
User u6 = new User()
{
Name = "Han",
Surname = "Solo",
Address = "Via degli delle falconi",
FC = "SLOHNA64A12G273I",
TrainingProgramId = 3,
};
User u7 = new User()
{
Name = "Diana",
Surname = "Prince",
Address = "Via degli delle amazzoni",
FC = "PRNDNI87R41A001G",
TrainingProgramId = 4,
};
context.Users.Add(u1);
context.Users.Add(u2);
context.Users.Add(u3);
context.Users.Add(u4);
context.Users.Add(u5);
context.Users.Add(u6);
context.Users.Add(u7);
// Memberships
Membership m1 = new Membership()
{
ClassName = "Powerlifting",
UserFC = "MSSLSN95C06D912E",
};
Membership m2 = new Membership()
{
ClassName = "Powerlifting",
UserFC = "JHNDYN72E02H501L",
};
Membership m3 = new Membership()
{
ClassName = "Weightlifting",
UserFC = "NGLLRT50E01A001N",
};
Membership m4 = new Membership()
{
ClassName = "Weightlifting",
UserFC = "NGLPRI87D17A026A",
};
Membership m5 = new Membership()
{
ClassName = "Bodybuilding",
UserFC = "SKYLKU70H30C351B",
};
Membership m6 = new Membership()
{
ClassName = "Bodybuilding",
UserFC = "SLOHNA64A12G273I",
};
Membership m7 = new Membership()
{
ClassName = "Crossfit",
UserFC = "PRNDNI87R41A001G",
};
context.Memberships.Add(m1);
context.Memberships.Add(m2);
context.Memberships.Add(m3);
context.Memberships.Add(m4);
context.Memberships.Add(m5);
context.Memberships.Add(m6);
context.Memberships.Add(m7);
// WorkoutEquipments
WorkoutEquipment we1 = new WorkoutEquipment()
{
Name = "Barbell",
Purpose = "Standard equipment to perform exercises",
TrainingRoomName = "Main room",
};
WorkoutEquipment we2 = new WorkoutEquipment()
{
Name = "Dumbbells",
Purpose = "Standard equipment to perform exercises",
TrainingRoomName = "Main room",
};
WorkoutEquipment we3 = new WorkoutEquipment()
{
Name = "Flat bench",
Purpose = "Equipment to perform bench press, french press and others",
TrainingRoomName = "Main room",
};
WorkoutEquipment we4 = new WorkoutEquipment()
{
Name = "Fitness mat",
Purpose = "ABS",
TrainingRoomName = "Main room",
};
WorkoutEquipment we5 = new WorkoutEquipment()
{
Name = "Plates",
Purpose = "Add weights on burbells or dumbbells",
TrainingRoomName = "Main room",
};
WorkoutEquipment we6 = new WorkoutEquipment()
{
Name = "Calf machine",
Purpose = "Calf",
TrainingRoomName = "Main room",
};
WorkoutEquipment we7 = new WorkoutEquipment()
{
Name = "Decline bench",
Purpose = "ABS, declined exercises",
TrainingRoomName = "Main room",
};
WorkoutEquipment we8 = new WorkoutEquipment()
{
Name = "Power rack",
Purpose = "Base station to perform exercises",
TrainingRoomName = "Main room",
};
WorkoutEquipment we9 = new WorkoutEquipment()
{
Name = "Power tower",
Purpose = "pull ups and dips",
TrainingRoomName = "Main room",
};
WorkoutEquipment we10 = new WorkoutEquipment()
{
Name = "Smith machine",
Purpose = "Guidated exercises",
TrainingRoomName = "Main room",
};
context.WorkoutEquipments.Add(we1);
context.WorkoutEquipments.Add(we2);
context.WorkoutEquipments.Add(we3);
context.WorkoutEquipments.Add(we4);
context.WorkoutEquipments.Add(we5);
context.WorkoutEquipments.Add(we6);
context.WorkoutEquipments.Add(we7);
context.WorkoutEquipments.Add(we8);
context.WorkoutEquipments.Add(we9);
context.WorkoutEquipments.Add(we10);
// Trainers
Trainer t1 = new Trainer()
{
Name = "Bruce",
Surname = "Lee",
Address = "Via della forza",
FC = "LEEBRC80A01H501Q",
Workshift = "Monday, Wednesday and Friday 17-22. Tuesday, Thursday and Sunday 9-13.",
};
Trainer t2 = new Trainer()
{
Name = "Arnold",
Surname = "Schwarzenegger",
Address = "Viale rapisarda",
FC = "SCHRLD59S01F205I",
Workshift = "Monday, Wednesday and Friday 8-14. Tuesday, Thursday and Sunday 17-21",
};
Trainer t3 = new Trainer()
{
Name = "Lu",
Surname = "Xiaojun",
Address = "Viale Leopardi",
FC = "HMSCRS80P01A662N",
Workshift = "From Monday to Friday 8-14. Sunday 9-13",
};
Trainer t4 = new Trainer()
{
Name = "Eddie",
Surname = "Hall",
Address = "Via della forza",
FC = "HLLDDE76T30F158M",
Workshift = "From Monday to Friday 17-22. Sunday 16-21",
};
context.Trainers.Add(t1);
context.Trainers.Add(t2);
context.Trainers.Add(t3);
context.Trainers.Add(t4);
// Trainings
Training trn1 = new Training()
{
ClassName = "Crossfit",
TrainerFC = "LEEBRC80A01H501Q",
};
Training trn2 = new Training()
{
ClassName = "Bodybuilding",
TrainerFC = "SCHRLD59S01F205I",
};
Training trn3 = new Training()
{
ClassName = "Weightlifting",
TrainerFC = "HMSCRS80P01A662N",
};
Training trn4 = new Training()
{
ClassName = "Powerlifting",
TrainerFC = "HLLDDE76T30F158M",
};
context.Trainings.Add(trn1);
context.Trainings.Add(trn2);
context.Trainings.Add(trn3);
context.Trainings.Add(trn4);
context.SaveChanges();
}
}
