public async Task <int> UpdateMissionPhoto(PhotoUpdateDto updateObject, int photoId, string code)
{
var photo2bUpdated = await _context.MissionPhotos.FindAsync(photoId);
photo2bUpdated.Category = updateObject.Category;
photo2bUpdated.ImageCaption = updateObject.Caption;
photo2bUpdated.UploadedBy = code;
_context.MissionPhotos.Update(photo2bUpdated);
var numberAffected = await _context.SaveChangesAsync();
return(numberAffected);
}
public async Task <int> AddEvent(EventObj eventObj)
{
var evtObj = await _context.EventItems.AddAsync(eventObj);
if (evtObj == null)
{
throw new Exception("The Event was not created.");
}
var numberAffected = await _context.SaveChangesAsync();
return(numberAffected);
}
public async Task <bool> RateVideo(RatingsDto ratingsObject)
{
var video = await _context.MissionVideos.FindAsync(ratingsObject.VideoId);
video.RatingsCount += 1;
video.Rating = ratingsObject.Rating / video.RatingsCount;
_context.Update(video);
var numbr = await _context.SaveChangesAsync();
if (numbr.Equals(0))
{
return(false);
}
return(true);
}
public async Task <int> Add(MissionPhoto photo)
{
_context.Add(photo);
var confrm = await _context.SaveChangesAsync();
return(confrm);
}
public async Task <int> EditAnFaq(Faq changedFaq)
{
var faq = await _context.FaqItems.FirstOrDefaultAsync(f => f.FaqId == changedFaq.FaqId);
if (faq != null)
{
faq.FaqAnswer = changedFaq.FaqAnswer;
faq.FaqQuestion = changedFaq.FaqQuestion;
_context.FaqItems.Update(faq);
var numEdited = await _context.SaveChangesAsync();
return(numEdited);
}
return(0);
}
public async Task <int> DeleteUser(string email)
{
var user2Delete = _userManager.Users.FirstOrDefault(u => u.Email == email);
if (user2Delete == null)
{
throw new Exception("No such user found");
}
_context.Users.Remove(user2Delete);
var num = await _context.SaveChangesAsync();
return(num);
}
public async Task <int> AddContribution(ContributionsPostDto contributionsObj)
{
var recordExists = await _context.Subscriptions
.AnyAsync(s => s.Name == contributionsObj.Month && s.Year == contributionsObj.Year && s.UserId == contributionsObj.UserId);
if (recordExists == true)
{
throw new Exception("The contribution exists already.");
}
// Get the current year so as to filter only for current year
var currentYear = DateTime.Now.ToString("yyyy");
var memberTotal = await _context.Subscriptions
.Where(s => s.Year == contributionsObj.Year && s.UserId == contributionsObj.UserId)
.SumAsync(s => s.Amount);
var newSubscription = new Subscription();
newSubscription.Name = contributionsObj.Month;
newSubscription.Amount = contributionsObj.Amount;
newSubscription.DateEntered = contributionsObj.DateEntered;
newSubscription.UserId = contributionsObj.UserId;
newSubscription.Year = contributionsObj.Year;
newSubscription.Total = memberTotal + contributionsObj.Amount;
bool includeThisMonth = true;
if ((int)System.DateTime.Now.DayOfWeek < 15)
{
includeThisMonth = false;
}
newSubscription.UptoDate = await checkContributionStatus(contributionsObj.UserId, newSubscription.Total, includeThisMonth);
if (!String.IsNullOrWhiteSpace(contributionsObj.Comment))
{
newSubscription.Comment = contributionsObj.Comment;
}
await _context.Subscriptions.AddAsync(newSubscription);
var res = await _context.SaveChangesAsync();
if (!res.Equals(1))
{
throw new Exception("No record was added for a new contribution");
}
return(res);
}
