private async void btnAddCustomer_Click(object sender, EventArgs e)
{
string name = txtCustomerAddName.Text.Trim();
string lastname = txtCustomerAddLastName.Text.Trim();
string phone = txtCustomerAddPhone.Text.Trim();
string email = txtCustomerAddEmail.Text.Trim();
if (name == "" || lastname == "" || phone == "" || email == "")
{
MessageBox.Show("Please Fill All Inputs", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!email.IsMail())
{
MessageBox.Show("Write Email Address Correctly", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
Customer customer = new Customer()
{
Name = name, Lastname = lastname, Phone = phone, Email = email
};
_db.Customers.Add(customer);
await _db.SaveChangesAsync();
MessageBox.Show("Successfully Added", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
FillCmb(cmbUpdateCustomer);
FillCmb(cmbDeleteCustomer);
}
private async void btnBooksDelete_Click(object sender, EventArgs e)
{
int id = ((CB_Genre)cmbBooksGenre.SelectedItem).Id;
var book = _db.Books.FirstOrDefault(b => b.Deleted == false && b.GenreId == id);
book.Deleted = true;
await _db.SaveChangesAsync();
MessageBox.Show("Deleted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private async void btnAdminDelete_Click(object sender, EventArgs e)
{
string email = txtboxAdmin.Text.Trim();
Librarian librarian = _db.Librarians.First(l => l.Email == email);
librarian.Deleted = true;
await _db.SaveChangesAsync();
MessageBox.Show("Deleted");
FillDgv();
HideInputs();
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
string name = txt_Name_Registration.Text.Trim();
string surname = txt_Surname_Registration.Text.Trim();
string patronymic = txt_Patronymic_Registration.Text.Trim();
string email = txt_Email_Registration.Text.Trim();
string password = txt_Password_Registration.Password.Trim();
string confirm_password = txt_Confirm_Password_Registration.Password.Trim();
bool Email_is_Db = _libdb.Sellers.Any(s => s.Seller_Email == email);
if (Email_is_Db)
{
MessageBox.Show("Этот эмэил пользуется другим пользователем!!!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
Sellers seller = new Sellers();
seller.Seller_Name = name;
seller.Seller_Surname = surname;
seller.Seller_Patronymic = patronymic;
seller.Seller_Email = email;
seller.Seller_Password = password.HashPassword();
_libdb.Sellers.Add(seller);
await _libdb.SaveChangesAsync();
if (Is_Valid(name, surname, patronymic, email, password, confirm_password))
{
MessageBox.Show("Ваша решистрация прошла успешно!!!", "Success", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
return;
}
}
private async void Button_Click(object sender, RoutedEventArgs e)
{
Sellers seller = _libdb.Sellers.First(s => s.Seller_Name == txt_User_Name.Text.Trim());
int Selected_Case = cb_Case.SelectedIndex;
switch (Selected_Case)
{
case (int)Case.Activated:
seller.Is_Activated = true;
seller.Is_Admin = false;
seller.Is_Deleted = false;
break;
case (int)Case.Admin:
seller.Is_Activated = true;
seller.Is_Admin = true;
seller.Is_Deleted = false;
break;
case (int)Case.Deleted:
seller.Is_Activated = false;
seller.Is_Admin = false;
seller.Is_Deleted = true;
break;
default:
break;
}
await _libdb.SaveChangesAsync();
txt_User_Name.Text = " ";
cb_Case.Text = "";
}
private async void btnDashBoardRent_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Are you sure?", "Info",
MessageBoxButtons.YesNoCancel, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
DateTime date = DateTime.Today;
int selected_customerid = ((CB_Customer)cmbDashboardCustomers.SelectedItem).Id;
int selected_bookid = ((CB_Books)cmbDashBoardBooks.SelectedItem).Id;
DateTime return_date = DateTime.Parse(txtDashBoardReturn.Text.ToString());
int selected_count = int.Parse(numDashBoardCount.Value.ToString());
string selected_customerName = ((CB_Customer)cmbDashboardCustomers.SelectedItem).Name;
string selected_customerLastName = ((CB_Customer)cmbDashboardCustomers.SelectedItem).Lastname;
decimal selected_bookPrice = ((CB_Books)cmbDashBoardBooks.SelectedItem).Price;
string selected_bookName = ((CB_Books)cmbDashBoardBooks.SelectedItem).Name;
Rent rent = new Rent()
{
Count = selected_count,
BookId = selected_bookid,
CustomerId = selected_customerid,
Returndate = return_date,
Date = date,
LibrarianId = _userid,
CustomerName = selected_customerName,
CustomerLastName = selected_customerLastName,
Price = selected_bookPrice,
BookName = selected_bookName
};
_db.Rents.Add(rent);
await _db.SaveChangesAsync();
MessageBox.Show("Successfully Rented");
FillCmbReturnCustomer();
}
}
private async void btn_Add_Book_Click(object sender, RoutedEventArgs e)
{
string Author_Name = txt_Author_Name.Text.Trim();
string Author_Surname = txt_Author_Surname.Text.Trim();
string Author_Patronymic = txt_Author_Patronymic.Text.Trim();
string Book_Name = txt_Book_Name.Text.Trim();
Authors author = new Authors();
author.Author_Name = Author_Name;
author.Author_Surname = Author_Surname;
author.Author_Patronymic = Author_Patronymic;
Books book = new Books();
book.Book_Name = Book_Name;
_libdb.Authors.Add(author);
await _libdb.SaveChangesAsync();
}
private async void btnRegistration_Click(object sender, EventArgs e)
{
string name = txtRegisterName.Text.Trim();
string surname = txtRegisterSurname.Text.Trim();
string email = txtRegisterEmail.Text.Trim();
string password = txtRegisterPassword.Text.Trim();
if (name == "" || password == "" || surname == "" || email == "")
{
MessageBox.Show("Please Fill All Inputs", "Warning", MessageBoxButtons.OK,
MessageBoxIcon.Warning);
return;
}
if (_db.Librarians.Any(l => l.Email == email))
{
MessageBox.Show("This Email Address Already Exists", "Warning",
MessageBoxButtons.OK, MessageBoxIcon.Warning
);
return;
}
if (!email.IsMail())
{
MessageBox.Show("Please Write Email Address Correctly", "Warning",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string passHash = password.HashPassword();
Librarian librarian = new Librarian
{
Name = name,
Lastname = surname,
Email = email,
Password = passHash
};
_db.Librarians.Add(librarian);
await _db.SaveChangesAsync();
MessageBox.Show("Succesfully Saved", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
