private void button1_Click(object sender, EventArgs e)
{
int user_Id = Convert.ToInt32(dataGridViewDataDel.Rows[dataGridViewDataDel.CurrentCell.RowIndex].Cells[2].Value);
user = db.Users.Find(user_Id);
DeliveredBooks deliveredBooks = new DeliveredBooks();
deliveredBooks.BookId = Convert.ToInt32(labelBookId.Text);
deliveredBooks.BookName = labelBookName.Text;
deliveredBooks.UserId = Convert.ToInt32(user_Id);
deliveredBooks.UserName = user.Name;
deliveredBooks.DeliveryDate = DateTime.Now;
var sorgus = (from p in db.DeliveredBooks where p.BookId.ToString() == labelBookId.Text select p).First();//teslim silme
db.DeliveredBooks.Remove(sorgus);
db.SaveChanges();
string al = "Alınabilir";
int idx = Convert.ToInt32(labelBookId.Text);
var kayit = db.Books.Find(idx);
kayit.Status = al;
db.Books.AddOrUpdate(kayit);
db.SaveChanges();
}
private void buttonConfirm_Click(object sender, EventArgs e)
{
EntrustedBooks entrustedBooks = new EntrustedBooks();
entrustedBooks.BookId = Convert.ToInt32(labelBookId.Text);
entrustedBooks.UserId = Convert.ToInt32(label9.Text);
entrustedBooks.BookName = labelBookName.Text;
entrustedBooks.UserName = label10.Text;
entrustedBooks.DeadLine = DateTime.Now.AddDays(15);
db.EntrustedBooks.Add(entrustedBooks);
db.SaveChanges();
var sorgu = (from p in db.Confirm where p.BookId.ToString() == labelBookId.Text select p).First();
db.Confirm.Remove(sorgu);
db.SaveChanges();
}
private void buttonBookDelete_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(textBoxBookId.Text);
var kayit = db.Books.Find(id);
if (kayit == null)
{
MessageBox.Show("Kitap Bulunamadı.");
return;
}
if (MessageBox.Show(kayit.Name + " isimli kitap silinecek onaylıyor musunuz ? ",
" Kayıt silme onayı",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
db.Books.Remove(kayit);
db.SaveChanges();
}
}
private void btnUsersRemove_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txtUserID.Text);
var kayit = db.Users.Find(id);
if (kayit == null)
{
MessageBox.Show("Kullanıcı ID Bulunamadı.");
return;
}
if (MessageBox.Show(kayit.Name + "isimli kullanıcı silinecek onaylıyor musunuz ? ",
" Kayıt silme onayı",
MessageBoxButtons.YesNo) == DialogResult.Yes)
{
db.Users.Remove(kayit);
db.SaveChanges();
}
}
private void btnOnay_Click(object sender, EventArgs e)
{
var book = db.Books.Find(_bookId);
DeliveredBooks delivered = new DeliveredBooks();
{
delivered.UserId = _userID;
delivered.UserName = usname;
delivered.BookId = Convert.ToInt32(labelBookId.Text);
delivered.DeliveryDate = DateTime.Now;
delivered.BookName = book.Name;
}
db.DeliveredBooks.Add(delivered);
db.SaveChanges();
var sorgu = (from p in db.EntrustedBooks where p.BookId.ToString() == labelBookId.Text select p).First();
db.EntrustedBooks.Remove(sorgu);
db.SaveChanges();
}
private void button1_Click(object sender, EventArgs e)
{
Confirm confirm = new Confirm();
confirm.UserId = _userID;
confirm.UserName = userName;
confirm.BookId = id;
db.Confirm.Add(confirm);
db.SaveChanges();
string al = "Alınamaz";
int idx = Convert.ToInt32(labelBookId.Text);
var kayit = db.Books.Find(idx);
kayit.Status = al;
db.Books.AddOrUpdate(kayit);
db.SaveChanges();
this.Close();
}
