public ActionResult PersonelEkle(TBLPERSONEL p)
{
if (!ModelState.IsValid)
{
return(View("PersonelEkle"));
}
db.TBLPERSONEL.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult UyeEkle(TBLUYELER p)
{
if (!ModelState.IsValid)
{
return(View("UyeEkle"));
}
db.TBLUYELER.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult KitapEkle(TBLKITAP p)
{
var kategori = db.TBLKATEGORI.Where(k => k.ID == p.TBLKATEGORI.ID).FirstOrDefault();
var yazar = db.TBLYAZAR.Where(k => k.ID == p.TBLYAZAR.ID).FirstOrDefault();
p.TBLKATEGORI = kategori;
p.TBLYAZAR = yazar;
db.TBLKITAP.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult YazarEkle(TBLYAZAR p)
{
if (!ModelState.IsValid)
{
return(View("YazarEkle"));
}
else
{
db.TBLYAZAR.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult Oduncver(TBLHAREKET p)
{
var d1 = dbkutuphane.TBLUYELER.Where(x => x.ID == p.TBLUYELER.ID).FirstOrDefault();
var d2 = dbkutuphane.TBLKITAP.Where(y => y.ID == p.TBLKITAP.ID).FirstOrDefault();
var d3 = dbkutuphane.TBLPERSONEL.Where(z => z.ID == p.TBLPERSONEL.ID).FirstOrDefault();
p.TBLUYELER = d1;
p.TBLKITAP = d2;
p.TBLPERSONEL = d3;
dbkutuphane.TBLHAREKET.Add(p);
dbkutuphane.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult YeniMesaj(TBLMESAJLAR t)
{
var uyemail = (string)Session["Mail"];
t.GONDEREN = uyemail;
_dbkutuphaneEntities2.TBLMESAJLAR.Add(t);
t.TARIH = DateTime.Parse(DateTime.Now.ToLongDateString());
_dbkutuphaneEntities2.SaveChanges();
return(RedirectToAction("Giden"));
}
public ActionResult Kayit(TBLUYELER p)
{
if (!ModelState.IsValid)
{
return(View("Kayit"));
}
db.TBLUYELER.Add(p);
db.SaveChanges();
return(View());
}
public ActionResult Index2(TBLUYELER p)
{
var kullanici = (string)Session["Mail"];
var uye = dbkutuphaneEntities2.TBLUYELER.FirstOrDefault(x => x.MAIL == kullanici);
uye.SIFRE = p.SIFRE;
uye.AD = p.AD;
uye.FOTOGRAF = p.FOTOGRAF;
uye.OKUL = p.OKUL;
uye.KULLANICIADI = p.KULLANICIADI;
dbkutuphaneEntities2.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult KategoriEkle(TBLKATEGORI p)
{
db.TBLKATEGORI.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult YeniDuyuru(TBLDUYURULAR t)
{
_dbkutuphaneEntities2.TBLDUYURULAR.Add(t);
_dbkutuphaneEntities2.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Index(TBLILETISIM t)
{
dBKUTUPHANE.TBLILETISIM.Add(t);
dBKUTUPHANE.SaveChanges();
return(RedirectToAction("Index"));
}