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