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