private async void BtnAddPosition_Click(object sender, EventArgs e)
{
string positionName = txtAddPosition.Text.Trim();
if (positionName == string.Empty)
{
ShowMessage("Error", "Doldurun badeleri");
return;
}
if (_context.Positions.Any(p => p.Name.ToLower() == positionName.ToLower()))
{
ShowMessage("Error", "Duplicate position");
return;
}
_context.Positions.Add(new Position
{
Name = positionName
});
await _context.SaveChangesAsync();
dgwPositions.DataSource = _context.Positions.ToArray();
cmbDeletePosition.Items.Clear();
cmbDeletePosition.Items.AddRange(_context.Positions.ToArray());
}
private async void btnUpdate_Click(object sender, EventArgs e)
{
string name = txtUpdateName.Text.Trim();
string days = txtUpdateDays.Text.Trim();
string hours = txtUpdateHours.Text.Trim();
decimal price = nmrUpdatePrice.Value;
if (name == string.Empty || days == string.Empty || hours == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
Packet selectedPacket = cmbPackets.SelectedItem as Packet;
selectedPacket.Name = name;
selectedPacket.Days = days;
selectedPacket.Hours = hours;
selectedPacket.Price = price;
await _context.SaveChangesAsync();
MessageBox.Show("Packets is Update");
Close();
}
private async void btnAddNewService_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
decimal price = nmrService.Value;
string time = txtTime.Text.Trim();
if (name == string.Empty || time == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
_context.Services.Add(new Service
{
Name = name,
Price = price,
Time = time
});
await _context.SaveChangesAsync();
MessageBox.Show("Service is Added");
txtName.Text = "";
txtTime.Text = "";
nmrService.Value = 0;
Close();
}
private void Packages_Load(object sender, EventArgs e)
{
cmbAddPackageTime.Items.AddRange(_context.Times.ToArray());
cmbUpdatePackages.Items.AddRange(_context.Packages.ToArray());
cmbUpdatePackageTime.Items.AddRange(_context.Times.ToArray());
cmbDeletePackage.Items.AddRange(_context.Packages.ToArray());
foreach (var ser in _context.Services)
{
CheckBox checkbox = new CheckBox();
checkbox.Text = ser.Name;
checkbox.Tag = ser.id;
flowLayoutPanel1.Controls.Add(checkbox);
}
_context.SaveChangesAsync();
}
private async void BtnVerify_Click(object sender, EventArgs e)
{
string currentPassword = txtVerifyPassword.Text.Trim();
string newPassword = txtNewPassword.Text.Trim();
string confirmPassword = txtConfirmPassword.Text.Trim();
if (currentPassword == string.Empty || newPassword == string.Empty || confirmPassword == string.Empty)
{
ShowMessage("Error", "Fill all fields");
return;
}
if (!CheckHash(_loggedEmployee.Password, currentPassword))
{
ShowMessage("Error", "Password is invalid");
return;
}
if (newPassword != confirmPassword)
{
ShowMessage("Error", "Password not same");
return;
}
Employee updateEmployee = await _context.Employees.FindAsync(_loggedEmployee.id);
updateEmployee.Password = GetHash(newPassword);
updateEmployee.HasVerified = true;
await _context.SaveChangesAsync();
if (updateEmployee.Position.Name == "Casier")
{
new CasierForm(updateEmployee).ShowDialog();
}
}
private async void btnDeleteCustomer_Click(object sender, EventArgs e)
{
_context.Customers.Remove(cmbDeleteCustomer.SelectedItem as Customer);
await _context.SaveChangesAsync();
MessageBox.Show("Customer deleted");
Close();
}
private async void btnDeleteEmployee_Click(object sender, EventArgs e)
{
_context.Users.Remove(cmbDeleteEmployee.SelectedItem as User);
await _context.SaveChangesAsync();
MessageBox.Show("Employee has deleted");
Close();
}
private async void btnAddEmployee_Click(object sender, EventArgs e)
{
string fname = txtFname.Text.Trim();
string lname = txtLname.Text.Trim();
string username = txtUsername.Text.Trim();
string password = txtPassword.Text.Trim();
string roles = cmbRole.Text.Trim();
if (fname == string.Empty || lname == string.Empty || username == string.Empty || password == string.Empty || roles == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
User user = _context.Users.FirstOrDefault(u => u.Username.ToLower() == username.ToLower());
if (user != null)
{
MessageBox.Show("This Username is in already use.");
return;
}
if (roles == "Admin")
{
_context.Users.Add(new User
{
Firstname = fname,
Lastname = lname,
Username = username,
Password = GetHash(password),
RoleId = 1,
HasVerifiedPassword = false
});
}
if (roles == "Employee")
{
_context.Users.Add(new User
{
Firstname = fname,
Lastname = lname,
Username = username,
Password = GetHash(password),
RoleId = 2,
HasVerifiedPassword = false
});
}
await _context.SaveChangesAsync();
MessageBox.Show("Employee is added");
txtFname.Text = "";
txtLname.Text = "";
txtPassword.Text = "";
txtUsername.Text = "";
Close();
}
private async void btnDeleteService_Click(object sender, EventArgs e)
{
_context.Services.Remove(cmbDeleteService.SelectedItem as Service);
await _context.SaveChangesAsync();
MessageBox.Show("Service Deleted");
Close();
}
private async void btnDeletePacket_Click(object sender, EventArgs e)
{
_context.Packets.Remove(cmbDeletePackets.SelectedItem as Packet);
await _context.SaveChangesAsync();
MessageBox.Show("Packet Deleted");
Close();
}
private async void btnDeleteOrder_Click(object sender, EventArgs e)
{
Order thisOrder = cmbDeleteOrder.SelectedItem as Order;
OrderDetail thisOrderDetail = _context.OrderDetails.FirstOrDefault(o => o.OrderId == thisOrder.Id);
_context.Orders.Remove(thisOrder);
_context.OrderDetails.Remove(thisOrderDetail);
await _context.SaveChangesAsync();
Close();
}
private async void BtnAddEmployee_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
string surname = txtSurname.Text.Trim();
string username = txtUsername.Text.Trim();
string defaultPassword = txtDefaulPassword.Text.Trim();
Position position = cmbPositions.SelectedItem as Position;
if (name == string.Empty || surname == string.Empty || username == string.Empty || defaultPassword == string.Empty)
{
ShowMessage("Error", "Please doldurun badeleri");
return;
}
if (_context.Employees.Any(u => u.Username.ToLower() == username.ToLower()))
{
ShowMessage("Error", "Duplicate username");
return;
}
_context.Employees.Add(new Employee
{
Name = name,
Surname = surname,
Username = username,
Password = GetHash(defaultPassword),
PositionId = position.id
});
await _context.SaveChangesAsync();
ShowMessage("Success", "New employee successfully added", false);
UpdateEmployees();
cmbUpdateEmployee.Items.Clear();
cmbUpdateEmployee.Items.AddRange(_context.Employees.ToArray());
cmbDeleteEmployee.Items.Clear();
cmbDeleteEmployee.Items.AddRange(_context.Employees.ToArray());
}
private async void btnAddCustomers_Click(object sender, EventArgs e)
{
string fname = txtFname.Text.Trim();
string lname = txtLname.Text.Trim();
if (fname == string.Empty || lname == string.Empty)
{
MessageBox.Show("Please fill all fields");
return;
}
Customer thisCustomer = _context.Customers.Add(new Customer
{
Firstname = fname,
Lastname = lname
});
await _context.SaveChangesAsync();
Card thisCard = _context.Cards.Add(new Card
{
CustomerId = thisCustomer.Id,
StartDate = DateTime.Now
});
await _context.SaveChangesAsync();
pnlCard.Visible = true;
lblHeadingCard.Visible = true;
lblfname.Text = $"Firstname : {fname}";
lblLastname.Text = $"Lastname : {lname}";
lblCardNumber.Text = $"Serial Number : {thisCard.Id}";
txtFname.Text = "";
txtLname.Text = "";
MessageBox.Show("Customers Added");
Close();
}
private async void BtnAddService_Click(object sender, EventArgs e)
{
string newServiceName = txtServiceName.Text.Trim();
decimal perHour = nmrPerHour.Value;
Time time = cmbTime.SelectedItem as Time;
_context.Services.Add(new Service
{
Name = newServiceName,
Price__per_hour_ = perHour,
TimeId = time.id
});
await _context.SaveChangesAsync();
dgwService.DataSource = _context.Services.ToArray();
cmbDeleteService.Items.Clear();
cmbDeleteService.Items.AddRange(_context.Services.ToArray());
cmbUpdateService.Items.Clear();
cmbUpdateService.Items.AddRange(_context.Services.ToArray());
}
private async void btnUpdate_Click(object sender, EventArgs e)
{
User selectedUser = cmbEmployee.SelectedItem as User;
string fname = txtFname.Text.Trim();
string lname = txtLname.Text.Trim();
string username = txtUsername.Text.Trim();
string password = txtPassword.Text.Trim();
string roles = cmbRole.SelectedText.Trim();
if (fname == string.Empty || lname == string.Empty || username == string.Empty || password == string.Empty || roles == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
User user = _context.Users.FirstOrDefault(u => u.Username.ToLower() == username.ToLower());
if (user != null)
{
MessageBox.Show("This Username is in already use.");
return;
}
if (cmbRole.SelectedText.Trim() == "Admin")
{
selectedUser.Firstname = fname;
selectedUser.Lastname = lname;
selectedUser.Username = username;
selectedUser.Password = GetHash(password);
selectedUser.RoleId = 1;
}
if (cmbRole.SelectedText.Trim() == "Employee")
{
selectedUser.Firstname = fname;
selectedUser.Lastname = lname;
selectedUser.Username = username;
selectedUser.Password = GetHash(password);
selectedUser.RoleId = 2;
}
await _context.SaveChangesAsync();
txtFname.Text = "";
txtLname.Text = "";
txtPassword.Text = "";
txtUsername.Text = "";
Close();
}
private async void btnUpdate_Click(object sender, EventArgs e)
{
string currentPassword = txtCurrentPass.Text.Trim();
string newPassword = txtNewPass.Text.Trim();
string confirmPassword = txtConfirmPass.Text.Trim();
if (currentPassword == string.Empty || newPassword == string.Empty || confirmPassword == string.Empty)
{
MessageBox.Show("Fill all the password fields", "Error");
return;
}
if (!CheckHash(_loggedUser.Password, currentPassword))
{
MessageBox.Show("Current password is invalid.", "Error");
return;
}
if (newPassword != confirmPassword)
{
MessageBox.Show("New password and confirm password don't match.", "Error");
return;
}
User updateUser = await _context.Users.FindAsync(_loggedUser.Id);
updateUser.Password = GetHash(newPassword);
updateUser.HasVerifiedPassword = true;
await _context.SaveChangesAsync();
if (updateUser.Role.Name == "Employee")
{
this.Close();
new UserForm(updateUser).Show();
}
txtCurrentPass.Text = "";
txtConfirmPass.Text = "";
txtNewPass.Text = "";
}
private async void btnUpdate_Click(object sender, EventArgs e)
{
OrderDetail thisOrder = cmbOrders.SelectedItem as OrderDetail;
string selectedItem = cmbOr.SelectedItem as string;
Packet thisPacket = cmbPacket.SelectedItem as Packet;
Service thisService = cmbService.SelectedItem as Service;
if (selectedItem == "Services")
{
thisOrder.ServiceId = thisService.Id;
thisOrder.PackedId = null;
}
if (selectedItem == "Packets")
{
thisOrder.ServiceId = null;
thisOrder.PackedId = thisPacket.Id;
}
await _context.SaveChangesAsync();
Close();
}
private async void BtnAddCustomer_Click(object sender, EventArgs e)
{
string customerName = txtCustomerName.Text.Trim();
string customerSurname = txtCustomerSurname.Text.Trim();
if (customerName == string.Empty || customerSurname == string.Empty)
{
ShowMessage("Error", "Please doldurun badeleri");
return;
}
_context.Customers.Add(new Customer
{
Name = customerName,
Surname = customerSurname,
});
await _context.SaveChangesAsync();
ShowMessage("Success", "New customer successfully added", false);
}
private async void btnUpdate_Click(object sender, EventArgs e)
{
if (txtUpdateName.Text == string.Empty || txtUpdateTime.Text == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
Service selectedService = cmbService.SelectedItem as Service;
selectedService.Name = txtUpdateName.Text.Trim();
selectedService.Price = nmrUpdatePrice.Value;
selectedService.Time = txtUpdateTime.Text.Trim();
await _context.SaveChangesAsync();
MessageBox.Show("Service is Update");
Close();
txtUpdateName.Text = "";
txtUpdateTime.Text = "";
nmrUpdatePrice.Value = 0;
}
private async void btnAddCustomers_Click(object sender, EventArgs e)
{
string fname = txtFname.Text.Trim();
string lname = txtLname.Text.Trim();
if (fname == string.Empty || lname == string.Empty)
{
MessageBox.Show("Please fill all fields");
return;
}
Customer selectedCustomer = cmbcustomer.SelectedItem as Customer;
selectedCustomer.Firstname = fname;
selectedCustomer.Lastname = lname;
await _context.SaveChangesAsync();
MessageBox.Show("Customer has been Update");
Close();
txtFname.Text = "";
txtLname.Text = "";
}
private async void btnAddCustomer_Click(object sender, EventArgs e)
{
string selectedItem = cmbSelect.Items[cmbSelect.SelectedIndex].ToString();
string firstname = txtFirstname.Text.Trim();
string lastname = txtLastname.Text.Trim();
Service selectedService = cmbServices.SelectedItem as Service;
Packet selectedPacket = cmbPackets.SelectedItem as Packet;
if (firstname == string.Empty || lastname == string.Empty)
{
MessageBox.Show("Please fill all fields.");
}
Customer thisCustomer = _context.Customers.Add(new Customer
{
Firstname = firstname,
Lastname = lastname
});
await _context.SaveChangesAsync();
Card thisCard = _context.Cards.Add(new Card
{
CustomerId = thisCustomer.Id,
StartDate = DateTime.Now
});
await _context.SaveChangesAsync();
Order thisOrder = _context.Orders.Add(new Order
{
UserId = _loggedUser.Id,
Date = DateTime.Now
});
await _context.SaveChangesAsync();
OrderDetail thisOrderDetails = new OrderDetail();
if (selectedItem == "Services")
{
thisOrderDetails = _context.OrderDetails.Add(new OrderDetail
{
OrderId = thisOrder.Id,
CardsId = thisCard.Id,
ServiceId = selectedService.Id,
PackedId = null,
Price = selectedService.Price
});
lblCardHeading.Text = $"{selectedService.Name} Services";
}
if (selectedItem == "Packets")
{
thisOrderDetails = _context.OrderDetails.Add(new OrderDetail
{
OrderId = thisOrder.Id,
CardsId = thisCard.Id,
ServiceId = null,
PackedId = selectedPacket.Id,
Price = selectedPacket.Price
});
lblCardHeading.Text = $"{selectedPacket.Name} Packed";
}
await _context.SaveChangesAsync();
_context.Revenues.Add(new Revenue
{
PriceId = thisOrderDetails.Id,
Price = thisOrderDetails.Price
});
await _context.SaveChangesAsync();
pnlCard.Visible = true;
lblCardNumber.Text = $"Serial Number : {thisCard.Id}";
lblFirstname.Text = $"Firstname : {firstname}";
lblLastname.Text = $"Lastname : {lastname}";
Load_Customers();
txtFirstname.Text = "";
txtLastname.Text = "";
}
private async void btnAddNewService_Click(object sender, EventArgs e)
{
string name = txtName.Text.Trim();
decimal price = nmrService.Value;
string days = txtDays.Text.Trim();
string hours = txtHours.Text.Trim();
if (name == string.Empty || days == string.Empty || hours == string.Empty)
{
MessageBox.Show("Please fill all fields.");
return;
}
Packet thisPacket = _context.Packets.Add(new Packet
{
Name = name,
Price = price,
Days = days,
Hours = hours
});
await _context.SaveChangesAsync();
if (chcGYM.Checked)
{
_context.FitPacks.Add(new FitPack
{
PacketId = thisPacket.Id,
ServiceId = 1
});
}
if (chcSauna.Checked)
{
_context.FitPacks.Add(new FitPack
{
PacketId = thisPacket.Id,
ServiceId = 2
});
}
if (chcPool.Checked)
{
_context.FitPacks.Add(new FitPack
{
PacketId = thisPacket.Id,
ServiceId = 3
});
}
if (chcMassage.Checked)
{
_context.FitPacks.Add(new FitPack
{
PacketId = thisPacket.Id,
ServiceId = 4
});
}
await _context.SaveChangesAsync();
MessageBox.Show("Packet is Added");
txtDays.Text = "";
txtHours.Text = "";
txtName.Text = "";
nmrService.Value = 0;
Close();
}