public static int PersonCount(int typeId)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
return(db.Persons.Where(p => p.PersonTypeId == typeId).ToList().Count);
}
}
public static List <Person> GetAll()
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
return(db.Persons.ToList());
}
}
public static void Add(Person person)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
db.Persons.Add(person);
db.SaveChanges();
}
}
public static Admin AdminValid(Admin admin)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
return(db.Admins.FirstOrDefault
(a => a.NickName == admin.NickName && a.Password == admin.Password));
}
}
public static void Delete(int personId)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
var result = db.Persons.FirstOrDefault(p => p.Id == personId);
db.Persons.Remove(result);
db.SaveChanges();
}
}
public static List <PersonVM> GetAllPersonVM(int id)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
return(db.Persons.Where(u => u.PersonTypeId == id).Select(p => new PersonVM
{
Email = p.Email,
Fname = p.Fname,
Lname = p.Lname,
Phone = p.Phone,
PersonTypeName = p.PersonType.Name
}).ToList());
}
}
public static bool Add(PersonType pt)
{
using (UyeKayitEntities db = new UyeKayitEntities())
{
var result = db.PersonTypes.FirstOrDefault(p => p.Name.ToLower() == pt.Name.ToLower());
if (result == null)
{
db.PersonTypes.Add(pt);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
