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