private void btnTeslimAl_Click(object sender, EventArgs e) { EBorrowedBooks returnBook = new EBorrowedBooks(); returnBook = (EBorrowedBooks)dataGridView1.SelectedRows[0].DataBoundItem; DialogResult result = MessageBox.Show("'" + returnBook.bookName + "'" + " " + "isimli kitabı teslim almak istediğinizden emin misiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (result == DialogResult.Yes) { returnBook.IsReturned = false; returnBook.DateOfReturn = DateTime.Now; bool sonuc = BLLBorrowedBooks.Update(returnBook); if (sonuc) { MessageBox.Show("Harika! Kitap Teslim Alındı!"); txtIsbnNo.Clear(); } else { MessageBox.Show("Bir hata oluştu!"); } } List <EBorrowedBooks> kiralist = BLLBorrowedBooks.GetAll(); kiralist = (from k in kiralist where k.IsReturned == true select k).ToList <EBorrowedBooks>(); dataGridView1.DataSource = kiralist; }
private void KitapTeslimFormu_Load(object sender, EventArgs e) { dataGridView1.AutoGenerateColumns = false; List <EBorrowedBooks> kiralist = BLLBorrowedBooks.GetAll(); kiralist = (from k in kiralist where k.IsReturned == true select k).ToList <EBorrowedBooks>(); dataGridView1.DataSource = kiralist; }
private void txtIsbnNo_TextChanged(object sender, EventArgs e) { string searchText = txtIsbnNo.Text; List <EBorrowedBooks> kiralamaList = BLLBorrowedBooks.GetAll(); kiralamaList = (from l in kiralamaList where l.Book.ISBNNO.Trim().ToLower().Contains(searchText.Trim().ToLower()) && l.IsReturned == true select l).ToList <EBorrowedBooks>(); dataGridView1.DataSource = kiralamaList; }
private void btnKaydet_Click(object sender, EventArgs e) { if (cmbEmployees.SelectedIndex != -1 & cmbMembers.SelectedIndex != -1 & cmbVerilenKitap.SelectedIndex != -1) { EBorrowedBooks borrowedBook = new EBorrowedBooks(); borrowedBook.Book = new EBooks(); borrowedBook.Member = new EMembers(); borrowedBook.Employee = new EEmployees(); borrowedBook.Book.ID = Convert.ToInt32(cmbVerilenKitap.SelectedValue); borrowedBook.Employee.ID = Convert.ToInt32(cmbEmployees.SelectedValue); borrowedBook.Member.ID = Convert.ToInt32(cmbMembers.SelectedValue); borrowedBook.DateOfBorrow = DateTime.Now; borrowedBook.ExpireDate = dtpExpireDate.Value; if (borrowedBook.DateOfBorrow <= borrowedBook.ExpireDate) { if (BLLBorrowedBooks.InsertBorrowedBook(borrowedBook)) { MessageBox.Show("Kayıt işleminiz başarıyla gerçekleşmiştir."); List <EBooks> bookList = BLLBooks.GetBookNames(); if (bookList != null && bookList.Count > 0) { bookList = (from l in bookList where l.IsReturned == false select l).ToList <EBooks>(); } cmbVerilenKitap.DataSource = bookList; } else { MessageBox.Show("Hata Oluştu!"); } } else { MessageBox.Show("Kitap Teslim Tarihi, alınan tarihten eski olamaz!"); } cmbEmployees.SelectedIndex = -1; cmbMembers.SelectedIndex = -1; cmbVerilenKitap.SelectedIndex = -1; } else { MessageBox.Show("Eksik bilgi girdiniz. Lütfen kontrol ediniz!"); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Request.QueryString["ID"] != null) { EBorrowedBooks returnBook = new EBorrowedBooks(); returnBook.ID = int.Parse(Request.QueryString["ID"]); returnBook = BLLBorrowedBooks.GetIdOnly(returnBook.ID); returnBook.DateOfReturn = DateTime.Now; returnBook.IsReturned = false; bool sonuc = BLLBorrowedBooks.Update(returnBook); if (sonuc) { Response.Write("<script>alert('Harika! Kitap Teslim Alındı!')</script>"); } else { Response.Write("<script>alert('Bir hata oluştu!')</script>"); } } List <EBorrowedBooks> bookList = BLLBorrowedBooks.GetAll(); if (bookList != null && bookList.Count > 0) { bookList = (from l in bookList where l.IsReturned == true select l).ToList <EBorrowedBooks>(); } else { Response.Write("<script>alert('Teslim alınacak kitap bulunamadı!')</script>"); } rptKitaplar.DataSource = bookList; rptKitaplar.DataBind(); }
protected void btnKaydet_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(dtpExpireDate.Text)) { EBorrowedBooks borrowedBook = new EBorrowedBooks(); borrowedBook.Book = new EBooks(); borrowedBook.Member = new EMembers(); borrowedBook.Employee = new EEmployees(); borrowedBook.Book.ID = Convert.ToInt32(cmbVerilenKitap.SelectedValue); borrowedBook.Employee.ID = Convert.ToInt32(cmbEmployees.SelectedValue); borrowedBook.Member.ID = Convert.ToInt32(cmbMembers.SelectedValue); borrowedBook.DateOfBorrow = DateTime.Now; string[] alinacakTarArr = dtpExpireDate.Text.Split(new string[] { "." }, StringSplitOptions.None); borrowedBook.ExpireDate = new DateTime(int.Parse(alinacakTarArr[2]), int.Parse(alinacakTarArr[1]), int.Parse(alinacakTarArr[0])); if (borrowedBook.ExpireDate > DateTime.Now) { if (BLLBorrowedBooks.InsertBorrowedBook(borrowedBook)) { Response.Write("<script>alert('Kayıt işleminiz başarıyla gerçekleşmiştir.')</script>"); } else { Response.Write("<script>alert('Hata Oluştu!')</script>"); } } else { Response.Write("<script>alert('Kitap Teslim Tarihi, alınan tarihten eski olamaz!')</script>"); } dtpExpireDate.Text = String.Empty; cmbEmployees.ClearSelection(); cmbMembers.ClearSelection(); cmbVerilenKitap.ClearSelection(); } else { Response.Write("<script>alert('Eksik bilgi girdiniz. Lütfen kontrol ediniz!')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { List <EBorrowedBooks> borrowedBookList = BLLBorrowedBooks.GetAll(); if (chbDisarda.Checked) { chbGecTeslim.Enabled = chbGecikmis.Enabled = false; if (borrowedBookList != null && borrowedBookList.Count > 0) { borrowedBookList = (from l in borrowedBookList where l.IsReturned == true select l).ToList <EBorrowedBooks>(); if (borrowedBookList.Count > 0) { rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } } } else if (chbGecikmis.Checked) { chbGecTeslim.Enabled = chbDisarda.Enabled = false; if (borrowedBookList != null && borrowedBookList.Count > 0) { borrowedBookList = (from l in borrowedBookList where new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day) >= new DateTime(l.ExpireDate.Year, l.ExpireDate.Month, l.ExpireDate.Day) && l.IsReturned == true select l).ToList <EBorrowedBooks>(); if (borrowedBookList.Count > 0) { rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } else { rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } } } else if (chbGecTeslim.Checked) { chbGecikmis.Enabled = chbDisarda.Enabled = false; if (borrowedBookList != null && borrowedBookList.Count > 0) { borrowedBookList = (from l in borrowedBookList where l.DateOfReturn.HasValue && new DateTime(l.DateOfReturn.Value.Year, l.DateOfReturn.Value.Month, l.DateOfReturn.Value.Day) >= new DateTime(l.ExpireDate.Year, l.ExpireDate.Month, l.ExpireDate.Day) && l.IsReturned == false select l).ToList <EBorrowedBooks>(); if (borrowedBookList.Count > 0) { rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } else { rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } } } else { chbGecTeslim.Enabled = chbGecikmis.Enabled = chbDisarda.Enabled = true; rptKitaplar.DataSource = borrowedBookList; rptKitaplar.DataBind(); } }
private void KiralananKitaplar_Load(object sender, EventArgs e) { dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = BLLBorrowedBooks.GetAll(); }