public async Task <List <Campaign> > GetCampaignsAsync(Guid CampaignManagedByID)
{
using (var db = new DonorsDBContext())
{
return(await db.Campaigns.Where(x => x.ManagedByID == CampaignManagedByID).ToListAsync());
}
}
public async Task <List <Donation> > GetDonationListAsync()
{
using (var db = new DonorsDBContext())
{
return(await db.Donations.ToListAsync());
}
}
public async Task <Campaign> GetCampaignProfileAsync(Guid CampaignID)
{
using (var db = new DonorsDBContext())
{
return(await db.Campaigns.FirstOrDefaultAsync(x => x.CampaignID == CampaignID));
}
}
public async Task <Donation> GetDonationAsync(Guid DonationID)
{
using (var db = new DonorsDBContext())
{
return(await db.Donations.FirstOrDefaultAsync(x => x.DonationID == DonationID));
}
}
public async Task <List <Campaign> > GetCampaignsAsync()
{
using (var db = new DonorsDBContext())
{
return(await db.Campaigns.ToListAsync());
}
}
public async Task <User> GetUserAsync(Guid UserID)
{
using (var db = new DonorsDBContext())
{
return(await db.Users.Include(x => x.Person).Include(x => x.Person.Contacts).Include(x => x.Person.Addresses).FirstOrDefaultAsync(x => x.UserID == UserID));
}
}
public async Task <List <Donation> > GetDonationsVerifiedAsync(bool IsVerified)
{
using (var db = new DonorsDBContext())
{
return(await db.Donations.Where(x => x.IsVerified == IsVerified).ToListAsync());
}
}
public async Task <List <User> > GetUsersAsync(UserRole UserRole)
{
using (var db = new DonorsDBContext())
{
return(await db.Users.Include(x => x.Person).Where(x => x.IsActive && x.UserRole == (short)UserRole).ToListAsync());
}
}
public async Task <List <Donor> > GetDonorsAsync()
{
using (var db = new DonorsDBContext())
{
return(await db.Donors.Where(x => !x.Person.IsDeleted).ToListAsync());
}
}
public async Task <List <Donation> > GetDonationListAsync(DonationMethod DonationMethod)
{
using (var db = new DonorsDBContext())
{
return(await db.Donations.Where(x => x.DonationMethod == (short)DonationMethod).ToListAsync());
}
}
public async Task <List <Donation> > GetDonationListAsync(Guid DonorID)
{
using (var db = new DonorsDBContext())
{
return(await db.Donations.Where(x => x.DonorID == DonorID).ToListAsync());
}
}
public async Task <int> CreateDonorProfileAsync(Donor Donor)
{
using (var db = new DonorsDBContext())
{
await db.Donors.AddAsync(Donor);
return(await db.SaveChangesAsync());
}
}
public async Task <int> CreateCampaignProfileAsync(Campaign Campaign)
{
using (var db = new DonorsDBContext())
{
await db.Campaigns.AddAsync(Campaign);
return(await db.SaveChangesAsync());
}
}
public async Task <int> CreateUserAsync(User User)
{
using (var db = new DonorsDBContext())
{
await db.Users.AddAsync(User);
return(await db.SaveChangesAsync());
}
}
public async Task <int> AddDonationAsync(Donation Donation)
{
using (var db = new DonorsDBContext())
{
await db.Donations.AddAsync(Donation);
return(await db.SaveChangesAsync());
}
}
public async Task <int> UpdateDonorProfileAsync(Donor Donor)
{
using (var db = new DonorsDBContext())
{
var _donor = db.Donors.FirstOrDefaultAsync(x => x.DonorID == Donor.DonorID);
if (_donor != null)
{
db.Donors.Update(Donor);
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> UpdateDonationAsync(Donation Donation)
{
using (var db = new DonorsDBContext())
{
var _donation = db.Donations.FirstOrDefaultAsync(x => x.DonationID == Donation.DonationID);
if (_donation != null)
{
db.Donations.Update(Donation);
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> DeleteDonorProfileAsync(Guid DonorID)
{
using (var db = new DonorsDBContext())
{
var _donor = await db.Donors.Include(x => x.Person).FirstOrDefaultAsync(x => x.DonorID == DonorID);
if (_donor != null)
{
_donor.Person.IsDeleted = true;
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> DeleteDonationAsync(Guid DonationID)
{
using (var db = new DonorsDBContext())
{
var _donation = await db.Donations.FirstOrDefaultAsync(x => x.DonationID == DonationID);
if (_donation != null)
{
db.Donations.Remove(_donation);
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> DeleteCampaignProfileAsync(Guid CampaignID)
{
using (var db = new DonorsDBContext())
{
var _campaign = await db.Campaigns.FirstOrDefaultAsync(x => x.CampaignID == CampaignID);
if (_campaign != null)
{
db.Campaigns.Remove(_campaign);
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> DeleteUserAsync(Guid UserID)
{
using (var db = new DonorsDBContext())
{
var _user = await db.Users.Include(x => x.Person).FirstOrDefaultAsync(x => x.UserID == UserID);
if (_user != null)
{
_user.Person.IsDeleted = true;
_user.IsActive = false;
_user.DateUpdated = DateTime.Now.ToUniversalTime();
return(await db.SaveChangesAsync());
}
}
return(0);
}
public async Task <int> UpdateUserAsync(User User)
{
using (var db = new DonorsDBContext())
{
var _user = await db.Users.Include(x => x.Person).Include(x => x.Person.Contacts).Include(x => x.Person.Addresses).FirstOrDefaultAsync(x => x.UserID == User.UserID);
if (_user != null)
{
_user.UserName = User.UserName;
_user.Person.FirstName = User.Person.FirstName;
_user.Person.MiddleName = User.Person.MiddleName;
_user.Person.Gender = User.Person.Gender;
_user.Person.DOB = User.Person.DOB;
_user.Person.DisplayName = User.Person.DisplayName;
db.Users.Update(_user);
var _cont = await db.Contacts.FirstOrDefaultAsync(x => x.PersonID == User.PersonID);
if (_cont != null)
{
var __cont = User.Person.Contacts.FirstOrDefault();
_cont.Phone = __cont.Phone;
_cont.Email = __cont.Email;
db.Contacts.Update(_cont);
}
var _addr = await db.Addresses.FirstOrDefaultAsync(x => x.PersonID == User.PersonID);
if (_addr != null)
{
var __addr = User.Person.Addresses.FirstOrDefault();
_addr.Address1 = __addr.Address1;
_addr.Address2 = __addr.Address2;
_addr.City = __addr.City;
_addr.State = __addr.State;
_addr.ZIPCode = __addr.ZIPCode;
db.Addresses.Update(_addr);
}
return(await db.SaveChangesAsync());
}
}
return(0);
}
