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