private void btnKitapVer_Click(object sender, EventArgs e)
{
position(btnKitapVer);
active(btnKitapVer);
var SECİLEN = (from item in db.TBLKİTAPLAR
where item.BookName == KitapAd &&
item.WriterName == Yazar &&
item.Publisher == YayinEv &&
item.İsActivite == false
select item).FirstOrDefault();
if (SECİLEN == null)
{
MessageBox.Show("Kitap Seçmediniz!");
}
else
{
TBLSECİLEN_KİTAPLAR sclnktp = new TBLSECİLEN_KİTAPLAR();
var NameAndSurname = (from item in db.TBLUSER
where item.UserName == TumFormlar.Username &&
item.UserPassword == TumFormlar.Password
select item).FirstOrDefault();
sclnktp = (from item in db.TBLSECİLEN_KİTAPLAR
where item.BookID == SECİLEN.ID &&
item.UserID == NameAndSurname.UserID
select item).FirstOrDefault();
SECİLEN.İsActivite = true;
db.TBLSECİLEN_KİTAPLAR.Remove(sclnktp);
db.SaveChanges();
AlinanListele();
}
}
private void btnKitapAl_Click(object sender, EventArgs e)
{
var SECİLEN = (from item in db.TBLKİTAPLAR
where item.BookName == KitapAd &&
item.WriterName == Yazar &&
item.Publisher == YayinEv
select item).FirstOrDefault();
var ALİNAN_SECİLEN = (from item in db.TBLSECİLEN_KİTAPLAR
where item.BookID == SECİLEN.ID
select item).FirstOrDefault();
if (SECİLEN == null)
{
MessageBox.Show("Kitap Seçmediniz!");
}
else if (ALİNAN_SECİLEN != null)
{
MessageBox.Show("Bu Kitabı Zaten Almışsınız!", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DialogResult secenek = MessageBox.Show(SECİLEN.BookName + " Kitabını Almak İstiyor musunuz?", "Onay Penceresi", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (secenek == DialogResult.Yes)
{
TBLSECİLEN_KİTAPLAR sclnktp = new TBLSECİLEN_KİTAPLAR();
var NameAndSurname = (from item in db.TBLUSER
where item.UserName == TumFormlar.Username &&
item.UserPassword == TumFormlar.Password
select item).FirstOrDefault();
sclnktp.BookID = SECİLEN.ID;
sclnktp.UserID = NameAndSurname.UserID;
SECİLEN.İsActivite = false;
db.TBLSECİLEN_KİTAPLAR.Add(sclnktp);
db.SaveChanges();
AllListele();
}
}
}
