//Listeleme fonksiyonu
public List <MathematicalBooks> GetAllMathematicalBooks()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.MathematicalBooks.ToList());
}
}
//Listeleme fonksiyonunu yazalım :
public List <CollegeStudents> GetAllCollegeStudents()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.CollegeStudents.ToList());
}
}
//Listeleme fonksiyonu
public List <LiteratureBooks> GetAllLiteratureBooks()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.LiteratureBooks.ToList());
}
}
public List <OrderList> GetAllOrderLists()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.OrderList.ToList());
}
}
//Listeleme işlemi için fonksiyonu yazalım
public List <Academicians> GetAllAcademicians()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.Academicians.ToList());
}
}
//Listeleme fonksiyonunu yazalım :
public List <ForeignMembers> GetAllForeignMembers()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.ForeignMembers.ToList());
}
}
//ürünleri listelemek için gerekli olan kodu yazalım.
public List <GeneralMembers> GetAllGeneralMembers()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.GeneralMembers.ToList());
}
}
//Listeleme fonksiyonunu yazalım.
public List <Researchers> GetAllResearchers()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.Researchers.ToList());
}
}
//Listeleme fonksiyonu
public List <SocialBooks> GetAllSocialBooks()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.SocialBooks.ToList());
}
}
//listeleme
public List <Newspapers> GetAllNewspapers()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.Newspapers.ToList());
}
}
//Listeleme fonksiyonu
public List <Journals> GetAllJournals()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.Journals.ToList());
}
}
//Listeleme fonksiyonu
public List <Teachers> GetAllTeachers()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.Teachers.ToList());
}
}
//Listeleme fonksiyonu
public List <EnglishBooks> GetAllEnglishBooks()
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
return(context.EnglishBooks.ToList());
}
}
//Silme işlemini gerçekleştirecek kodu yazalım :
public void Delete(GeneralMembers generalMembers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(generalMembers);
entity.State = EntityState.Deleted; //Sil
context.SaveChanges(); //Değişiklikleri kaydet
}
}
//silme
public void Delete(Newspapers newspapers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(newspapers);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Silme işlemini yapacak fonksiyonu yazalım :
public void Delete(Academicians academicians)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(academicians);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Güncelleme fonksiyonu :
public void Update(Teachers teachers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(teachers);
entity.State = EntityState.Modified;
context.SaveChanges();
}
}
//Güncelleme fonksiyonu
public void Update(EnglishBooks englishBooks)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(englishBooks);
entity.State = EntityState.Modified;
context.SaveChanges();
}
}
//Silme fonksiyonunu yazalım :
public void Delete(ForeignMembers foreignMembers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(foreignMembers);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Delete(OrderList orderList)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(orderList);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Güncelleme fonksiyonu :
public void Update(MathematicalBooks mathematicalBooks)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(mathematicalBooks);
entity.State = EntityState.Modified;
context.SaveChanges();
}
}
//silme
public void Delete(Journals journals)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(journals);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Silme fonksiyonunu yazalım :
public void Delete(CollegeStudents collegeStudents)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(collegeStudents);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Silme fonksiyonunu yazalım
public void Delete(Researchers researchers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(researchers);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Silme fonksiyonu
public void Delete(LiteratureBooks literatureBooks)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(literatureBooks);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Silme fonksiyonu
public void Delete(SocialBooks socialBooks)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(socialBooks);
entity.State = EntityState.Deleted;
context.SaveChanges();
}
}
//Ekleme fonksiyonunu yazalım :
public void Add(ForeignMembers foreignMembers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
//context.ForeignMembers.Add(foreignMembers);
//context.SaveChanges();
var entity = context.Entry(foreignMembers);
entity.State = EntityState.Added;
context.SaveChanges();
}
}
//Ekleme fonksiyonunu yazalım
public void Add(Researchers researchers)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
context.Researchers.Add(researchers);
context.SaveChanges();
//var entity = context.Entry(researchers);
//entity.State = EntityState.Added;
//context.SaveChanges();
}
}
//Ekleme fonksiyonu
public void Add(GeneralBooks generalBooks)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
var entity = context.Entry(generalBooks);
entity.State = EntityState.Added;
context.SaveChanges();
//context.GeneralBooks.Add(generalBooks);
//context.SaveChanges();
}
}
//Ekleme fonksiyounu yazalım
public void Add(CollegeStudents collegeStudents)
{
using (InstituteDbEntities context = new InstituteDbEntities())
{
context.CollegeStudents.Add(collegeStudents);
context.SaveChanges();
//var entity = context.Entry(collegeStudents);
//entity.State = EntityState.Added;
//context.SaveChanges();
}
}
