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