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