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