public Message GetMessageByUserType(int userId, Enum.MessageType type)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Messages.FirstOrDefault(m => m.UserId == userId && m.Type == (int)type));
}
}
public List <Donation> GetAllDonation()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Donations.ToList());
}
}
public User GetUser(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Users.Find(userId));
}
}
public List <ChallegeDay> GetChallengeDayByUser(int userId, int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.ChallegeDays.Where(c => c.UserId == userId && c.ChallengeId == challengeId).ToList());
}
}
public Challenge GetChallenge(int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Challenges.Include(c => c.User.Socials).Include(c => c.Donation).Include(cl => cl.ChallegeDays).Where(cl => cl.Id == challengeId).FirstOrDefault());
}
}
public List <Challenge> GetBatchActiveChallengeByPage(int pageIndex, int size)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Challenges.OrderBy(c => c.StartTime).Include(c => c.Donation).Include(cl => cl.ChallegeDays).Include(c => c.User.Socials).Where(c => c.isActive == true).Skip((pageIndex - 1) * size).Take(size).ToList());
}
}
public List <Challenge> GetAllActiveChallenge()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Challenges.Where(c => c.isActive == true).ToList());
}
}
public Message GetMessage(int messageId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Messages.Find(messageId));
}
}
public Message GetDefaultWasteMessage()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Messages.FirstOrDefault(m => m.ChallengeId == null && m.UserId == null && m.Type == (int)MessageType.Waste));
}
}
public List <Message> GetMessagesByChallegen(int challengId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return(entity.Messages.Where(m => m.ChallengeId == challengId).ToList());
}
}
public bool AddMessage(Message message)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Messages.Add(message);
entity.SaveChanges();
return(rs != null);
}
}
public bool AddChallengeDay(ChallegeDay challengeDay)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.ChallegeDays.Add(challengeDay);
entity.SaveChanges();
return(rs != null);
}
}
public bool AddDonation(Donation donation)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Donations.Add(donation);
entity.SaveChanges();
return(rs != null);
}
}
public bool AddUser(User user)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Users.Add(user);
entity.SaveChanges();
return rs != null;
}
}
public void CompletedChallenge(int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var completedChallenge = entity.Challenges.Find(challengeId);
completedChallenge.isActive = false;
entity.SaveChanges();
}
}
public bool AddDonation(Donation donation)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Donations.Add(donation);
entity.SaveChanges();
return rs != null;
}
}
public bool AddMessage(Message message)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Messages.Add(message);
entity.SaveChanges();
return rs != null;
}
}
public bool AddChallengeDay(ChallegeDay challengeDay)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.ChallegeDays.Add(challengeDay);
entity.SaveChanges();
return rs != null;
}
}
public void CompletedChallenge(int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var completedChallenge = entity.Challenges.Find(challengeId);
completedChallenge.isActive = false;
entity.SaveChanges();
}
}
public bool AddUser(User user)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var rs = entity.Users.Add(user);
entity.SaveChanges();
return(rs != null);
}
}
public User GetUserByClientId(string clientId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var social = entity.Socials.Include(s => s.User).FirstOrDefault(s => s.ClientId_.Equals(clientId));
if (social != null)
{
return(entity.Users.Include(u => u.Socials).FirstOrDefault(u => u.Id == social.UserId));
}
return(null);
}
}
public bool UpdateChallengeDay(ChallegeDay challengeDay)
{
using (var entity = new WakeOrWasteEntities())
{
var coreValue = entity.ChallegeDays.FirstOrDefault(c => c.Id == challengeDay.Id);
if (coreValue != null)
{
coreValue.IsProcessed = challengeDay.IsProcessed;
}
entity.SaveChanges();
return(true);
}
}
public bool RemoveMessage(int messageId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var message = entity.Messages.Find(messageId);
if (message != null)
{
var rs = entity.Messages.Remove(message);
entity.SaveChanges();
return(rs != null);
}
return(false);
}
}
public bool RemoveDonation(int donationId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var donation = entity.Donations.Find(donationId);
if (donation != null)
{
var rs = entity.Donations.Remove(donation);
entity.SaveChanges();
return(rs != null);
}
return(false);
}
}
public bool UpdateSocialToken(int socialId, string token)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var social = entity.Socials.Find(socialId);
if (social != null)
{
social.Token = token;
entity.SaveChanges();
return(true);
}
return(false);
}
}
public bool RemoveUser(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var user = entity.Users.Find(userId);
if (user != null)
{
var rs = entity.Users.Remove(user);
entity.SaveChanges();
return(rs != null);
}
return(false);
}
}
public bool UpdateUser(User user)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var userToUpdated = entity.Users.FirstOrDefault(u => u.Id == user.Id);
if (userToUpdated != null)
{
userToUpdated.Name = user.Name;
userToUpdated.ImageUrl = user.ImageUrl;
entity.SaveChanges();
return(true);
}
return(false);
}
}
public Challenge GetActiveChallengeByUserId(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var challenge = entity.Challenges.Include(cl => cl.ChallegeDays).Include(c => c.Donation).FirstOrDefault(c => c.UserId == userId && c.isActive == true);
//Remove the circle
if (challenge != null)
{
foreach (var item in challenge.ChallegeDays)
{
item.Challenge = null;
}
if (challenge.Donation != null)
{
challenge.Donation.Challenges = null;
}
}
return(challenge);
}
}
public User GetUser(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Users.Find(userId);
}
}
public bool RemoveUser(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var user = entity.Users.Find(userId);
if (user != null)
{
var rs = entity.Users.Remove(user);
entity.SaveChanges();
return rs != null;
}
return false;
}
}
public Challenge GetChallenge(int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Challenges.Include(c => c.User.Socials).Include(c => c.Donation).Include(cl => cl.ChallegeDays).Where(cl => cl.Id == challengeId).FirstOrDefault();
}
}
public List<ChallegeDay> GetChallengeDayByUser(int userId, int challengeId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.ChallegeDays.Where(c => c.UserId == userId && c.ChallengeId == challengeId).ToList();
}
}
public bool UpdateChallengeDay(ChallegeDay challengeDay)
{
using (var entity = new WakeOrWasteEntities())
{
var coreValue = entity.ChallegeDays.FirstOrDefault(c => c.Id == challengeDay.Id);
if (coreValue != null)
{
coreValue.IsProcessed = challengeDay.IsProcessed;
}
entity.SaveChanges();
return true;
}
}
public bool UpdateSocialToken(int socialId, string token)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var social = entity.Socials.Find(socialId);
if (social != null)
{
social.Token = token;
entity.SaveChanges();
return true;
}
return false;
}
}
public Message GetDefaultWasteMessage()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Messages.FirstOrDefault(m => m.ChallengeId == null && m.UserId == null && m.Type == (int)MessageType.Waste);
}
}
public Challenge GetActiveChallengeByUserId(int userId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var challenge = entity.Challenges.Include(cl => cl.ChallegeDays).Include(c => c.Donation).FirstOrDefault(c => c.UserId == userId && c.isActive == true);
//Remove the circle
if (challenge != null)
{
foreach (var item in challenge.ChallegeDays)
{
item.Challenge = null;
}
if (challenge.Donation != null)
{
challenge.Donation.Challenges = null;
}
}
return challenge;
}
}
public bool UpdateUser(User user)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var userToUpdated = entity.Users.FirstOrDefault(u => u.Id == user.Id);
if (userToUpdated != null)
{
userToUpdated.Name = user.Name;
userToUpdated.ImageUrl = user.ImageUrl;
entity.SaveChanges();
return true;
}
return false;
}
}
public Message GetMessage(int messageId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Messages.Find(messageId);
}
}
public List<Donation> GetAllDonation()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Donations.ToList();
}
}
public User GetUserByClientId(string clientId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var social = entity.Socials.Include(s => s.User).FirstOrDefault(s => s.ClientId_.Equals(clientId));
if (social != null)
{
return entity.Users.Include(u => u.Socials).FirstOrDefault(u => u.Id == social.UserId);
}
return null;
}
}
public bool RemoveMessage(int messageId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var message = entity.Messages.Find(messageId);
if (message != null)
{
var rs = entity.Messages.Remove(message);
entity.SaveChanges();
return rs != null;
}
return false;
}
}
public List<Challenge> GetBatchActiveChallengeByPage(int pageIndex, int size)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Challenges.OrderBy(c => c.StartTime).Include(c=>c.Donation).Include(cl => cl.ChallegeDays).Include(c => c.User.Socials).Where(c => c.isActive == true).Skip((pageIndex - 1) * size).Take(size).ToList();
}
}
public List<Message> GetMessagesByChallegen(int challengId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Messages.Where(m => m.ChallengeId == challengId).ToList();
}
}
public Message GetMessageByUserType(int userId, Enum.MessageType type)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Messages.FirstOrDefault(m => m.UserId == userId && m.Type == (int)type);
}
}
public List<Challenge> GetAllActiveChallenge()
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
return entity.Challenges.Where(c => c.isActive == true).ToList();
}
}
public bool RemoveDonation(int donationId)
{
using (var entity = new WakeOrWasteEntities())
{
entity.Configuration.ProxyCreationEnabled = false;
var donation = entity.Donations.Find(donationId);
if (donation != null)
{
var rs = entity.Donations.Remove(donation);
entity.SaveChanges();
return rs != null;
}
return false;
}
}
