public static void addNewPersonBase(PersonBase p)
{
using (var ctx = new PersonContext())
{
ctx.PersonBases.Add(p);
ctx.SaveChanges();
}
}
public static PersonBase findFirstByList(ICollection <String> list)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.list == list)
.FirstOrDefault <PersonBase>();
p = query;
}
return(p);
}
public static PersonBase findFirstByGender(Boolean gender)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.gender == gender)
.FirstOrDefault <PersonBase>();
p = query;
}
return(p);
}
public static PersonBase findFirstByAge(Int32 age)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.age == age)
.FirstOrDefault <PersonBase>();
p = query;
}
return(p);
}
public static PersonBase findFirstByAddress(String address)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.address == address)
.FirstOrDefault <PersonBase>();
p = query;
}
return(p);
}
public static PersonBase findFirstByName(String name)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.name == name)
.FirstOrDefault <PersonBase>();
p = query;
}
return(p);
}
public Boolean existsInPersonBaseByList(ICollection <String> list)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.list == list)
.FirstOrDefault <PersonBase>();
p = query;
}
if (p != null)
{
return(true);
}
else
{
return(false);
}
}
public Boolean existsInPersonBaseByGender(Boolean gender)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.gender == gender)
.FirstOrDefault <PersonBase>();
p = query;
}
if (p != null)
{
return(true);
}
else
{
return(false);
}
}
public Boolean existsInPersonBaseByAge(Int32 age)
{
PersonBase p = null;
using (var ctx = new PersonContext())
{
var query = ctx.PersonBases
.Where(s => s.age == age)
.FirstOrDefault <PersonBase>();
p = query;
}
if (p != null)
{
return(true);
}
else
{
return(false);
}
}
