private void tsBtnSonEklenenler_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
DateTime trh = DateTime.Now.AddMonths(-1);
var sorgu = (from k in db.KitapSet
where k.EklenmeTarihi >= trh
select new
{
k.Id,
k.KitapAdi,
k.SayfaSayisi,
k.TasnifNo,
k.Kategori.KategoriAdi,
k.YayinEvi.YayinEviAdi,
k.KiralikDurumu,
k.KiralanmaTarihi,
k.İadeTarihi,
k.EklenmeTarihi,
YazarAdSoyad = k.Yazar.YazarAdi + " " + k.Yazar.YazarSoyadi
}).ToList();
dgEkran.DataSource = sorgu;
}
private void FrmKullaniciGuncelle_Load(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var klnc = db.KullaniciSet.Find(FrmGiris.ID);
txtAd.Text = klnc.Adi;
txtKimlikNo.Text = klnc.TCKimlikNo;
txtAdres.Text = klnc.Adres;
txtKullaniciAdi.Text = klnc.KullaniciAdi;
txtMail.Text = klnc.Mail;
txtSifre.Text = klnc.Sifre;
txtSoyad.Text = klnc.Soyadi;
txtTel.Text = klnc.Telefon;
txtUnvan.Text = klnc.Unvan;
dtDogumTarihi.Value = klnc.DogumTarihi;
if (ckhGoster.Checked)
{
txtSifre.PasswordChar = '\0';
}
else
{
txtSifre.PasswordChar = '*';
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
if (DateTime.Now.Year - dtDogumTarihi.Value.Year >= 12)
{
ModelDBContainer db = new ModelDBContainer();
Kullanici klnc = new Kullanici();
klnc.TCKimlikNo = txtKimlikNo.Text;
klnc.Adi = txtAd.Text;
klnc.Soyadi = txtSoyad.Text;
klnc.Adres = txtAdres.Text;
klnc.CezaDurumu = false;
klnc.DogumTarihi = dtDogumTarihi.Value;
klnc.KullaniciAdi = txtKullaniciAdi.Text;
klnc.Mail = txtMail.Text;
klnc.Sifre = txtSifre.Text;
klnc.Telefon = txtTel.Text;
klnc.Unvan = txtUnvan.Text;
db.KullaniciSet.Add(klnc);
db.SaveChanges();
MessageBox.Show("Kaydınız Oluşturulmuştur, Lütfen Giriş Yapınız");
this.Close();
}
else
{
MessageBox.Show("12 Yaşından Küçükler Kütüphanemize Üye Olamaz", "Bilgi");
this.Close();
}
}
private void FrmAdminGuncelle_Load(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var ad = db.AdminSet.Find(FrmAdminEkrani.ID);
txtAd.Text = ad.Adi;
txtAdres.Text = ad.Adres;
dtDogumTarihi.Value = ad.DogumTarihi;
txtKullaniciAdi.Text = ad.KullaniciAdi;
txtMail.Text = ad.Mail;
txtSifre.Text = ad.Sifre;
txtSoyad.Text = ad.Soyadi;
txtTel.Text = ad.Telefon;
txtUnvan.Text = ad.Unvan;
if (ckhGoster.Checked)
{
txtSifre.PasswordChar = '\0';
}
else
{
txtSifre.PasswordChar = '*';
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
Admin ad = new Admin();
ad.Adi = txtAd.Text;
ad.Adres = txtAdres.Text;
ad.DogumTarihi = dtDogumTarihi.Value;
ad.KullaniciAdi = txtKullaniciAdi.Text;
ad.Mail = txtMail.Text;
ad.Sifre = txtSifre.Text;
ad.Soyadi = txtSoyad.Text;
ad.Telefon = txtTel.Text;
ad.Unvan = txtUnvan.Text;
db.AdminSet.Add(ad);
db.SaveChanges();
MessageBox.Show("Kaydınız oluşturulmuştur.");
this.Close();
FrmAdminEkrani frm = new FrmAdminEkrani();
frm.Show();
}
private void btnKitapSil_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
ID = (int)dgEkran.SelectedRows[0].Cells[0].Value;
var ktp = db.KitapSet.Find(ID);
db.KitapSet.Remove(ktp);
db.SaveChanges();
MessageBox.Show("İşleminiz gerçekleştirilmiştir.");
var sorgu = (from k in db.KitapSet
select new
{
k.Id,
k.KitapAdi,
k.SayfaSayisi,
k.TasnifNo,
k.Kategori.KategoriAdi,
k.YayinEvi.YayinEviAdi,
k.KiralikDurumu,
k.KiralanmaTarihi,
k.İadeTarihi,
k.EklenmeTarihi,
YazarAdSoyad = k.Yazar.YazarAdi + " " + k.Yazar.YazarSoyadi
}).ToList();
dgEkran.DataSource = sorgu;
}
private void FrmKullaniciEkrani_Load(object sender, EventArgs e)
{
if (FrmGiris.ID != -1)
{
ModelDBContainer db = new ModelDBContainer();
var klnc = db.KullaniciSet.Find(FrmGiris.ID);
tslblKullaniciAdi.Text = "Hoşgeldiniz " + klnc.Unvan + " " + klnc.Adi + " " + klnc.Soyadi;
}
}
private void btnAdminGuncelle_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
ID = (int)dgEkran.SelectedRows[0].Cells[0].Value;
this.Hide();
FrmAdminGuncelle frm = new FrmAdminGuncelle();
frm.Show();
}
private void btnAdminSil_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
ID = (int)dgEkran.SelectedRows[0].Cells[0].Value;
var ad = db.AdminSet.Find(ID);
db.AdminSet.Remove(ad);
db.SaveChanges();
MessageBox.Show("İşleminiz gerçekleştirilmiştir.");
tsBtnAdminler.PerformClick();
}
private void tsBtnYazarlar_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var sorgu = (from y in db.YazarSet
select new
{
y.Id,
AdiSoyadi = y.YazarAdi + " " + y.YazarSoyadi
}).ToList();
lstListeler.DataSource = sorgu;
lstListeler.DisplayMember = "AdiSoyadi";
lstListeler.ValueMember = "Id";
}
private void tsBtnKategoriler_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var sorgu = (from k in db.KategoriSet
select new
{
k.Id,
k.KategoriAdi
}).ToList();
lstListeler.DataSource = sorgu;
lstListeler.DisplayMember = "KategoriAdi";
lstListeler.ValueMember = "Id";
}
private void tsBtnYayinEvleri_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var sorgu = (from y in db.YayinEviSet
select new
{
y.Id,
y.YayinEviAdi
}).ToList();
lstListeler.DataSource = sorgu;
lstListeler.DisplayMember = "YayinEviAdi";
lstListeler.ValueMember = "Id";
}
private bool kullanicisorgusu(string KullaniciAdi, string Sifre, out int ID, out string ceza, out DateTime bitistarihi)
{
ModelDBContainer db = new ModelDBContainer();
ID = -1;
ceza = "";
bitistarihi = DateTime.Now;
var sorgu = from k in db.KullaniciSet
where k.KullaniciAdi == KullaniciAdi && k.Sifre == Sifre
select new
{
k.Id,
};
if (sorgu.Count() > 0)
{
Kullanici klnc = db.KullaniciSet.Find(sorgu.FirstOrDefault().Id);
if (sorgu.Any())
{
if (klnc.CezaSayisi >= 5)
{
ceza = "cezalı";
return(false);
}
else if (klnc.CezaBitisTarihi > DateTime.Now)
{
ceza = "tarihcezası";
bitistarihi = klnc.CezaBitisTarihi.Value;
return(false);
}
else
{
ID = sorgu.FirstOrDefault().Id;
return(true);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private void tsBtnAdminler_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var sorgu = (from a in db.AdminSet
select new
{
a.Id,
a.Unvan,
a.Adi,
a.Soyadi,
a.DogumTarihi,
a.Mail,
a.Telefon,
a.Adres
}).ToList();
dgEkran.DataSource = sorgu;
}
private void tsBtnKullanıcılar_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var sorgu = (from k in db.KullaniciSet
select new
{
k.Id,
k.Unvan,
k.Adi,
k.Soyadi,
k.DogumTarihi,
k.Telefon,
k.Mail,
k.CezaDurumu,
k.CezaSayisi
}).ToList();
dgEkran.DataSource = sorgu;
}
private bool adminsorgusu(string KullaniciAdi, string Sifre, out int ID)
{
ModelDBContainer db = new ModelDBContainer();
ID = -1;
var sorgu = from a in db.AdminSet
where a.KullaniciAdi == KullaniciAdi && a.Sifre == Sifre
select new
{
a.Id,
};
if (sorgu.Any())
{
ID = sorgu.FirstOrDefault().Id;
return(true);
}
else
{
return(false);
}
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
// поиск пользователя в бд
User user = null;
using (ModelDBContainer db = new ModelDBContainer())
{
user = db.Users.FirstOrDefault(u => u.Login == model.Login && u.Password == model.Password);
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Login, true);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Пользователя с таким логином и паролем нет");
}
}
return(View(model));
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var ad = db.AdminSet.Find(FrmAdminEkrani.ID);
ad.Adi = txtAd.Text;
ad.Adres = txtAdres.Text;
ad.DogumTarihi = dtDogumTarihi.Value;
ad.KullaniciAdi = txtKullaniciAdi.Text;
ad.Mail = txtMail.Text;
ad.Sifre = txtSifre.Text;
ad.Soyadi = txtSoyad.Text;
ad.Telefon = txtTel.Text;
ad.Unvan = txtUnvan.Text;
db.SaveChanges();
this.Hide();
MessageBox.Show("Güncelleme işlemi başarı ile gerçekleştirilmiştir.");
FrmAdminEkrani frm = new FrmAdminEkrani();
frm.Show();
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
var klnc = db.KullaniciSet.Find(FrmGiris.ID);
klnc.Adi = txtAd.Text;
klnc.TCKimlikNo = txtKimlikNo.Text;
klnc.Adres = txtAdres.Text;
klnc.DogumTarihi = dtDogumTarihi.Value;
klnc.KullaniciAdi = txtKullaniciAdi.Text;
klnc.Mail = txtMail.Text;
klnc.Sifre = txtSifre.Text;
klnc.Soyadi = txtSoyad.Text;
klnc.Telefon = txtTel.Text;
klnc.Unvan = txtUnvan.Text;
db.SaveChanges();
this.Hide();
FrmKullaniciEkrani frm = new FrmKullaniciEkrani();
frm.Show();
}
private void btnGirisYap_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
if (db.KullaniciSet.Count() > 0 || db.AdminSet.Count() > 0)
{
if (kullanicisorgusu(txtKullaniciAdi.Text, txtSifre.Text, out ID, out ceza, out bitistarihi))
{
FrmKullaniciEkrani frm = new FrmKullaniciEkrani();
frm.Show();
this.Hide();
}
else if (adminsorgusu(txtKullaniciAdi.Text, txtSifre.Text, out ID))
{
FrmAdminEkrani frm = new FrmAdminEkrani();
frm.Show();
this.Hide();
}
else
{
if (ceza == "cezalı")
{
MessageBox.Show("Maksimum ceza sayısına ulaştığınız için kütüphanemizden yararlanma hakkınız kaybetmiş bulunmaktasınız", "BİLGİ");
textbozTemizle();
}
else if (ceza == "tarihcezası")
{
MessageBox.Show(bitistarihi + " tarihinene kadar cezanız bulunmaktadır.Bu süre zarfında kütüphanemizden yararlanmanız yasaklanmıştır.");
textbozTemizle();
}
else
{
MessageBox.Show("Böyle bir kullanıcı veya admin bulunamamıştır, Lütfen Kayıt Olunuz");
}
}
}
}
public ActionResult ExportFile(int id)
{
try
{
//string editor = "";
//editor = "<table><th>1</th><th>2</th></table>";
//// Create a unique file name
//string fileName = Guid.NewGuid() + ".docx";
//// Convert HTML text to byte array
//byte[] byteArray = Encoding.UTF8.GetBytes(editor.Contains("<html>") ? editor : "<html>" + editor + "</html>");
//// Generate Word document from the HTML
//MemoryStream stream = new MemoryStream(byteArray);
//Document document = new Document(stream);
//// Create memory stream for the Word file
//var outputStream = new MemoryStream();
//document.Save(outputStream, SaveFormat.Docx);
//outputStream.Position = 0;
//// Return generated Word file
//return File(outputStream, System.Net.Mime.MediaTypeNames.Application.Rtf, fileName);
Package package = null;
DateTime date;
string addressFrom = "", addressTo;
Person From, To;
using (ModelDBContainer db = new ModelDBContainer())
{
package = db.Packages.Find(id);
From = package.PersonFrom;
To = package.PersonTo;
if (package == null)
{
throw new Exception("The package was not found");
}
var maxDate = package.Records.Select(a => a.DateAndTime).Max();
date = package.Records.Where(a => a.DateAndTime == maxDate).Single().DateAndTime;
if (From.CentreId != null)
{
DistributionCentre c = db.DistributionCentres.Find(From.CentreId);
addressFrom = c.City.Region.Country.NameCountry + ", " + c.City.Region.NameRegion + ", " + c.City.NameCity + ", " + c.Address;
}
else
{
addressFrom = From.City.Region.Country.NameCountry + ", " + From.City.Region.NameRegion + ", " + From.City.NameCity + ", " + From.Address;
}
if (To.CentreId != null)
{
DistributionCentre c = db.DistributionCentres.Find(To.CentreId);
addressTo = c.City.Region.Country.NameCountry + ", " + c.City.Region.NameRegion + ", " + c.City.NameCity + ", " + c.Address;
}
else
{
addressTo = To.City.Region.Country.NameCountry + ", " + To.City.Region.NameRegion + ", " + To.City.NameCity + ", " + To.Address;
}
}
string companyName = Properties.Settings.Default.CompanyName;
// Creating a new document.
WordDocument document = new WordDocument();
//Adding a new section to the document.
WSection section = document.AddSection() as WSection;
//Set Margin of the section
section.PageSetup.Margins.All = 50;
//Set page size of the section
//section.PageSetup.PageSize = new Syncfusion.Drawing.SizeF(612, 792);
//Create Paragraph styles
WParagraphStyle style = document.AddParagraphStyle("Normal") as WParagraphStyle;
style.CharacterFormat.FontName = "Calibri";
style.CharacterFormat.FontSize = 11f;
style.ParagraphFormat.BeforeSpacing = 0;
style.ParagraphFormat.AfterSpacing = 8;
style.ParagraphFormat.LineSpacing = 13.8f;
style = document.AddParagraphStyle("Heading 1") as WParagraphStyle;
style.ApplyBaseStyle("Normal");
style.CharacterFormat.FontName = "Calibri Light";
style.CharacterFormat.FontSize = 16f;
// style.CharacterFormat.TextColor = Syncfusion.Drawing.Color.FromArgb(46, 116, 181);
style.ParagraphFormat.BeforeSpacing = 12;
style.ParagraphFormat.AfterSpacing = 0;
style.ParagraphFormat.Keep = true;
style.ParagraphFormat.KeepFollow = true;
style.ParagraphFormat.OutlineLevel = Syncfusion.DocIO.OutlineLevel.Level1;
IWParagraph paragraph = section.AddParagraph();
paragraph.ApplyStyle("Heading 1");
paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Left;
WTextRange textRange = paragraph.AppendText(companyName) as WTextRange;
textRange.CharacterFormat.FontSize = 14f;
textRange.CharacterFormat.FontName = "Calibri";
paragraph.ParagraphFormat.HorizontalAlignment = HorizontalAlignment.Left;
textRange = paragraph.AppendText("#" + package.Id) as WTextRange;
textRange.CharacterFormat.FontSize = 14f;
textRange.CharacterFormat.FontName = "Calibri";
paragraph.ApplyStyle("Normal");
//Appends table.
IWTable table = section.AddTable();
table.ResetCells(16, 4);
table.TableFormat.Borders.BorderType = BorderStyle.Single;
table.TableFormat.IsAutoResized = true;
//Appends paragraph.
paragraph = table[1, 0].AddParagraph();
textRange = paragraph.AppendText("ФИО") as WTextRange;
paragraph = table[2, 0].AddParagraph();
textRange = paragraph.AppendText("Компания") as WTextRange;
paragraph = table[3, 0].AddParagraph();
textRange = paragraph.AppendText("Адрес") as WTextRange;
paragraph = table[4, 0].AddParagraph();
textRange = paragraph.AppendText("Телефон") as WTextRange;
string name1 = (From.Name == null ? "" : From.Name) + " " + (From.MiddleName == null ? "" : From.MiddleName) + " " + (From.Surname == null ? "" : From.Surname);
paragraph = table[1, 1].AddParagraph();
textRange = paragraph.AppendText(name1) as WTextRange;
paragraph = table[2, 1].AddParagraph();
textRange = paragraph.AppendText(From.Company == null ? "":From.Company) as WTextRange;
paragraph = table[3, 1].AddParagraph();
textRange = paragraph.AppendText(addressFrom) as WTextRange;
paragraph = table[4, 1].AddParagraph();
textRange = paragraph.AppendText(From.Phone == null ? "" : From.Phone) as WTextRange;
paragraph = table[6, 0].AddParagraph();
textRange = paragraph.AppendText("ФИО") as WTextRange;
paragraph = table[7, 0].AddParagraph();
textRange = paragraph.AppendText("Компания") as WTextRange;
paragraph = table[8, 0].AddParagraph();
textRange = paragraph.AppendText("Адрес") as WTextRange;
paragraph = table[9, 0].AddParagraph();
textRange = paragraph.AppendText("Телефон") as WTextRange;
string name2 = (To.Name == null ? "" : To.Name) + " " + (To.MiddleName == null ? "" : To.MiddleName) + " " + (To.Surname == null ? "" : To.Surname);
paragraph = table[6, 1].AddParagraph();
textRange = paragraph.AppendText(name2) as WTextRange;
paragraph = table[7, 1].AddParagraph();
textRange = paragraph.AppendText(To.Company == null ? "" : To.Company) as WTextRange;
paragraph = table[8, 1].AddParagraph();
textRange = paragraph.AppendText(addressTo) as WTextRange;
paragraph = table[9, 1].AddParagraph();
textRange = paragraph.AppendText(To.Phone == null ? "" : To.Phone) as WTextRange;
paragraph = table[11, 0].AddParagraph();
textRange = paragraph.AppendText("Дата " + date.ToShortDateString()) as WTextRange;
paragraph = table[11, 1].AddParagraph();
textRange = paragraph.AppendText("Время") as WTextRange;
paragraph = table[12, 1].AddParagraph();
textRange = paragraph.AppendText("Подпись") as WTextRange;
paragraph = table[1, 2].AddParagraph();
textRange = paragraph.AppendText("Объяв.стоимость") as WTextRange;
paragraph = table[2, 2].AddParagraph();
textRange = paragraph.AppendText("Описание") as WTextRange;
paragraph = table[3, 2].AddParagraph();
textRange = paragraph.AppendText("Вес") as WTextRange;
paragraph = table[4, 2].AddParagraph();
textRange = paragraph.AppendText("Размеры") as WTextRange;
paragraph = table[5, 2].AddParagraph();
textRange = paragraph.AppendText("Количество") as WTextRange;
paragraph = table[6, 2].AddParagraph();
textRange = paragraph.AppendText("Стоимость") as WTextRange;
paragraph = table[7, 2].AddParagraph();
textRange = paragraph.AppendText("Курьер") as WTextRange;
paragraph = table[7, 3].AddParagraph();
textRange = paragraph.AppendText("Подпись") as WTextRange;
paragraph = table[1, 3].AddParagraph();
textRange = paragraph.AppendText(package.DeclaredValue == null ? "" : (package.DeclaredValue.ToString() + " руб")) as WTextRange;
paragraph = table[2, 3].AddParagraph();
textRange = paragraph.AppendText(package.Description) as WTextRange;
paragraph = table[3, 3].AddParagraph();
textRange = paragraph.AppendText(package.Weight.ToString() + " кг") as WTextRange;
paragraph = table[4, 3].AddParagraph();
textRange = paragraph.AppendText(package.Width + "*" + package.Length + "*" + package.Height + " см") as WTextRange;
paragraph = table[5, 3].AddParagraph();
textRange = paragraph.AppendText(package.NumberOfPackages.ToString()) as WTextRange;
paragraph = table[6, 3].AddParagraph();
textRange = paragraph.AppendText(package.Cost == null ? "" : (package.Cost.ToString() + " руб")) as WTextRange;
paragraph = table[15, 2].AddParagraph();
textRange = paragraph.AppendText("Дата Время") as WTextRange;
paragraph = table[15, 3].AddParagraph();
textRange = paragraph.AppendText("Подпись") as WTextRange;
paragraph = table[14, 2].AddParagraph();
textRange = paragraph.AppendText("Получатель(ФИО)") as WTextRange;
paragraph = table[0, 0].AddParagraph();
textRange = paragraph.AppendText("Отправитель") as WTextRange; textRange.CharacterFormat.Bold = true;
paragraph = table[5, 0].AddParagraph();
textRange = paragraph.AppendText("Получатель") as WTextRange; textRange.CharacterFormat.Bold = true;
paragraph = table[13, 0].AddParagraph();
textRange = paragraph.AppendText("Примечания") as WTextRange; textRange.CharacterFormat.Bold = true;
paragraph = table[0, 2].AddParagraph();
textRange = paragraph.AppendText("Информация об отправлении") as WTextRange; textRange.CharacterFormat.Bold = true;
paragraph = table[13, 2].AddParagraph();
textRange = paragraph.AppendText("Подтверждение доставки") as WTextRange; textRange.CharacterFormat.Bold = true;
//Specifies the horizontal merge
table.ApplyHorizontalMerge(0, 0, 1);
table.ApplyHorizontalMerge(5, 0, 1);
table.ApplyHorizontalMerge(13, 0, 1);
table.ApplyHorizontalMerge(0, 2, 3);
table.ApplyHorizontalMerge(13, 2, 3);
//Appends paragraph.
section.AddParagraph();
//Saves the Word document to MemoryStream
MemoryStream stream = new MemoryStream();
document.Save(stream, FormatType.Docx);
stream.Position = 0;
string fileName = Guid.NewGuid() + ".docx";
//Download Word document in the browser
return(File(stream, "application/msword", fileName));
}
catch (Exception exp)
{
TempData["alertMessage"] = "Произошла ошибка при создании файла. Возможно не хватает информации об отправлении.";
return(RedirectToAction("Index"));
}
}
private void btnEkle_Click(object sender, EventArgs e)
{
ModelDBContainer db = new ModelDBContainer();
Kitap ktp = new Kitap();
ktp.KitapAdi = txtKitapAdi.Text;
ktp.SayfaSayisi = int.Parse(txtSayfaSayisi.Text);
ktp.EklenmeTarihi = dtEklenmeTarihi.Value;
bool yazarVarMi = db.YazarSet.Where(y => y.YazarAdi == txtYazarAdi.Text && y.YazarSoyadi == txtYazarSoyadi.Text).ToList().Count > 0;
if (yazarVarMi)
{
ktp.YazarId = db.YazarSet.Where(y => y.YazarAdi == txtYazarAdi.Text && y.YazarSoyadi == txtYazarSoyadi.Text).FirstOrDefault().Id;
}
else
{
var yzr = new Yazar();
yzr.YazarAdi = txtYazarAdi.Text;
yzr.YazarSoyadi = txtYazarSoyadi.Text;
db.YazarSet.Add(yzr);
ktp.YazarId = yzr.Id;
}
bool yEviVarMi = db.YayinEviSet.Where(y => y.YayinEviAdi == txtYayinEvi.Text).ToList().Count > 0;
if (yEviVarMi)
{
ktp.YayinEviId = db.YayinEviSet.Where(y => y.YayinEviAdi == txtYayinEvi.Text).FirstOrDefault().Id;
}
else
{
var yEv = new YayinEvi();
yEv.YayinEviAdi = txtYayinEvi.Text;
db.YayinEviSet.Add(yEv);
ktp.YayinEviId = yEv.Id;
}
bool ktgVarmi = db.KategoriSet.Where(k => k.KategoriAdi == txtKategori.Text).ToList().Count > 0;
if (ktgVarmi)
{
ktp.KategoriId = db.KategoriSet.Where(k => k.KategoriAdi == txtKategori.Text).FirstOrDefault().Id;
}
else
{
var ktg = new Kategori();
ktg.KategoriAdi = txtKategori.Text;
db.KategoriSet.Add(ktg);
ktp.KategoriId = ktg.Id;
}
Tasnif tsnf = new Tasnif();
ktp.TasnifNo = tsnf.Tasnifle(txtKitapAdi.Text);
db.KitapSet.Add(ktp);
db.SaveChanges();
}
