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