public int SaveUser(User user)
{
int userId;
using (var db = new BaoLinksContainer())
{
db.User.Add(user);
userId=db.SaveChanges();
}
return userId;
}
public bool CheckUserEmail(string email)
{
bool exist;
using (var db = new BaoLinksContainer())
{
var query = db.User.AsQueryable();
exist = query.Any(m => m.Email.Equals(email));
}
return !exist;
}
public DiscountInfo GetSingleDiscountInfoById(int id)
{
DiscountInfo discountInfo;
using (var db = new BaoLinksContainer())
{
var query = db.DiscountInfo.AsQueryable();
query = query.Where(m => m.Id.Equals(id));
discountInfo = query.First();
}
return discountInfo;
}
public List<DiscountInfo> GetDiscountInfo()
{
List<DiscountInfo> discountInfos;
using (var db = new BaoLinksContainer())
{
var query = db.DiscountInfo.AsQueryable();
//query = query.Where(m =>m.StartDate.Date>=DateTime.Now.Date&&m.Published&&!m.Deleted&&m.Audited);
discountInfos = query.OrderByDescending(m => m.PublishTime).ToList();
}
return discountInfos;
}
public List<User> GetUesrByEmail(string email)
{
List<User> users=new List<User>();
using (var db = new BaoLinksContainer())
{
var query = db.User.AsQueryable();
query=query.Where(m => m.Email.Equals(email));
users = query.ToList();
}
return users;
}
public User GetLoginUser(string email, string password)
{
using (var db = new BaoLinksContainer())
{
var query = db.User.AsQueryable();
query = query.Where(m => m.Email.Equals(email) && m.Password.Equals(password));
if (query.Any())
return query.First();
}
return null;
}
public int SaveDiscountInfo(DiscountInfo discountInfo)
{
using (var db = new BaoLinksContainer())
{
try
{
var query = db.DiscountInfo.Add(discountInfo);
db.SaveChanges();
}
catch (DbEntityValidationException exception)
{
var i = exception;
throw;
}
}
return discountInfo.Id;
}
