public int AddRole(TatooineModel.Roles Rol)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         db.Roles.Add(Rol);
         db.SaveChanges();
         return Rol.Id;
     }
 }
 public long AddCitizen(TatooineModel.Citizens Citizen)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         db.Citizens.Add(Citizen);
         db.SaveChanges();
         return Citizen.Id;
     }
 }
 public bool DeleteCitizen(string CitizenID)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         var Citizen = db.Citizens.SingleOrDefault(p => p.Id == long.Parse(CitizenID));
         db.Citizens.Remove(Citizen);
         db.SaveChanges();
         return true;
     }
 }
 public bool UpdateRole(TatooineModel.Roles Rol)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         var RolBD = db.Roles.SingleOrDefault(p => p.Id == Rol.Id);
         RolBD.RoleName = Rol.RoleName;
         RolBD.ParentId = Rol.ParentId;
         db.SaveChanges();
         return true;
     }
 }
 public bool DeleteRole(string Id)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         int id = int.Parse(Id);
         var Rol = db.Roles.SingleOrDefault(p => p.Id == id);
         db.Roles.Remove(Rol);
         db.SaveChanges();
         return true;
     }
 }
 public bool UpdateCitizen(TatooineModel.Citizens Citizen)
 {
     using (var db = new TatooineCitizensRegistryEntities())
     {
         var CitizenDB = db.Citizens.SingleOrDefault(p => p.Id == Citizen.Id);
         CitizenDB.Name = Citizen.Name;
         CitizenDB.Specie = Citizen.Specie;
         CitizenDB.IdRole = Citizen.IdRole;
         CitizenDB.IdStatus = Citizen.IdStatus;
         db.SaveChanges();
         return true;
     }
 }