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);
}
}