public List<SecurityDepartmentDetail> GetDepartments()
{
using (var context = new SecurityDepartmentEntities())
{
var depts = context.SecurityDepartmentDetails.ToList();
return depts;
}
}
public long AddNewSecurityPersonel(SecurityPersonnelDetail securityPerson)
{
using (var context = new SecurityDepartmentEntities())
{
context.SecurityPersonnelDetails.Add(securityPerson);
context.SaveChanges();
return securityPerson.SecurityPersonnelID;
}
}
public SecurityPersonnelDetail GetSecurityDetails(long id)
{
using (var context = new SecurityDepartmentEntities())
{
var details = context.SecurityPersonnelDetails.SingleOrDefault(x=>x.SecurityPersonnelID==id);
if (details == null) return null;
details.SecurityDepartmentDetail =
context.SecurityDepartmentDetails.FirstOrDefault(x => x.SecurityDepartmentID == details.SecurityDepartmentID);
return details;
}
}