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