public static bool Save(Function function) { try { using (var context = new PrinterMonitorDBEntities()) { context.Functions.Add(function); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static List<PrinterFeed> RetrievePrinterFeeds() { try { using (var context = new PrinterMonitorDBEntities()) { var printerFeeds = context.PrinterFeeds.Where(p => p.LatestFeed == true).ToList(); return printerFeeds; } } catch (Exception ex) { throw ex; } }
public static bool Save(PrinterFeed printerFeed) { try { using (var context = new PrinterMonitorDBEntities()) { context.sp_insert_printer_feeds(printerFeed.PrinterUID, printerFeed.PrinterSerialNumber, printerFeed.RibbonCount, printerFeed.CardPrinted, printerFeed.Status, printerFeed.DateofReport, printerFeed.PrinterType); } return true; } catch (Exception ex) { throw ex; } }
public static List<Function> RetrieveFunctions() { try { using (var context = new PrinterMonitorDBEntities()) { var functions = context.Functions.ToList(); return functions; } } catch (Exception ex) { throw ex; } }
public static bool Save(Role role) { try { using (var context = new PrinterMonitorDBEntities()) { context.Roles.Add(role); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static Function RetrieveFunctionByID(long functionID) { try { using (var context = new PrinterMonitorDBEntities()) { 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 PrinterMonitorDBEntities()) { var roles = context.Roles .Include(r => r.RoleFunctions.Select(rf => rf.Function)) .ToList(); return roles; } } catch (Exception ex) { throw ex; } }
public static List<Printer> RetrievePrinters() { try { using (var context = new PrinterMonitorDBEntities()) { var printers = context.Printers .Include("Branch") .ToList(); return printers; } } catch (Exception ex) { throw ex; } }
public static Role RetrieveRoleByID(long? roleID) { try { using (var context = new PrinterMonitorDBEntities()) { 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 RetrieveUserByUsername(string username) { try { var existingUser = new User(); using (var context = new PrinterMonitorDBEntities()) { existingUser = context.Users .Where(t => t.Username.Equals(username)) .FirstOrDefault(); } return existingUser; } catch (Exception ex) { throw ex; } }
public static User AuthenticateUser(string username, string hashedPassword) { try { using (var context = new PrinterMonitorDBEntities()) { var users = context.Users .Include("Role.RoleFunctions.Function") .Include("SmartCard") .Where(f => f.Username == username && f.HashedPassword == hashedPassword); return users.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static Branch RetrieveBranchByID(long? branchID) { try { using (var context = new PrinterMonitorDBEntities()) { var branches = context.Branches .Include(b => b.Printers) .Include(b => b.Users) .Where(f => f.ID == branchID); return branches.FirstOrDefault(); } } catch (Exception ex) { throw ex; } }
public static List<Branch> RetrieveBranches() { try { using (var context = new PrinterMonitorDBEntities()) { var branches = context.Branches .Include(b => b.Printers) .Include(b => b.Users) .ToList(); return branches; } } catch (Exception ex) { throw ex; } }
public static SmartCard GetSmartCardByHashedID(string ID) { try { using (var context = new PrinterMonitorDBEntities()) { string smartCardID = PasswordHash.MD5Hash(ID); var smartCards = context.SmartCards .Where(s => s.HashedSmartCardID == smartCardID) .FirstOrDefault(); return smartCards; } } catch (Exception ex) { throw ex; } }
public static Printer GetPrinterBySerialNumber(string printerSerialNumber) { try { var existingPrinter = new Printer(); using (var context = new PrinterMonitorDBEntities()) { existingPrinter = context.Printers .Include("Branch") .Where(t => t.PrinterSrNo.Equals(printerSerialNumber)) .FirstOrDefault(); } return existingPrinter; } catch (Exception ex) { throw ex; } }
public static bool FunctionExists(Function function) { try { var existingFunction = new Function(); using (var context = new PrinterMonitorDBEntities()) { 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 PrinterMonitorDBEntities()) { 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 CheckInsertedTokenStatus(string token) { try { var webToken = new CHECK_WEBTOKEN(); string hashedToken = PasswordHash.MD5Hash(token); using (var context = new PrinterMonitorDBEntities()) { webToken = context.CHECK_WEBTOKEN .Where(t => t.HashedToken.Equals(hashedToken)) .FirstOrDefault(); } if (webToken.Status == 0) return false; else return true; } catch (Exception ex) { throw ex; } }
public static bool PrinterExists(Printer printer) { try { var existingPrinter = new Printer(); using (var context = new PrinterMonitorDBEntities()) { existingPrinter = context.Printers .Include("Branch") .Where(t => t.PrinterSrNo.Equals(printer.PrinterSrNo)) .FirstOrDefault(); } if (existingPrinter == 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 PrinterMonitorDBEntities()) { existingBranch = context.Branches .Include(b => b.Printers) .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 CHECK_WEBTOKEN CheckNewToken(string username, string userSmartCardID) { try { string scID = PasswordHash.MD5Hash(userSmartCardID); using (var context = new PrinterMonitorDBEntities()) { var webToken = context.CHECK_WEBTOKEN .Where(t => t.Status == 0 && t.Username.Equals(username) && t.HashedSmartCardID.Equals(scID)) .OrderByDescending(t => t.id) .FirstOrDefault(); if (webToken != null) return webToken; else return null; } } catch (Exception ex) { throw ex; } }
public static bool ChangePassword(string username, string newHashedPassword) { try { User existingUser = new User(); using (var context = new PrinterMonitorDBEntities()) { existingUser = context.Users .Where(t => t.Username == username) .FirstOrDefault(); } if (existingUser != null) { existingUser.HashedPassword = newHashedPassword; existingUser.FirstTime = false; using (var context = new PrinterMonitorDBEntities()) { context.Entry(existingUser).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool Save(Branch branch) { try { using (var context = new PrinterMonitorDBEntities()) { context.Branches.Add(branch); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static bool Update(Branch branch) { try { Branch existingBranch = new Branch(); using (var context = new PrinterMonitorDBEntities()) { existingBranch = context.Branches .Include(b => b.Printers) .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 PrinterMonitorDBEntities()) { context.Entry(existingBranch).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool UpdateSmartCardID(long smartCardID, long userID, bool status) { try { var sc = new SmartCard(); var user = new User(); using (var context = new PrinterMonitorDBEntities()) { sc = context.SmartCards .Where(t => t.ID == smartCardID) .FirstOrDefault(); user = context.Users .Include(u => u.SmartCard) .Where(t => t.ID == userID) .FirstOrDefault(); } if (sc != null && user != null) { sc.Allocated = status; if (status) { if (user.SmartCard != null) throw new Exception(string.Format("User {0} has a smart card allocated to it already", user.Username)); user.SmartCardID = smartCardID; } else { user.SmartCard = null; sc.Users = null; user.SmartCardID = null; } using (var context = new PrinterMonitorDBEntities()) { //Transaction block using (var transaction = context.Database.BeginTransaction()) { try { context.Entry(user).State = EntityState.Modified; context.SaveChanges(); context.Entry(sc).State = EntityState.Modified; context.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } } return true; } catch (Exception ex) { throw ex; } }
public static bool InsertEncrptedToken(CHECK_WEBTOKEN webToken) { try { CHECK_WEBTOKEN token; using (var context = new PrinterMonitorDBEntities()) { // Query for the token token = context.CHECK_WEBTOKEN .Where(t => t.id == webToken.id) .FirstOrDefault(); } //Insert the Encrypted Token against the Token supplied and Update Status to 1 if (token != null) { token.EncyptedToken = Crypter.Encrypt(System.Configuration.ConfigurationManager.AppSettings.Get("ekey"), webToken.Token); token.Status = 1; } using (var context = new PrinterMonitorDBEntities()) { context.Entry(token).State = EntityState.Modified; context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }
public static bool InsertSmartCardID(string smartCardID, out string response) { try { var sc = new SmartCard(); string hashedSmartID = PasswordHash.MD5Hash(smartCardID); using (var context = new PrinterMonitorDBEntities()) { // Query for the token sc = context.SmartCards .Where(t => t.HashedSmartCardID == hashedSmartID) .FirstOrDefault(); } if (sc != null) { response = "Smard Card ID has been registered already"; return false; } else { var smartCard = new SmartCard(); smartCard.Allocated = false; smartCard.EncryptedSmartCardID = Crypter.Encrypt(System.Configuration.ConfigurationManager.AppSettings.Get("ekey"), smartCardID); smartCard.HashedSmartCardID = PasswordHash.MD5Hash(smartCardID); using (var context = new PrinterMonitorDBEntities()) { context.SmartCards.Add(smartCard); context.SaveChanges(); } response = "Successful"; return true; } } catch (Exception ex) { throw ex; } }
public static SmartCard GetSmartCardByID(int ID) { try { using (var context = new PrinterMonitorDBEntities()) { var smartCards = context.SmartCards .Where(s => s.ID == ID) .FirstOrDefault(); return smartCards; } } catch (Exception ex) { throw ex; } }
public static bool Update(Function function) { try { Function existingfunction = new Function(); using (var context = new PrinterMonitorDBEntities()) { 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 PrinterMonitorDBEntities()) { context.Entry(existingfunction).State = EntityState.Modified; context.SaveChanges(); } return true; } else { return false; } } catch (Exception ex) { throw ex; } }
public static bool InsertToken(string token, string username, string smartCardID) { try { var webToken = new CHECK_WEBTOKEN(); webToken.DateOfrequest = System.DateTime.Now; webToken.Token = token; webToken.HashedToken = PasswordHash.MD5Hash(token); webToken.Username = username; webToken.SmartCardID = Crypter.Encrypt(System.Configuration.ConfigurationManager.AppSettings.Get("ekey"), smartCardID); webToken.HashedSmartCardID = PasswordHash.MD5Hash(smartCardID); webToken.Status = 0; using (var context = new PrinterMonitorDBEntities()) { // Saves the token context.CHECK_WEBTOKEN.Add(webToken); context.SaveChanges(); } return true; } catch (Exception ex) { throw ex; } }