public int UpdateMember(Member member, IEnumerable <int> areasForRemove) { this.member = member ?? throw new ArgumentNullException("member"); using (var db = new GardenCommunityContext()) { var updatableMember = db.Members.Include("MembersAreas").First(x => x.Id == member.Id); updatableMember.FirstName = member.FirstName; updatableMember.LastName = member.LastName; updatableMember.MiddleName = member.MiddleName; updatableMember.Address = member.Address; updatableMember.Phone = member.Phone; updatableMember.IsActiveMember = member.IsActiveMember; if (areasForRemove != null) { var gardenCommunity = db.Members.Include("MembersAreas").First(x => x.Id == gardenCommunityId); foreach (var id in areasForRemove) { var memberArea = db.MembersAreas.First(x => x.AreaId == id); gardenCommunity.MembersAreas.Add(new MembersAreas() { Area = memberArea.Area, Member = gardenCommunity, AreaId = memberArea.AreaId, MemberId = gardenCommunity.Id }); } } db.SaveChanges(); return(member.Id); } }
public int UpdateArea(Area area, int memberId) { var Area = area ?? throw new ArgumentNullException("area"); using (var db = new GardenCommunityContext()) { var updatableArea = db.Areas.First(x => x.Id == area.Id); updatableArea.Square = area.Square; updatableArea.IsPrivate = area.IsPrivate; updatableArea.HasElectricity = area.HasElectricity; updatableArea.ParentAreaId = area.ParentAreaId; if (memberId != 0) { var member = db.Members.First(x => x.Id == memberId); db.Members.Attach(member); db.MembersAreas.Add(new MembersAreas() { Member = member, MemberId = member.Id, Area = area, AreaId = area.Id, OwnedFrom = DateTime.Now }); } db.SaveChanges(); } return(area.Id); }
public int RemoveUser(int id) { using (var db = new GardenCommunityContext()) { var user = db.Users.First(x => x.Id == id); db.Users.Remove(user); db.SaveChanges(); return(user.Id); } }
public int RemoveIndication(int id) { using (var db = new GardenCommunityContext()) { var indication = db.Indications.First(x => x.Id == id); db.Indications.Remove(indication); db.SaveChanges(); return(indication.Id); } }
public int RemoveRole(int id) { using (var db = new GardenCommunityContext()) { var role = db.Roles.First(x => x.Id == id); db.Roles.Remove(role); db.SaveChanges(); return(role.Id); } }
public int AddMember(Member member) { this.member = member ?? throw new ArgumentNullException("member"); using (var db = new GardenCommunityContext()) { db.Members.Add(this.member); db.SaveChanges(); } return(member.Id); }
public int RemoveArea(int id) { using (var db = new GardenCommunityContext()) { var area = db.Areas.First(x => x.Id == id); db.Areas.Remove(area); db.SaveChanges(); return(area.Id); } }
public int AddRate(Rate rate) { var Rate = rate ?? throw new ArgumentNullException("rate"); using (var db = new GardenCommunityContext()) { db.Rates.Add(rate); db.SaveChanges(); return(rate.Id); } }
public int AddIndication(Indication indication) { var Indication = indication ?? throw new ArgumentNullException("indication"); using (var db = new GardenCommunityContext()) { db.Indications.Add(indication); db.SaveChanges(); } return(indication.Id); }
public int EditRole(Role role) { var Role = role ?? throw new ArgumentNullException("role"); using (var db = new GardenCommunityContext()) { var updatableRole = db.Roles.First(x => x.Id == role.Id); updatableRole.Name = role.Name; db.SaveChanges(); return(role.Id); } }
public int RemovePayment(int id) { using (var db = new GardenCommunityContext()) { var payment = db.Payments.Include(x => x.Indication).First(x => x.Id == id); var indication = db.Indications.First(x => x.Payment.Id == id); db.Indications.Remove(indication); db.Payments.Remove(payment); db.SaveChanges(); return(payment.Id); } }
public int EditUser(User user) { var User = user ?? throw new ArgumentNullException("user"); using (var db = new GardenCommunityContext()) { var updatatableUser = db.Users.First(x => x.Id == user.Id); updatatableUser.UserName = user.UserName; updatatableUser.Password = user.Password; updatatableUser.RoleId = user.RoleId; db.SaveChanges(); return(user.Id); } }
public int AddPayment(Payment payment) { var Payment = payment ?? throw new ArgumentNullException("payment"); using (var db = new GardenCommunityContext()) { var member = db.Members.First(x => x.Id == payment.MemberId); db.Members.Attach(member); var rate = db.Rates.First(x => x.Id == payment.RateId); db.Rates.Attach(rate); db.Payments.Add(payment); db.SaveChanges(); return(payment.Id); } }
public int AddRole(Role role) { var Role = role ?? throw new ArgumentNullException("role"); using (var db = new GardenCommunityContext()) { var someRole = db.Roles.FirstOrDefault(x => x.Name == role.Name); if (someRole == null) { db.Roles.Add(role); db.SaveChanges(); return(role.Id); } return(0); } }
public int UpdateRate(Rate rate) { var Rate = rate ?? throw new ArgumentNullException("rate"); using (var db = new GardenCommunityContext()) { var updatableRate = db.Rates.First(x => x.Id == rate.Id); updatableRate.RateName = rate.RateName; updatableRate.RateValue = rate.RateValue; updatableRate.Date = rate.Date; updatableRate.BankCollectionPercent = rate.BankCollectionPercent; updatableRate.FinePercent = rate.FinePercent; db.SaveChanges(); return(updatableRate.Id); } }
public int AddArea(Area area) { var Area = area ?? throw new ArgumentNullException("area"); using (var db = new GardenCommunityContext()) { db.Areas.Add(area); foreach (var memberArea in area.MembersAreas) { db.Members.Attach(memberArea.Member); db.MembersAreas.Add(memberArea); } db.SaveChanges(); } return(area.Id); }
public int UpdateIndication(Indication indication) { var Indication = indication ?? throw new ArgumentNullException("indication"); using (var db = new GardenCommunityContext()) { var updatableIndication = db.Indications.First(x => x.Id == indication.Id); updatableIndication.CurrentIndication = indication.CurrentIndication; updatableIndication.LastIndication = indication.LastIndication; updatableIndication.Month = indication.Month; updatableIndication.Year = indication.Year; updatableIndication.LoosesPercent = indication.LoosesPercent; updatableIndication.Payment = indication.Payment; db.SaveChanges(); return(indication.Id); } }
public int UpdatePayment(Payment payment) { var Payment = payment ?? throw new ArgumentNullException("payment"); using (var db = new GardenCommunityContext()) { var updatablePayment = db.Payments.First(x => x.Id == payment.Id); updatablePayment.DateOfPayment = payment.DateOfPayment; updatablePayment.RateId = payment.RateId; updatablePayment.MemberId = payment.MemberId; updatablePayment.PaidFor = payment.PaidFor; updatablePayment.ToPay = payment.ToPay; updatablePayment.Indication = payment.Indication; db.SaveChanges(); } return(payment.Id); }
public int AddUser(User user) { var User = user ?? throw new ArgumentNullException("user"); using (var db = new GardenCommunityContext()) { var someUser = db.Users .FirstOrDefault(x => x.UserName == user.UserName); if (someUser == null) { var role = db.Roles.First(x => x.Id == user.RoleId); db.Roles.Attach(role); db.Add(user); db.SaveChanges(); } return(user.Id); } }
public int RemoveMember(int id) { using (var db = new GardenCommunityContext()) { var gardenCommunity = db.Members.Include("MembersAreas").First(x => x.Id == gardenCommunityId); var member = db.Members.First(x => x.Id == id); member.IsActiveMember = false; foreach (var memberArea in member.MembersAreas) { gardenCommunity.MembersAreas.Add(new MembersAreas() { Member = gardenCommunity, MemberId = gardenCommunity.Id, Area = memberArea.Area, AreaId = memberArea.AreaId }); } db.SaveChanges(); return(member.Id); } }