private void listViewStudent_DoubleClick(object sender, EventArgs e)
{
if (listViewStudent.SelectedItems.Count != 0)
{
Ogrname = listViewStudent.SelectedItems[0].Text;
}
else
{
Ogrname = "";
}
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
string chooseData = listViewStudent.SelectedItems[0].Text;
var data = db.TBLReaderStudent.Where(x => x.Name == chooseData).FirstOrDefault();
if (db.TBLReaderStudent.Any(x => x.ID == data.ID))
{
foreach (var item in db.TBLReaderStudent.Where(x => x.Name == Ogrname && x.ID == data.ID).ToList())
{
txtName.Text = item.Name;
txtSurname.Text = item.Surname;
cmbGender.Text = item.Gender;
txtAdress.Text = item.Address;
BirthDate.Text = item.DateBirth.ToString();
txtEmail.Text = item.Email;
txtClasNo.Text = item.ClassNo;
txtTC.Text = item.NationalNo;
txtTelephone.Text = item.Telephone;
}
}
}
}
private void btnGüncelle_Click(object sender, EventArgs e)
{
using (BookCenterDBEntities1 dbEntities = new BookCenterDBEntities1())
{
if (BookID != 0)
{
TBLBookList valueChangeBookList = dbEntities.TBLBookList.Find(BookID);
valueChangeBookList.Name = txtBookName.Text;
valueChangeBookList.Publisher = txtPublisher.Text;
valueChangeBookList.Category = txtCategory.Text;
valueChangeBookList.Stock = int.Parse(txtStock.Text);
valueChangeBookList.ReleaseDate = DateTime.Parse(mtxtReleaseDate.Text);
dbEntities.SaveChanges();
MessageBox.Show("İşlem başarılı.");
ClearBookCells();
UpdateHomePage();
}
else
{
MessageBox.Show("Veri Seçiniz.");
}
}
complateData();
}
private void btnOgrGuncelle_Click(object sender, EventArgs e)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
if (studentID != 0)
{
TBLReaderStudent updateStudent = db.TBLReaderStudent.Find(studentID);
updateStudent.NationalNo = mtxtNational.Text;
updateStudent.Name = txtNameStudent.Text;
updateStudent.Surname = txtSurnameS.Text;
updateStudent.ClassNo = txtClass.Text;
updateStudent.DateBirth = Convert.ToDateTime(mskDateBirth.Text);
updateStudent.Telephone = txtNumber.Text;
updateStudent.Email = txtEmail.Text;
updateStudent.MembershipDate = DateTime.Today;
updateStudent.Address = txtAdress.Text;
updateStudent.Gender = cmbGender.Text;
db.SaveChanges();
MessageBox.Show("İşlem Başarılı");
StudentCellsClear();
UpdateHomaPage();
}
else
{
MessageBox.Show("Veri Seçmelisiniz.");
}
}
StudentDataFill();
}
private void btnAddRental_Click(object sender, EventArgs e)
{
if (cmbBookName.Text != "" && cmbStudentName.Text != "")
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
TBLBookRental b = new TBLBookRental();
b.BookID = int.Parse(cmbBookName.SelectedValue.ToString());
b.ReaderStuID = int.Parse(cmbStudentName.SelectedValue.ToString());
b.BookPrice = Convert.ToDecimal(txtPrice.Text);
b.PersonelID = 0;
b.BookRentDay = Convert.ToDateTime(dtRentalDate.Text);
b.DeliveryDate = Convert.ToDateTime(dtDeliveryDate.Text);
db.TBLBookRental.Add(b);
db.SaveChanges();
MessageBox.Show("Kayıt İşlemi Başarılı.");
ClearCell();
}
}
else
{
MessageBox.Show("Alanları Boş Giremezsiniz.");
}
Fill();
}
private void btnOgrKaydet_Click(object sender, EventArgs e)
{
if (txtNameStudent.Text != "" && txtSurnameS.Text != "")
{
using (BookCenterDBEntities1 dbEntities1 = new BookCenterDBEntities1())
{
TBLReaderStudent studentData = new TBLReaderStudent();
studentData.NationalNo = mtxtNational.Text;
studentData.Name = txtNameStudent.Text;
studentData.Surname = txtSurnameS.Text;
studentData.ClassNo = txtClass.Text;
studentData.DateBirth = Convert.ToDateTime(mskDateBirth.Text);
studentData.Telephone = txtNumber.Text;
studentData.Email = txtEmail.Text;
studentData.MembershipDate = DateTime.Today;
studentData.Address = txtAdress.Text;
studentData.Gender = cmbGender.Text;
studentData.Images = "Student.png";
dbEntities1.TBLReaderStudent.Add(studentData);
dbEntities1.SaveChanges();
MessageBox.Show("İşlem Başarılı.");
StudentCellsClear();
UpdateHomaPage();
}
}
else
{
MessageBox.Show("Boş kayıt giremezsiniz.");
}
StudentDataFill();
}
private void Fill()
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
gridBookRental.Rows.Clear();
gridBookRental.ColumnCount = 7;
gridBookRental.Columns[0].Name = "ID";
gridBookRental.Columns[0].Width = 40;
gridBookRental.Columns[1].Name = "Kitap Adı";
gridBookRental.Columns[2].Name = "Öğrenci Adı";
gridBookRental.Columns[3].Name = "Kiralama Tarihi";
gridBookRental.Columns[4].Name = "Teslim Tarihi";
gridBookRental.Columns[5].Name = "Kitap Fiyatı";
gridBookRental.Columns[6].Name = "Personel";
foreach (var item in db.TBLBookRental.ToList())
{
string ogrAd = db.TBLReaderStudent.Where(x => x.ID == item.ReaderStuID).FirstOrDefault().Name;
string bookname = db.TBLBookList.Where(x => x.ID == item.BookID).FirstOrDefault().Name;
string price = Convert.ToDecimal(item.BookPrice).ToString("N");
string[] results = new string[]
{
item.ID.ToString(),
bookname,
ogrAd,
item.BookRentDay.ToString(),
item.DeliveryDate.ToString(),
price,
item.PersonelID.ToString()
};
gridBookRental.Rows.Add(results);
}
}
}
private void btnKaydet_Click(object sender, EventArgs e)
{
if (txtBookName.Text != "" && txtWriterName.Text != "")
{
using (BookCenterDBEntities1 dbEntities = new BookCenterDBEntities1())
{
TBLBookList bookList = new TBLBookList();
bookList.Name = txtBookName.Text;
bookList.WriterName = txtWriterName.Text;
bookList.Publisher = txtPublisher.Text;
bookList.Category = txtCategory.Text;
bookList.Stock = int.Parse(txtStock.Text);
bookList.ReleaseDate = DateTime.Parse(mtxtReleaseDate.Text);
bookList.Images = "book.png";
dbEntities.TBLBookList.Add(bookList);
dbEntities.SaveChanges();
MessageBox.Show("Kayıt Gerçekleştirildi.");
ClearBookCells();
UpdateHomePage();
}
}
else
{
MessageBox.Show("Boş Kayıt Girilemez.");
}
complateData();
}
private void StudentDataFill()
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
StudentPageView.Rows.Clear();
StudentPageView.ColumnCount = 11;
StudentPageView.Columns[0].Name = "ID";
StudentPageView.Columns[0].Width = 50;
StudentPageView.Columns[1].Name = "T.C Kimlik";
StudentPageView.Columns[2].Name = "İsim";
StudentPageView.Columns[3].Name = "Soyisim";
StudentPageView.Columns[4].Name = "Sınıf No";
StudentPageView.Columns[5].Name = "Doğum Tarihi";
StudentPageView.Columns[6].Name = "Telefon";
StudentPageView.Columns[7].Name = "Eposta";
StudentPageView.Columns[8].Name = "Üyelik Tarihi";
StudentPageView.Columns[9].Name = "Cinsiyet";
StudentPageView.Columns[10].Name = "Adres";
foreach (var x in db.TBLReaderStudent.ToList())
{
string[] student = new string[]
{
x.ID.ToString(), x.NationalNo, x.Name, x.Surname, x.ClassNo, x.DateBirth.ToString(), x.Telephone,
x.Email, x.MembershipDate.ToString(), x.Gender, x.Address
};
StudentPageView.Rows.Add(student);
}
}
}
private void listViewBook_DoubleClick(object sender, EventArgs e)
{
if (listViewBook.SelectedItems.Count != 0)
{
bookName = listViewBook.SelectedItems[0].Text;
}
else
{
bookName = "";
}
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
string chooseBook = listViewBook.SelectedItems[0].Text;
var data = db.TBLBookList.Where(x => x.Name == chooseBook).FirstOrDefault();
if (db.TBLBookList.Any(x => x.ID == data.ID))
{
foreach (var item in db.TBLBookList.Where(x => x.Name == bookName && x.ID == data.ID).ToList())
{
txtBookName.Text = item.Name;
txtWriterName.Text = item.WriterName;
txtPublisher.Text = item.Publisher;
txtCategory.Text = item.Category;
ReleaseDate.Text = item.ReleaseDate.ToString();
txtStock.Text = item.Stock.ToString();
}
}
}
}
private void BtnLogin_Click(object sender, EventArgs e)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
if (db.TBLUserLog.Any(x => x.Username == textUsername.Text && x.Password == textPassword.Text))
{
var UserData = db.TBLUserLog
.Where(x => x.Username == textUsername.Text && x.Password == textPassword.Text)
.FirstOrDefault();
Properties.Settings.Default.UserAutho = UserData.Authorize;
Properties.Settings.Default.Save();
BookStorageHome bookStorageHome = new BookStorageHome();
bookStorageHome.Show();
this.Hide();
}
else
{
textUsername.BackColor = Color.Firebrick;
textUsername.ForeColor = Color.AliceBlue;
textPassword.BackColor = Color.Firebrick;
textPassword.ForeColor = Color.AliceBlue;
MessageBox.Show("Giriş İşlemi Başarısız. Tekrar Deneyin");
}
}
}
private void BookRentalPage_Load(object sender, EventArgs e)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
cmbBookName.DataSource = db.TBLBookList.ToList();
cmbBookName.DisplayMember = "Name";
cmbBookName.ValueMember = "ID";
cmbStudentName.DataSource = db.TBLReaderStudent.ToList();
cmbStudentName.DisplayMember = "Name";
cmbStudentName.ValueMember = "ID";
}
cmbBookName.Text = null;
cmbStudentName.Text = null;
Fill();
}
private void Listele()
{
// Öğrencilerimizi görsel olarak listeletiyoruz.
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
listViewBook.Items.Clear();
int i = 0;
foreach (var item in db.TBLBookList.ToList())
{
listViewBook.Items.Add(item.Name);
listViewBook.Items[i].ImageKey = item.Images;
i++;
}
}
}
private void btnDeleteRental_Click(object sender, EventArgs e)
{
if (bookID != 0)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
TBLBookRental bkr = db.TBLBookRental.Find(bookID);
db.TBLBookRental.Remove(bkr);
db.SaveChanges();
bookID = 0;
MessageBox.Show("Kayıt Başarıyla Silindi.");
ClearCell();
}
}
else
{
MessageBox.Show("Veri Seçmelisiniz.");
}
}
private void btnOgrSil_Click(object sender, EventArgs e)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
if (studentID != 0)
{
TBLReaderStudent deleteStudent = db.TBLReaderStudent.Find(studentID);
db.TBLReaderStudent.Remove(deleteStudent);
db.SaveChanges();
studentID = 0;
MessageBox.Show("İşlem Başarılı");
UpdateHomaPage();
}
else
{
MessageBox.Show("Veri Seçmelisiniz.");
}
}
StudentDataFill();
}
private void btnSil_Click(object sender, EventArgs e)
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
if (BookID != 0)
{
TBLBookList deleteBook = db.TBLBookList.Find(BookID);
db.TBLBookList.Remove(deleteBook);
db.SaveChanges();
BookID = 0;
MessageBox.Show("İşlem Başarılı.");
ClearBookCells();
UpdateHomePage();
}
else
{
MessageBox.Show("Veri Seçmediniz.");
}
}
complateData();
}
public void BooksDataFill()
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
gridBooksView.Rows.Clear(); // yeni veri eklendiğinde üstüne ekleme yapmaması için clear kullanıyoruz.
gridBooksView.ColumnCount = 7;
gridBooksView.Columns[0].Name = "ID";
gridBooksView.Columns[0].Width = 30;
gridBooksView.Columns[1].Name = "Kitap Adı";
gridBooksView.Columns[2].Name = "Yazar Adı";
gridBooksView.Columns[3].Name = "Yayın Evi";
gridBooksView.Columns[4].Name = "Kategori";
gridBooksView.Columns[5].Name = "Yayın Tarihi";
gridBooksView.Columns[6].Name = "Stok";
gridBooksView.Columns[6].Width = 50;
foreach (var item in db.TBLBookList.ToList())
{
string[] books = new string[] { item.ID.ToString(), item.Name, item.WriterName, item.Publisher, item.Category, item.ReleaseDate.ToString(), item.Stock.ToString() };
gridBooksView.Rows.Add(books);
}
}
}
private void btnUpdateRental_Click(object sender, EventArgs e)
{
if (bookID != 0 && cmbBookName.Text != "")
{
using (BookCenterDBEntities1 db = new BookCenterDBEntities1())
{
TBLBookRental br = db.TBLBookRental.Find(bookID);
br.BookID = int.Parse(cmbBookName.SelectedValue.ToString());
br.ReaderStuID = int.Parse(cmbStudentName.SelectedValue.ToString());
br.BookPrice = Convert.ToDecimal(txtPrice.Text);
br.PersonelID = 0;
br.BookRentDay = Convert.ToDateTime(dtRentalDate.Text);
br.DeliveryDate = Convert.ToDateTime(dtDeliveryDate.Text);
db.SaveChanges();
MessageBox.Show("Güncelleme işlemi Başarılı.");
ClearCell();
}
}
else
{
MessageBox.Show("Veri Seçmelisiniz.");
}
Fill();
}
