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 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 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 Save(Function function)
{
try
{
using (var context = new PrinterMonitorDBEntities())
{
context.Functions.Add(function);
context.SaveChanges();
}
return true;
}
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 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;
}
}
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 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 Update(Printer printer)
{
try
{
Printer existingPrinter = new Printer();
using (var context = new PrinterMonitorDBEntities())
{
existingPrinter = context.Printers
.Where(t => t.ID == printer.ID)
.FirstOrDefault();
}
if (existingPrinter != null)
{
existingPrinter.PrinterSrNo = printer.PrinterSrNo;
existingPrinter.PrinterName = printer.PrinterName;
existingPrinter.PrinterBrand = printer.PrinterBrand;
existingPrinter.BranchID = printer.BranchID;
using (var context = new PrinterMonitorDBEntities())
{
context.Entry(existingPrinter).State = EntityState.Modified;
context.SaveChanges();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(Role role)
{
try
{
Role existingRole = new Role();
using (var context = new PrinterMonitorDBEntities())
{
existingRole = context.Roles
.Where(t => t.ID == role.ID)
.FirstOrDefault();
}
if (existingRole != null)
{
existingRole.Name = role.Name;
using (var context = new PrinterMonitorDBEntities())
{
//Transaction block
using (var transaction = context.Database.BeginTransaction())
{
try
{
//Modifying just the property details
context.Entry(existingRole).State = EntityState.Modified;
context.SaveChanges();
//Delete existing role function of the role
IEnumerable<RoleFunction> existingRoleFunctions = context.RoleFunctions.Include("Role")
.Where(t => existingRole.ID.Equals(t.RoleID))
.ToList();
if (existingRoleFunctions != null && existingRoleFunctions.ToList().Count != 0)
{
context.RoleFunctions.RemoveRange(existingRoleFunctions);
context.SaveChanges();
}
//Adding new Role Functions
List<RoleFunction> newRoleFunctions = new List<RoleFunction>();
foreach (RoleFunction function in role.RoleFunctions)
{
RoleFunction roleFunction = new RoleFunction();
roleFunction.RoleID = existingRole.ID;
roleFunction.FunctionID = function.FunctionID;
newRoleFunctions.Add(roleFunction);
}
if (newRoleFunctions != null && newRoleFunctions.Count != 0)
{
context.RoleFunctions.AddRange(newRoleFunctions);
context.SaveChanges();
}
//commit changes
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
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 PrinterMonitorDBEntities())
{
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 PrinterMonitorDBEntities())
{
context.Entry(existingUser).State = EntityState.Modified;
context.SaveChanges();
}
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}