public static bool UpdateUserSubscription(int userSubscriptionID, bool subscribed) { MyFlixEntities db = new MyFlixEntities(); UserSubscription us = db.UserSubscriptions.FirstOrDefault(u => u.UserSubscriptionID == userSubscriptionID); if (us != null) { if (subscribed) { us.SubscribedDate = DateTime.UtcNow; } else { us.SubscribedDate = null; } db.UserSubscriptions.Attach(us); db.Entry(us).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(true); } return(false); }
public static bool Login(string email, string password) { MyFlixEntities db = new MyFlixEntities(); User user = db.Users.FirstOrDefault(u => email.ToLower().Equals(email) && u.Password.Equals(password)); SessionHandler.UserID = user != null ? user.UserID : 0; return(user != null); }
public static bool LinkSubscription(int serviceProdiverID) { MyFlixEntities db = new MyFlixEntities(); if (db.UserSubscriptions.Any(u => u.UserID == SessionHandler.UserID && u.ServiceProviderID == serviceProdiverID)) { return(false); } else { UserSubscription us = new UserSubscription { UserID = SessionHandler.UserID, ServiceProviderID = serviceProdiverID, NewPayment = 9.99M, OldPayment = 10.99M, SubscribedDate = DateTime.UtcNow }; db.UserSubscriptions.Add(us); db.SaveChanges(); return(true); } }
public static bool CreateAccount(string email, string password) { MyFlixEntities db = new MyFlixEntities(); if (db.Users.Any(u => u.EmailAddress.ToLower().Equals(email.ToLower()))) { return(false); } else { User user = new User { EmailAddress = email, Password = password, DateCreated = DateTime.UtcNow, IsActive = true, ProfilePhotoPath = "", }; db.Users.Add(user); db.SaveChanges(); return(true); } }
public static User GetUser() { MyFlixEntities db = new MyFlixEntities(); return(db.Users.FirstOrDefault(u => u.UserID == SessionHandler.UserID)); }
public static List <view_UserSubscription> GetUserSubscriptions() { MyFlixEntities db = new MyFlixEntities(); return(db.view_UserSubscription.Where(v => v.UserID.Equals(SessionHandler.UserID)).ToList()); }
public List <view_UserSubscription> GetUserSubscriptions(int userID) { MyFlixEntities db = new MyFlixEntities(); return(db.view_UserSubscription.Where(v => v.UserID.Equals(userID)).ToList()); }