public bool AddMakale(int yazarid, int kategoriid, string baslik, string icerik) { Makale member = new Makale(); member.YazarID = yazarid; member.KategoriID = kategoriid; member.Baslık = baslik; member.Icerik = icerik; bool result = false; try { HaberDBEntities1 db = new HaberDBEntities1(); db.Makale.Add(member); db.SaveChanges(); result = true; } catch (Exception) { return(result); } return(result); }
public bool AddMember(string ad, string soyad, string email, string kullaniciadi, string sifre) { Üye member = new Üye(); member.Ad = ad; member.Soyad = soyad; member.Email = email; member.KullaniciAdi = kullaniciadi; member.Sifre = sifre; bool result = false; try { if (ad != "" && soyad != "" && email != "" && kullaniciadi != "" && sifre != "") { HaberDBEntities1 db = new HaberDBEntities1(); db.Üye.Add(member); db.SaveChanges(); result = true; } } catch (Exception) { return(result); } return(result); }
public bool AddYazar(string yazaradi) { Yazar member = new Yazar(); member.YazarAdi = yazaradi; bool result = false; try { HaberDBEntities1 db = new HaberDBEntities1(); db.Yazar.Add(member); db.SaveChanges(); result = true; } catch (Exception) { return(result); } return(result); }
public bool AddKategori(string kategoriadi) { Kategori member = new Kategori(); member.KategoriAdi = kategoriadi; bool result = false; try { HaberDBEntities1 db = new HaberDBEntities1(); db.Kategori.Add(member); db.SaveChanges(); result = true; } catch (Exception e) { return(result); } return(result); }
public bool MemberDogrula(string kullaniciadi, string sifre) { Üye member = new Üye(); member.KullaniciAdi = kullaniciadi; member.Sifre = sifre; bool result = false; try { HaberDBEntities1 db = new HaberDBEntities1(); string query = String.Format("SELECT COUNT(*) FROM Üye WHERE KullaniciAdi Like '%" + kullaniciadi + "%' AND Sifre Like '%" + sifre + "%' "); SqlConnection con = new SqlConnection("workstation id=HaberDB.mssql.somee.com;packet size=4096;user id=senanurkiraz_SQLLogin_1;pwd=njas7u5ikz;data source=HaberDB.mssql.somee.com;persist security info=False;initial catalog=HaberDB"); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = query; con.Open(); Int32 dr = Convert.ToInt32(cmd.ExecuteScalar()); if (dr == 0) { result = false; } else { result = true; } } catch (Exception) { return(result); } return(result); }
public List <Üye> GetMembers() { HaberDBEntities1 db = new HaberDBEntities1(); return(db.Üye.ToList()); }