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