public static bool BranchExists(Branch branch)
{
try
{
var existingBranch = new Branch();
using (var context = new PersoDBEntities())
{
existingBranch = context.Branches
.Include(b => b.Users)
.Where(t => t.Name.Equals(branch.Name) || t.Code.Equals(branch.Code))
.FirstOrDefault();
}
if (existingBranch == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool CustomerExists(Customer customer)
{
try
{
var existingCustomer = new Customer();
using (var context = new PersoDBEntities())
{
existingCustomer = context.Customers
.Where(t => t.Surname.Equals(customer.Surname) && t.Othernames.Equals(customer.Othernames))
.FirstOrDefault();
}
if (existingCustomer == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool RoleExists(Role role)
{
try
{
var existingRole = new Role();
using (var context = new PersoDBEntities())
{
existingRole = context.Roles
.Where(t => t.Name.Equals(role.Name))
.FirstOrDefault();
}
if (existingRole == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool ChangePassword(string username, string newHashedPassword)
{
try
{
User existingUser = new User();
using (var context = new PersoDBEntities())
{
existingUser = context.Users
.Where(t => t.Username == username)
.FirstOrDefault();
}
if (existingUser != null)
{
existingUser.HashedPassword = newHashedPassword;
existingUser.FirstTime = false;
using (var context = new PersoDBEntities())
{
context.Entry(existingUser).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool FunctionExists(Function function)
{
try
{
var existingFunction = new Function();
using (var context = new PersoDBEntities())
{
existingFunction = context.Functions
.Where(t => t.Name.Equals(function.Name))
.FirstOrDefault();
}
if (existingFunction == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UserExists(User user)
{
try
{
var existingUser = new User();
using (var context = new PersoDBEntities())
{
existingUser = context.Users
.Where(t => t.Username.Equals(user.Username))
.FirstOrDefault();
}
if (existingUser == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(PersoDBEntities context, Card card, out long savedCardID)
{
try
{
context.Cards.Add(card);
context.SaveChanges();
savedCardID = card.ID;
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(Branch branch)
{
try
{
using (var context = new PersoDBEntities())
{
context.Branches.Add(branch);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Function> RetrieveFunctions()
{
try
{
using (var context = new PersoDBEntities())
{
var functions = context.Functions.ToList();
return(functions);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(Function function)
{
try
{
using (var context = new PersoDBEntities())
{
context.Functions.Add(function);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CardProfile> RetrieveCardProfiles()
{
try
{
using (var context = new PersoDBEntities())
{
var cardProfiles = context.CardProfiles.ToList();
return(cardProfiles);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(CardProfile cardProfile)
{
try
{
using (var context = new PersoDBEntities())
{
context.CardProfiles.Add(cardProfile);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(User user)
{
try
{
using (var context = new PersoDBEntities())
{
context.Users.Add(user);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static Customer RetrieveCustomer(string accountnumber)
{
try
{
using (var context = new PersoDBEntities())
{
var customers = context.Customers
.Where(c => c.AccountNumber == accountnumber);
return(customers.Any() ? customers.FirstOrDefault() : null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Function RetrieveFunctionByID(long functionID)
{
try
{
using (var context = new PersoDBEntities())
{
var function = context.Functions
.Where(f => f.ID == functionID);
return(function.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Customer> RetrieveCustomers()
{
try
{
using (var context = new PersoDBEntities())
{
var customers = context.Customers
.ToList();
return(customers);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static CardProfile RetrieveCardProfileByID(long id)
{
try
{
using (var context = new PersoDBEntities())
{
var cardProfiles = context.CardProfiles
.Where(f => f.ID == id);
return(cardProfiles.Any() ? cardProfiles.FirstOrDefault() : null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Branch> RetrieveBranches()
{
try
{
using (var context = new PersoDBEntities())
{
var branches = context.Branches
.Include(b => b.Users)
.ToList();
return(branches);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Branch RetrieveBranchByID(long?branchID)
{
try
{
using (var context = new PersoDBEntities())
{
var branches = context.Branches
.Include(b => b.Users)
.Where(f => f.ID == branchID);
return(branches.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Role> RetrieveRoles()
{
try
{
using (var context = new PersoDBEntities())
{
var roles = context.Roles
.Include(r => r.RoleFunctions.Select(rf => rf.Function))
.ToList();
return(roles);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Role RetrieveRoleByID(long?roleID)
{
try
{
using (var context = new PersoDBEntities())
{
var role = context.Roles
.Where(r => r.ID == roleID)
.Include(r => r.RoleFunctions.Select(rf => rf.Function))
.ToList().FirstOrDefault();
return(role);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User AuthenticateUser(string username, string hashedPassword)
{
try
{
using (var context = new PersoDBEntities())
{
var users = context.Users
.Include("Branch")
.Include("Role.RoleFunctions.Function")
.Where(f => f.Username == username && f.HashedPassword == hashedPassword);
return(users.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <User> RetrieveUsers()
{
try
{
using (var context = new PersoDBEntities())
{
var users = context.Users
.Include("Branch")
.Include("Role.RoleFunctions.Function")
.ToList();
return(users);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User RetrieveUser()
{
try
{
using (var context = new PersoDBEntities())
{
var existingUser = context.Users
.Include("Branch")
.Include("Role.RoleFunctions.Function")
.OrderByDescending(u => u.ID)
.Take(1);
return(existingUser.Any() ? existingUser.FirstOrDefault() : null);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User RetrieveUserByUsername(string username)
{
try
{
var existingUser = new User();
using (var context = new PersoDBEntities())
{
existingUser = context.Users
.Where(t => t.Username.Equals(username))
.Include(x => x.Branch)
.FirstOrDefault();
}
return(existingUser);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Customer> RetrieveCustomersByID(long[] id)
{
try
{
using (var context = new PersoDBEntities())
{
var customers = context.Customers
.Where(c => id.Contains(c.ID))
.Include("Card")
.Include("Card.CardProfile")
.ToList();
return(customers);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(User user)
{
try
{
User existingUser = new User();
using (var context = new PersoDBEntities())
{
existingUser = context.Users
.Where(t => t.ID == user.ID)
.FirstOrDefault();
}
if (existingUser != null)
{
existingUser.Email = user.Email;
existingUser.Gender = user.Gender;
existingUser.PhoneNumber = user.PhoneNumber;
existingUser.Lastname = user.Lastname;
existingUser.Othernames = user.Othernames;
existingUser.UserRole = user.UserRole;
existingUser.UserBranch = user.UserBranch;
using (var context = new PersoDBEntities())
{
context.Entry(existingUser).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Customer> RetrieveCustomerPersoData()
{
try
{
using (var context = new PersoDBEntities())
{
var customers = context.Customers
.Where(c => c.CustomerCard != null)
.Include("Card")
.Include("Card.CardProfile")
.ToList();
return(customers);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(Branch branch)
{
try
{
Branch existingBranch = new Branch();
using (var context = new PersoDBEntities())
{
existingBranch = context.Branches
.Include(b => b.Users)
.Where(t => t.ID == branch.ID)
.FirstOrDefault();
}
if (existingBranch != null)
{
existingBranch.Name = branch.Name;
existingBranch.Code = branch.Code;
existingBranch.Address = branch.Address;
using (var context = new PersoDBEntities())
{
context.Entry(existingBranch).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateStatus(long[] customerIDs, bool status)
{
try
{
var existingCustomer = new List <Customer>();
using (var context = new PersoDBEntities())
{
existingCustomer = context.Customers
.Where(t => customerIDs.Contains(t.ID))
.ToList();
}
if (existingCustomer.Any())
{
existingCustomer.ForEach(customer =>
{
customer.Downloaded = status;
using (var context = new PersoDBEntities())
{
context.Entry(customer).State = EntityState.Modified;
context.SaveChanges();
}
});
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
