// Constructor ...
public PackageForm()
{
InitializeComponent();
_context = new GymDbContext();
uniMetods = new UniMetods();
SelectPackage = new Package();
}
public PackageForm()
{
InitializeComponent();
_context = new GymDbContext();
selectedPackageItem = new Package();
}
public async Task <IActionResult> GetTrainer([FromQuery] string fc)
{
using (var context = new GymDbContext())
{
return(Ok(await context.Trainers.FirstOrDefaultAsync(x => x.FC == fc)));
}
}
public IActionResult SetupDatabase([FromQuery] string par)
{
lock (setupLock)
{
using (var context = new GymDbContext())
{
// Create database
if (context.Database.EnsureCreated())
{
// If user wants, database is created with some istances of records.
if (par == "y")
{
Test test = new Test();
test.TestAPIcontroller();
return(Ok("Database created and populated"));
}
else
{
return(Ok("Database created"));
}
}
}
return(Ok("Database already exists"));
}
}
public async Task <IActionResult> GetTrainingProgram([FromQuery] int id)
{
using (var context = new GymDbContext())
{
return(Ok(await context.TrainingPrograms.FirstOrDefaultAsync(x => x.Id == id)));
}
}
public async Task <IActionResult> GetTrainingRoom([FromQuery] string name)
{
using (var context = new GymDbContext())
{
return(Ok(await context.TrainingRooms.FirstOrDefaultAsync(x => x.Name == name)));
}
}
public async Task <IActionResult> GetTraining([FromQuery] string className, [FromQuery] string trainerFc)
{
using (var context = new GymDbContext())
{
return(Ok(await context.Trainings.FirstOrDefaultAsync(x => (x.ClassName == className) && (x.TrainerFC == trainerFc))));
}
}
// Constructor ...
public MenuItemForm()
{
InitializeComponent();
_context = new GymDbContext();
uniMetods = new UniMetods();
SelectedMenuItem = new MenuItem();
}
// Fill Dashboard list
public void FillDashboardList()
{
using (GymDbContext _contex = new GymDbContext())
{
dgvDashboard.Rows.Clear();
List <Payment> payments = _contex.Payments.Include("Customer").Include("Package").ToList();
foreach (Payment item in payments)
{
if (item.Status == true)
{
dgvDashboard.Rows.Add(
item.CustomerId,
item.Customer.Firstname,
item.Customer.Lastname,
item.Package.Name,
item.Price.ToString("#.00") + " Azn",
item.CreatedAt.AddMonths(1),
item.PackageEntryQuantity,
item.Customer.Balance.ToString("#.00") + " Azn");
if (item.CreatedAt.AddMonths(1) < DateTime.Now || item.PackageEntryQuantity == 0)
{
dgvDashboard.Rows[dgvDashboard.Rows.Count - 1].DefaultCellStyle.BackColor = Color.IndianRed;
}
}
}
}
}
// Constructor ...
public CustomerForm()
{
InitializeComponent();
_context = new GymDbContext();
uniMetods = new UniMetods();
SelectedCustomer = new Customer();
}
public async Task <IActionResult> GetMembership([FromQuery] string className, [FromQuery] string userFc)
{
using (var context = new GymDbContext())
{
return(Ok(await context.Memberships.FirstOrDefaultAsync(x => (x.ClassName == className) && (x.UserFC == userFc))));
}
}
public async Task <IActionResult> GetWorkoutEquipment([FromQuery] string name)
{
using (var context = new GymDbContext())
{
return(Ok(await context.WorkoutEquipments.FirstOrDefaultAsync(x => x.Name == name)));
}
}
public MenuOrderForm()
{
InitializeComponent();
_context = new GymDbContext();
selectedItemOrder = new MenuOrder();
orderitems = new List <MenuOrder>();
selectedMenu = new MenuOrder();
}
public ReportingForm(int cId)
{
InitializeComponent();
customerId = cId;
_context = new GymDbContext();
payments = _context.Payments.Include("Customer").Include("Package").Where(p => p.CustomerId == customerId).ToList();
menuOrders = _context.MenuOrders.Include("Customer").Include("MenuItem").Where(p => p.CustomerId == customerId).ToList();
}
// Constructor ...
public PaymentForm()
{
InitializeComponent();
_context = new GymDbContext();
uniMetods = new UniMetods();
SelectPayment = new Payment();
SelectedCustomer = new Customer();
SelectedPackage = new Package();
}
public async Task <IActionResult> UpdateClass([FromBody] Class class_)
{
using (var context = new GymDbContext())
{
context.Classes.Update(class_);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateTraining([FromBody] Training training)
{
using (var context = new GymDbContext())
{
context.Trainings.Update(training);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateMembership([FromBody] Membership membership)
{
using (var context = new GymDbContext())
{
context.Memberships.Update(membership);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateWorkoutEquipment([FromBody] WorkoutEquipment workoutequipment)
{
using (var context = new GymDbContext())
{
context.WorkoutEquipments.Update(workoutequipment);
await context.SaveChangesAsync();
return(Ok());
}
}
// Constructor ...
public MenuOrderForm()
{
InitializeComponent();
_context = new GymDbContext();
SelectedOrder = new MenuOrder();
menuOrders = new List <MenuOrder>();
selectedCustomer = new Customer();
SelectedmenuItem = new MenuItem();
uniMetods = new UniMetods();
}
public async Task <IActionResult> UpdateUser([FromBody] User user)
{
using (var context = new GymDbContext())
{
context.Users.Update(user);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> CreateTrainingRoom([FromBody] TrainingRoom trainingRoom)
{
using (var context = new GymDbContext())
{
context.TrainingRooms.Add(trainingRoom);
await context.SaveChangesAsync();
return(Ok());
}
}
public void FillPackageCbx()
{
using (GymDbContext _context = new GymDbContext())
{
List <Package> packages = _context.Packages.ToList();
foreach (Package item in packages)
{
if (item.Status == true)
{
cbxPackage.Items.Add(item.Name);
}
}
}
}
public async Task <IActionResult> DeleteTraining([FromQuery] string className, [FromQuery] string trainerFc)
{
using (var context = new GymDbContext())
{
var training = await context.Trainings.FirstOrDefaultAsync(x => (x.ClassName == className) && (x.TrainerFC == trainerFc));
if (training != null)
{
context.Trainings.Remove(training);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteClass([FromQuery] string name)
{
using (var context = new GymDbContext())
{
var class_ = await context.Classes.FirstOrDefaultAsync(x => x.Name == name);
if (class_ != null)
{
context.Classes.Remove(class_);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteTrainingProgram([FromQuery] int id)
{
using (var context = new GymDbContext())
{
var trainingprogram = await context.TrainingPrograms.FirstOrDefaultAsync(x => x.Id == id);
if (trainingprogram != null)
{
context.TrainingPrograms.Remove(trainingprogram);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteWorkoutEquipment([FromQuery] string name)
{
using (var context = new GymDbContext())
{
var workoutequipment = await context.WorkoutEquipments.FirstOrDefaultAsync(x => x.Name == name);
if (workoutequipment != null)
{
context.WorkoutEquipments.Remove(workoutequipment);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public IActionResult DropDatabase()
{
lock (setupLock)
{
using (var context = new GymDbContext())
{
if (context.Database.EnsureDeleted())
{
return(Ok("Database deleted"));
}
}
return(Ok("No database found"));
}
}
public async Task <IActionResult> DeleteMembership([FromQuery] string className, [FromQuery] string userFc)
{
using (var context = new GymDbContext())
{
var membership = await context.Memberships.FirstOrDefaultAsync(x => (x.ClassName == className) && (x.UserFC == userFc));
if (membership != null)
{
context.Memberships.Remove(membership);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteTrainer([FromQuery] string fc)
{
using (var context = new GymDbContext())
{
var trainer = await context.Trainers.FirstOrDefaultAsync(x => x.FC == fc);
if (trainer != null)
{
context.Trainers.Remove(trainer);
await context.SaveChangesAsync();
}
return(Ok());
}
}
