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