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