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 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 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 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 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 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(Customer customer) { try { using (var context = new KioskWebDBEntities()) { context.Customers.Add(customer); context.SaveChanges(); } return(true); } 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 bool Save(Branch branch) { try { using (var context = new KioskWebDBEntities()) { context.Branches.Add(branch); context.SaveChanges(); } return(true); } 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 List <Function> RetrieveFunctions() { try { using (var context = new KioskWebDBEntities()) { var functions = context.Functions.ToList(); return(functions); } } 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 List <Customer> RetrieveCustomers() { try { using (var context = new KioskWebDBEntities()) { var customers = context.Customers .ToList(); return(customers); } } 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 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 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 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 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 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 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 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 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 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 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 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(Branch branch) { try { Branch existingBranch = new Branch(); using (var context = new KioskWebDBEntities()) { existingBranch = context.Branches .Include("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 KioskWebDBEntities()) { context.Entry(existingBranch).State = EntityState.Modified; context.SaveChanges(); } return(true); } else { return(false); } } 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; } }