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