public static ApplicationSetting GetDefaultApplicationSetting() { using (LoyaltyDB db = new LoyaltyDB()) { return(db.ApplicationSettings.First()); } }
public static ICollection <Transaction> GetAccountTransactions(int customerID, DateTime date) { using (LoyaltyDB db = new LoyaltyDB()) { return(db.Transactions.Where(c => c.CustomerID == customerID).Where(t => t.TransactionDate.Month == date.Month && t.TransactionDate.Year == date.Year).ToList()); } }
public static Transaction GetById(int transactionID) { using (LoyaltyDB db = new LoyaltyDB()) { return(db.Transactions.Find(transactionID)); } }
public static Manager GetManagerLogin(string username, string password) { using (LoyaltyDB db = new LoyaltyDB()) { var manager = db.Managers.Include("Login").Where(m => m.Login.Username == username).SingleOrDefault(); if (manager != null) { var managerPasswordDecrypted = RegexUtilities.PasswordDecrypt(manager.Login.Password); if (managerPasswordDecrypted == password) { return(manager); } else { return(null); } } else { return(null); } } }
public static void AddNew(Transaction transaction) { using (LoyaltyDB db = new LoyaltyDB()) { db.Transactions.Add(transaction); db.SaveChanges(); } }
public static void AddNew(Customer customer) { using (LoyaltyDB db = new LoyaltyDB()) { db.Customers.Add(customer); db.SaveChanges(); } }
public static List <Customer> FindByCustomerData(string text) { using (LoyaltyDB db = new LoyaltyDB()) { return(db.Customers.Where(x => x.Name.Contains(text) || x.PaternalLastname.Contains(text) || x.MaternalLastname.Contains(text) || x.Phone.Contains(text) || x.Cellphone.Contains(text) || x.Email.Contains(text) || x.Nickname.Contains(text)).ToList()); } }
public static void NewAccount(Account account) { using (LoyaltyDB db = new LoyaltyDB()) { db.Accounts.Add(account); db.SaveChanges(); } }
public static void Update(ApplicationSetting setting) { using (LoyaltyDB db = new LoyaltyDB()) { db.Entry(setting).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static Account FindById(int customerID) { using (LoyaltyDB db = new LoyaltyDB()) { var account = db.Accounts.Find(customerID); return(account); } }
public static decimal GetCurrentPointsBalance(int CustomerID) { using (LoyaltyDB db = new LoyaltyDB()) { var CurrentPointBalance = db.Accounts.Where(c => c.CustomerID == CustomerID).Select(p => p.CurrentPointsBalance).SingleOrDefault(); return(CurrentPointBalance); } }
public static void UpdateCurrentPointsBalance(Account account, decimal points) { using (LoyaltyDB db = new LoyaltyDB()) { account.ModifiedDate = DateTime.Now; account.CurrentPointsBalance += points; db.Entry(account).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static List <Customer> GetAll() { List <Customer> list = new List <Customer>(); using (LoyaltyDB db = new LoyaltyDB()) { list = db.Customers.Include("Login").ToList(); } return(list); }
public static void UpdateEntityLogin(int Id, string newPassword) { using (var db = new LoyaltyDB()) { var loginToUpdate = db.Logins.Find(Id); loginToUpdate.Password = newPassword; db.SaveChanges(); } }
public static void Update(Manager manager) { using (LoyaltyDB db = new LoyaltyDB()) { var newPassword = RegexUtilities.PasswordEncrypt(manager.Login.Password); LoginServices.UpdateEntityLogin(manager.Login.LoginId, newPassword); db.Entry <Manager>(manager).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static void Update(Customer customer) { using (LoyaltyDB db = new LoyaltyDB()) { customer.ModifiedDate = DateTime.Now; var newPassword = RegexUtilities.PasswordEncrypt(customer.Login.Password); LoginServices.UpdateEntityLogin(customer.Login.LoginId, newPassword); db.Entry(customer).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public static Manager GetManagerById(int managerLoguedID) { using (LoyaltyDB db = new LoyaltyDB()) { Manager manager = db.Managers.Include("Login").Where(m => m.ManagerID == managerLoguedID).SingleOrDefault(); if (manager != null) { return(manager); } else { return(null); } } }
public static bool NicknameExists(string nickname) { using (LoyaltyDB db = new LoyaltyDB()) { var customer = db.Customers.Where(u => u.Nickname == nickname).SingleOrDefault(); if (customer != null) { return(true); } else { return(false); } } }
public static Customer FindById(int id) { Customer customer = null; using (LoyaltyDB db = new LoyaltyDB()) { customer = db.Customers.Find(id); if (customer != null) { return(customer); } } return(null); }
public static bool UsernameExists(string username) { using (LoyaltyDB db = new LoyaltyDB()) { Customer customer = db.Customers.Where(u => u.Login.Username == username).SingleOrDefault(); if (customer != null) { return(true); } else { return(false); } } }
public static Customer GetCustomerById(int customerID) { using (LoyaltyDB db = new LoyaltyDB()) { Customer customer = db.Customers.Include("Login").Where(m => m.CustomerID == customerID).SingleOrDefault(); if (customer != null) { return(customer); } else { return(null); } } }
public static void AddNewCustomer(string Nombre, string ApellidoPaterno, string ApellidoMaterno, string Direccion, string Telefono, string Celular, string Correo, string Usuario, string Contrasena) { using (LoyaltyDB db = new LoyaltyDB()) { db.Customers.Add(new Customer { Address = Direccion, Cellphone = Celular, Email = Correo, MaternalLastname = ApellidoMaterno, Name = Nombre, PaternalLastname = ApellidoPaterno, Phone = Telefono, CreatedDate = DateTime.Now, Login = new Login { Username = Usuario, Password = Contrasena } }); } }
public static AccountDetailsViewModel GetAccountDetails(Customer customer) { using (LoyaltyDB db = new LoyaltyDB()) { var account = db.Accounts.Include("Transactions").Where(a => a.CustomerID == customer.CustomerID).FirstOrDefault(); var customerAccountDetails = new AccountDetailsViewModel { CustomerFullname = customer.ToString(), AccountNumber = account.CustomerID.ToString(), Email = customer.Email, Address = customer.Address, ActualPeriod = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(DateTime.Now.Month), Transactions = account.Transactions, AccumulatedPoints = account.CurrentPointsBalance, CashEquivalent = account.CurrentMoneyBalance }; return(customerAccountDetails); } }
public override IDictionary <string, Customer> Execute(LoyaltyDB model) => new Dictionary <string, Customer>(model.Customers);
public override IDictionary <int, Customer> Execute(LoyaltyDB db) => new Dictionary <int, Customer>(db.Customers);