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 IEnumerable <Member> GetActiveMembers()
{
using (var db = new GardenCommunityContext())
{
return(db.Members.Where(x => x.IsActiveMember == true).ToList() ?? new List <Member>());
}
}
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 Role GetRole(string name)
{
using (var db = new GardenCommunityContext())
{
return(db.Roles.First(x => x.Name == name));
}
}
public Role GetRole(int id)
{
using (var db = new GardenCommunityContext())
{
return(db.Roles.First(x => x.Id == id));
}
}
public IEnumerable <Role> GetRoles()
{
using (var db = new GardenCommunityContext())
{
return(db.Roles.ToList() ?? new List <Role>());
}
}
public IEnumerable <User> GetUsers()
{
using (var db = new GardenCommunityContext())
{
return(db.Users.Include(x => x.Role).ToList() ?? new List <User>());
}
}
public User GetUser(int id)
{
using (var db = new GardenCommunityContext())
{
return(db.Users.Include(x => x.Role).First(x => x.Id == id));
}
}
public Member GetMemberWithPayments(int id)
{
using (var db = new GardenCommunityContext())
{
var member = db.Members.Include(x => x.Payments).First(x => x.Id == id);
return(member);
}
}
public Rate GetRate(int id)
{
using (var db = new GardenCommunityContext())
{
var rate = db.Rates.First(x => x.Id == id);
return(rate);
}
}
public User GetUser(string userName, string password)
{
using (var db = new GardenCommunityContext())
{
return(db.Users
.Include(x => x.Role)
.FirstOrDefault(x => x.UserName == userName && x.Password == password));
}
}
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 Area GetArea(int id)
{
using (var db = new GardenCommunityContext())
{
var area = db.Areas.First(x => x.Id == id);
var membersAreas = db.MembersAreas.Include(x => x.Member).Where(x => x.AreaId == id).ToList() ?? new List <MembersAreas>();
area.MembersAreas = membersAreas;
return(area);
}
}
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 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 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 IEnumerable <Payment> GetPayments()
{
using (var db = new GardenCommunityContext())
{
var payments = db.Payments
.Include(x => x.Indication)
.Include(x => x.Member)
.Include(x => x.Rate).ToList() ?? new List <Payment>();
return(payments);
}
}
public IEnumerable <Rate> GetRates(DateTime beginDate, DateTime endDate)
{
using (var db = new GardenCommunityContext())
{
var rates = db.Rates
.Include(x => x.Payments)
.Where(x => x.Date >= beginDate && x.Date <= endDate)
.ToList() ?? new List <Rate>();
return(rates);
}
}
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 Member GetMember(int id)
{
using (var db = new GardenCommunityContext())
{
//? ??? db.MembersAreas.Include(x => x.Member).Include(x => x.Area).Where(x => x.MemberId == id).Select(x=>x.Member);
var member = db.Members.First(x => x.Id == id);
// db.Members.Include(x=>x.MembersAreas).ThenInclude(x=>x.)
member.MembersAreas = db.MembersAreas.Include(x => x.Area).Where(x => x.MemberId == id).ToList() ?? new List <MembersAreas>();
return(member);
}
}
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 Indication GetIndication(int id)
{
using (var db = new GardenCommunityContext())
{
var indication = db.Indications
.Include(x => x.Payment)
.ThenInclude(x => x.Member)
.First(x => x.Id == id);
return(indication);
}
}
public IEnumerable <Indication> GetIndications()
{
using (var db = new GardenCommunityContext())
{
var indications = db.Indications
.Include(x => x.Payment)
.ThenInclude(x => x.Member)
.ToList() ?? new List <Indication>();
return(indications);
}
}
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 Payment GetPayment(int id)
{
using (var db = new GardenCommunityContext())
{
var payment = db.Payments
.Include(x => x.Indication)
.Include(x => x.Member)
.Include(x => x.Rate)
.First(x => x.Id == id);
return(payment);
}
}
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 IEnumerable <Indication> GetIndicationsByMemberId(int id)
{
using (var db = new GardenCommunityContext())
{
var indications = new List <Indication>();
var member = db.Members.Include("Payments").Where(x => x.Id == id).First();
foreach (var payment in member.Payments)
{
indications.Add(payment.Indication);
}
return(indications);
}
}
public IEnumerable <Payment> GetPayments(DateTime beginDate, DateTime endDate)
{
using (var db = new GardenCommunityContext())
{
var payments = db.Payments
.Include(x => x.Indication)
.Include(x => x.Member)
.Include(x => x.Rate)
.Where(x => x.DateOfPayment >= beginDate && x.DateOfPayment <= endDate)
.ToList() ?? new List <Payment>();
return(payments);
}
}
public IEnumerable <Area> GetAreas()
{
using (var db = new GardenCommunityContext())
{
var areas = db.Areas.ToList();
//var membersAreas = db.MembersAreas.Include("Area").Include("Member").Select(x => x.Area).ToList();
foreach (var area in areas)
{
area.MembersAreas = db.MembersAreas.Include(x => x.Member).Where(x => x.AreaId == area.Id).ToList();
}
return(areas);
}
}
