public void Update(UserRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var user = db.User.Find(request.Id);
try
{
user.Lastname = request.Lastname;
user.Firstname = request.Firstname;
user.Email = request.Email;
user.IdRole = request.IdRole;
user.Phonenumber = request.Phonenumber;
if (request.IdRole != 1)
{
user.IdDwelling = request.IdDwelling;
user.Tenure = request.Tenure;
if (request.IdOptinalRole > 0)
{
user.IdOptionalRole = request.IdOptinalRole;
}
}
db.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public List <UserResponse> Get()
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
try
{
var userList = db.User.Where(x => x.Active == true).ToList();
var dwelllingListFiltered = userList.ConvertAll(x => new UserResponse(x.Id, x.Username, x.Lastname, x.Firstname,
x.Phonenumber, x.Email, x.IdRole, x.Tenure, x.IdResidentialComplex, x.IdOptionalRole, x.IdDwelling));
return(dwelllingListFiltered);
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Delete(DwellingRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var dwelling = db.Dwelling.Find(request.Id);
try
{
dwelling.Active = false;
db.Entry(dwelling).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public List <DwellingResponse> Get()
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
try
{
var dwelllingList = db.Dwelling.Where(x => x.Active == true).ToList();
//var residentialComplexListFiltered = residentialComplexList.Select(x => new ResidentialComplexRequest(x.Id, x.Name, x.Address, x.Phonenumber)).ToList();
var dwelllingListFiltered = dwelllingList.ConvertAll(x => new DwellingResponse(x.Id, x.Name, x.IdBuilding));
return(dwelllingListFiltered);
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Update(BuildingRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var building = db.Building.Find(request.Id);
try
{
building.Name = request.Name;
db.Entry(building).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Delete(ResidentialComplexRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var residentialComplex = db.ResidentialComplex.Find(request.Id);
try
{
residentialComplex.Active = false;
db.Entry(residentialComplex).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public List <ResidentialComplexResponse> Get()
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
try
{
var residentialComplexList = db.ResidentialComplex.ToList();
//var residentialComplexListFiltered = residentialComplexList.Select(x => new ResidentialComplexRequest(x.Id, x.Name, x.Address, x.Phonenumber)).ToList();
var residentialComplexListFiltered = residentialComplexList.ConvertAll(x => new ResidentialComplexResponse(x.Id, x.Name, x.Address, x.Phonenumber));
return(residentialComplexListFiltered);
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Add(DwellingRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var dwelling = new Dwelling();
try
{
dwelling.IdBuilding = request.IdBuilding;
dwelling.Name = request.Name;
db.Dwelling.Add(dwelling);
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Add(BuildingRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var building = new Building();
try
{
building.IdResidentialComplex = request.IdResidentialComplex;
building.Name = request.Name;
db.Building.Add(building);
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Update(ResidentialComplexRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var residentialComplex = db.ResidentialComplex.Find(request.Id);
try
{
residentialComplex.Address = request.Address;
residentialComplex.Name = request.Name;
residentialComplex.Phonenumber = request.Phonenumber;
db.Entry(residentialComplex).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Add(ResidentialComplexRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var residentialComplex = new ResidentialComplex();
try
{
residentialComplex.Address = request.Address;
residentialComplex.Name = request.Name;
residentialComplex.Phonenumber = request.Phonenumber;
db.ResidentialComplex.Add(residentialComplex);
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
public void Add(UserRequest request)
{
using (MultifamilyPropertyContext db = new MultifamilyPropertyContext())
{
var user = new User();
try
{
user.Username = request.Username;
user.Lastname = request.Lastname;
user.Firstname = request.Firstname;
user.Email = request.Email;
user.IdResidentialComplex = request.IdResidentialComplex;
user.IdRole = request.IdRole;
user.Password = request.Password;
user.Phonenumber = request.Phonenumber;
if (request.IdRole != 1)
{
user.IdDwelling = request.IdDwelling;
user.Tenure = request.Tenure;
if (request.IdOptinalRole > 0)
{
user.IdOptionalRole = request.IdOptinalRole;
}
}
db.User.Add(user);
db.SaveChanges();
}
catch (Exception err)
{
throw new Exception(err.Message);
}
}
}
