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