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