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