public static bool ChangePassword(string username, string newPassword) { try { string newHashedPassword = PasswordHash.MD5Hash(newPassword); User existingUser = new User(); using (var context = new KioskWebDBEntities()) { existingUser = context.Users .Where(t => t.Username == username) .FirstOrDefault(); } if (existingUser != null) { existingUser.HashedPassword = newHashedPassword; existingUser.FirstTime = false; using (var context = new KioskWebDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { context.Entry(existingUser).State = EntityState.Modified; context.SaveChanges(); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User thirdPartyUser = new KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User(); thirdPartyUser.UserName = username; if (ThirdPartyDL.UserExists(thirdPartyUser)) ThirdPartyDL.ChangePassword(username, newPassword); transaction.Commit(); } } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool Save(Function function) { try { using (var context = new KioskWebDBEntities()) { context.Functions.Add(function); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static List<Function> RetrieveFunctions() { try { using (var context = new KioskWebDBEntities()) { var functions = context.Functions.ToList(); return functions; } } catch (Exception ex) { throw ex; } }
public static bool Save(Role role) { try { using (var context = new KioskWebDBEntities()) { context.Roles.Add(role); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static User AuthenticateUser(string username, string hashedPassword) { try { using (var context = new KioskWebDBEntities()) { var users = context.Users .Where(f => f.Username == username && f.HashedPassword == hashedPassword); return users.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static Function RetrieveFunctionByID(long functionID) { try { using (var context = new KioskWebDBEntities()) { var function = context.Functions .Where(f => f.ID == functionID); return function.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static List<Role> RetrieveRoles() { try { using (var context = new KioskWebDBEntities()) { var roles = context.Roles .Include(r => r.RoleFunctions.Select(rf => rf.Function)) .ToList(); return roles; } } catch (Exception ex) { throw ex; } }
public static List<Branch> RetrieveBranches() { try { using (var context = new KioskWebDBEntities()) { var branches = context.Branches .Include("Users") .ToList(); return branches; } } catch (Exception ex) { throw ex; } }
public static Branch RetrieveBranchByID(long? branchID) { try { using (var context = new KioskWebDBEntities()) { var branches = context.Branches .Include("Users") .Where(f => f.ID == branchID); return branches.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static Role RetrieveRoleByID(long? roleID) { try { using (var context = new KioskWebDBEntities()) { var role = context.Roles .Include(r => r.RoleFunctions.Select(rf => rf.Function)) .Where(r => r.ID == roleID) .ToList().FirstOrDefault(); return role; } } catch (Exception ex) { throw ex; } }
public static List<CardRequest> RetrieveCardRequest(long branchID) { try { using (var context = new KioskWebDBEntities()) { var cardRequests = context.CardRequests .Where(x => x.PickupBranchID == branchID) .Include(cr => cr.Branch) .Include(cr => cr.Customer) .ToList(); return cardRequests; } } catch (Exception ex) { throw ex; } }
public static bool CustomerCardRequestExists(string serialNumber) { try { var existingCardRequest = new CardRequest(); using (var context = new KioskWebDBEntities()) { existingCardRequest = context.CardRequests .Where(t => t.SerialNumber.Equals(serialNumber)) .FirstOrDefault(); } if (existingCardRequest == null) return false; else return true; } catch (Exception ex) { throw ex; } }
public static bool FunctionExists(Function function) { try { var existingFunction = new Function(); using (var context = new KioskWebDBEntities()) { 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 RoleExists(Role role) { try { var existingRole = new Role(); using (var context = new KioskWebDBEntities()) { 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 CustomerExists(Customer customer) { try { var existingCustomer = new Customer(); using (var context = new KioskWebDBEntities()) { existingCustomer = context.Customers .Where(t => t.EmailAddress.Equals(customer.EmailAddress)) .FirstOrDefault(); } if (existingCustomer == null) return false; else return true; } catch (Exception ex) { throw ex; } }
public static bool BranchExists(Branch branch) { try { var existingBranch = new Branch(); using (var context = new KioskWebDBEntities()) { existingBranch = context.Branches .Include("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 Update(Function function) { try { Function existingfunction = new Function(); using (var context = new KioskWebDBEntities()) { existingfunction = context.Functions .Where(t => t.ID == function.ID) .FirstOrDefault(); } if (existingfunction != null) { existingfunction.Name = function.Name; existingfunction.PageLink = function.PageLink; using (var context = new KioskWebDBEntities()) { context.Entry(existingfunction).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static Customer RetrieveCustomerByID(long? customerID) { try { using (var context = new KioskWebDBEntities()) { var customers = context.Customers .Where(f => f.ID == customerID); return customers.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static Customer RetrieveCustomerByAccountNumber(string accountNumber) { try { using (var context = new KioskWebDBEntities()) { var customers = context.Customers .Where(f => f.AccountNumber == accountNumber); return customers.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static bool Save(Customer customer) { try { using (var context = new KioskWebDBEntities()) { context.Customers.Add(customer); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static List<Customer> RetrieveCustomers() { try { using (var context = new KioskWebDBEntities()) { var customers = context.Customers .ToList(); return customers; } } catch (Exception ex) { throw ex; } }
public static bool SaveCardRequest(CardRequest cardRequest, string loggedInUsername, out CardRequest savedCardRequest) { try { using (var context = new KioskWebDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { context.CardRequests.Add(cardRequest); context.SaveChanges(); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User thirdPartyUser = ThirdPartyDL.RetrieveUserByUsername(loggedInUsername); Customer cardRequestCustomer = RetrieveCustomerByID(cardRequest.CustomerID); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.CardAccountRequest car = new ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.CardAccountRequest(); car.NameOnCard = string.Format("{0} {1}", cardRequestCustomer.Lastname, cardRequestCustomer.Othernames); if (cardRequest.RequestType == StatusUtil.RequestType.WithSerialNumber.ToString()) { KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.PANDetail panDetail = ThirdPartyDL.RetrievePanDetailByAccountNumber(cardRequest.SerialNumber); car.PAN = panDetail.pan; ThirdPartyDL.UpdatePan(panDetail.pan); } car.PrintStatus = 1; car.UserPrinting = thirdPartyUser.id.ToString(); car.DATE = System.DateTime.Now; if (cardRequest.RequestType == StatusUtil.RequestType.WithSerialNumber.ToString()) car.HolderIDNumber = cardRequest.SerialNumber; car.PhoneNumber = cardRequestCustomer.PhoneNumber; car.LastName = cardRequestCustomer.Lastname; car.OtherName = cardRequestCustomer.Othernames; car.emailaddress = cardRequestCustomer.EmailAddress; car.Updateddate = System.DateTime.Now; ThirdPartyDL.SaveCar(car); cardRequest.Customer = cardRequestCustomer; transaction.Commit(); } } cardRequest.Branch = BranchDL.RetrieveBranchByID(cardRequest.PickupBranchID); savedCardRequest = cardRequest; return true; } catch (Exception ex) { throw ex; } }
public static User RetrieveUserByUsername(string username) { try { var existingUser = new User(); using (var context = new KioskWebDBEntities()) { existingUser = context.Users .Where(t => t.Username.Equals(username)) .FirstOrDefault(); } return existingUser; } catch (Exception ex) { throw ex; } }
public static bool UserExists(User user) { try { var existingUser = new User(); using (var context = new KioskWebDBEntities()) { 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 Update(Customer customer) { try { Customer existingCustomer = new Customer(); using (var context = new KioskWebDBEntities()) { existingCustomer = context.Customers .Where(t => t.ID == customer.ID) .FirstOrDefault(); } if (existingCustomer != null) { existingCustomer.Lastname = customer.Lastname; existingCustomer.Othernames = customer.Othernames; existingCustomer.EmailAddress = customer.EmailAddress; existingCustomer.PhoneNumber = customer.PhoneNumber; using (var context = new KioskWebDBEntities()) { context.Entry(existingCustomer).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool Update(User user) { try { User existingUser = new User(); using (var context = new KioskWebDBEntities()) { 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 KioskWebDBEntities()) { context.Entry(existingUser).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool Save(User user) { try { string password = user.HashedPassword; user.HashedPassword = PasswordHash.MD5Hash(password); using (var context = new KioskWebDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { context.Users.Add(user); context.SaveChanges(); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User thirdPartyUser = new KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User(); thirdPartyUser.UserName = user.Username; thirdPartyUser.Password = password; thirdPartyUser.UserType = "1"; thirdPartyUser.status = 1; thirdPartyUser.OfficialEmail = user.Email; if (!ThirdPartyDL.UserExists(thirdPartyUser)) ThirdPartyDL.Save(thirdPartyUser); transaction.Commit(); } } return true; } catch (Exception ex) { throw ex; } }
public static List<User> RetrieveUsers() { try { using (var context = new KioskWebDBEntities()) { var users = context.Users .Include("Branch") .Include("Role.RoleFunctions.Function") .ToList(); return users; } } catch (Exception ex) { throw ex; } }
public static CardRequest RetrieveCardRequestByID(long? cardRequestID) { try { using (var context = new KioskWebDBEntities()) { var cardRequests = context.CardRequests .Include(x => x.Customer) .Include(x => x.Branch) .Where(f => f.ID == cardRequestID); return cardRequests.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static bool UpdateCardRequest(long cardRequestID, string clearPan, string loggedInUsername, out CardRequest cardRequest) { try { CardRequest existingRequest = new CardRequest(); using (var context = new KioskWebDBEntities()) { existingRequest = context.CardRequests .Include(cr => cr.Customer) .Include(cr => cr.Branch) .Where(t => t.ID == cardRequestID) .FirstOrDefault(); } if (existingRequest != null) { if (existingRequest.RequestType == StatusUtil.RequestType.WithSerialNumber.ToString()) { existingRequest.HashedPan = PasswordHash.MD5Hash(clearPan); existingRequest.EncryptedPan = Crypter.Encrypt(System.Configuration.ConfigurationManager.AppSettings.Get("ekey"), clearPan); } existingRequest.Status = StatusUtil.CardStatus.Approved.ToString(); using (var context = new KioskWebDBEntities()) { using (var transaction = context.Database.BeginTransaction()) { context.Entry(existingRequest).State = EntityState.Modified; context.SaveChanges(); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.User thirdPartyUser = ThirdPartyDL.RetrieveUserByUsername(loggedInUsername); KioskSolutionLibrary.ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.CardAccountRequest car = new ModelLibrary.EntityFrameworkLibrary.ThirdPartyData.CardAccountRequest(); car.NameOnCard = string.Format("{0} {1}", existingRequest.Customer.Lastname, existingRequest.Customer.Othernames); if (existingRequest.RequestType == StatusUtil.RequestType.WithSerialNumber.ToString()) car.PAN = clearPan; car.PrintStatus = 1; car.UserPrinting = thirdPartyUser.id.ToString(); car.DATE = System.DateTime.Now; if (existingRequest.RequestType == StatusUtil.RequestType.WithSerialNumber.ToString()) car.HolderIDNumber = existingRequest.SerialNumber; car.PhoneNumber = existingRequest.Customer.PhoneNumber; car.LastName = existingRequest.Customer.Lastname; car.OtherName = existingRequest.Customer.Othernames; car.emailaddress = existingRequest.Customer.EmailAddress; car.Updateddate = System.DateTime.Now; ThirdPartyDL.SaveCar(car); ThirdPartyDL.UpdatePan(clearPan); transaction.Commit(); } } cardRequest = existingRequest; return true; } else { cardRequest = null; return false; } } catch (Exception ex) { throw ex; } }