public static PregeneratedCard GetCardSerialNumber(string loggedInUser)
{
try
{
var user = UserDL.RetrieveUserByUsername(loggedInUser);
if (user == null)
{
throw new Exception("Invalid username");
}
else if (user.ID == 0)
{
throw new Exception("Invalid username");
}
else
{
var existingCard = new PregeneratedCard();
using (var context = new LicenseDBEntities())
{
existingCard = context.PregeneratedCards
.Include("Branch1")
.Where(t => t.Status == false && t.Branch == user.UserBranch)
.Take(1)
.FirstOrDefault();
}
return(existingCard);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool ChangePassword(string username, string newHashedPassword)
{
try
{
User existingUser = new User();
using (var context = new LicenseDBEntities())
{
existingUser = context.Users
.Where(t => t.Username == username)
.FirstOrDefault();
}
if (existingUser != null)
{
existingUser.HashedPassword = newHashedPassword;
existingUser.FirstTime = false;
using (var context = new LicenseDBEntities())
{
context.Entry(existingUser).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool FunctionExists(Function function)
{
try
{
var existingFunction = new Function();
using (var context = new LicenseDBEntities())
{
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 CardAccountRequest GetFullDataWithID(long ID)
{
try
{
using (var context = new LicenseDBEntities())
{
var car = context.CardAccountRequests
.Where(x => x.ID == ID).FirstOrDefault();
string key = System.Configuration.ConfigurationManager.AppSettings.Get("ekey");
if (car != null && !string.IsNullOrEmpty(car.CardSerialNumber))
{
car.CardSerialNumber = Crypter.Decrypt(key, car.CardSerialNumber);
car.HashedCardSerialNumber = Crypter.Decrypt(key, car.CardSerialNumber);
}
return(car);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool PregeneratedCardExists(string pregeneratedCard)
{
try
{
var existingCard = new PregeneratedCard();
using (var context = new LicenseDBEntities())
{
existingCard = context.PregeneratedCards
.Where(t => t.HashedCardNumber.Equals(pregeneratedCard))
.FirstOrDefault();
}
if (existingCard == 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 LicenseDBEntities())
{
existingBranch = context.Branches
.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 bool UserExists(User user)
{
try
{
var existingUser = new User();
using (var context = new LicenseDBEntities())
{
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 RoleExists(Role role)
{
try
{
var existingRole = new Role();
using (var context = new LicenseDBEntities())
{
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 List <CardAccountRequest> GetListofDataWithSearch(string name, string fileNo, string licenseNo, long branchID)
{
try
{
using (var context = new LicenseDBEntities())
{
var cars = context.CardAccountRequests
.Where(x => (x.Lastname.Contains(name) ||
x.FirstName.Contains(name) ||
x.MiddleName.Contains(name)) && x.BranchID == branchID)
.ToList();
if (!string.IsNullOrEmpty(fileNo))
{
cars = cars.Where(x => x.FileNumber == fileNo).ToList();
}
if (!string.IsNullOrEmpty(licenseNo))
{
cars = cars.Where(x => x.LicenseID == licenseNo).ToList();
}
return(cars);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Violation> RetrieveViolations()
{
try
{
using (var context = new LicenseDBEntities())
{
var violations = context.Violations.ToList();
return(violations);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(User user)
{
try
{
using (var context = new LicenseDBEntities())
{
context.Users.Add(user);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(Branch branch)
{
try
{
using (var context = new LicenseDBEntities())
{
context.Branches.Add(branch);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(Function function)
{
try
{
using (var context = new LicenseDBEntities())
{
context.Functions.Add(function);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Fine> RetrieveAllFines()
{
try
{
using (var context = new LicenseDBEntities())
{
var fine = context.Fines;
return(fine.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(List <PregeneratedCard> pregeneratedCards)
{
try
{
using (var context = new LicenseDBEntities())
{
context.PregeneratedCards.AddRange(pregeneratedCards);
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CardAccountRequest> RetrieveCardAccountRequests()
{
try
{
using (var context = new LicenseDBEntities())
{
var cars = context.CardAccountRequests.ToList();
return(cars);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(CardAccountRequest car, out long recordId)
{
try
{
using (var context = new LicenseDBEntities())
{
context.CardAccountRequests.Add(car);
context.SaveChanges();
}
recordId = car.ID;
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(CardAccountRequest car)
{
try
{
using (var context = new LicenseDBEntities())
{
context.Entry(car).State = EntityState.Modified;
context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static CardAccountRequest RetrieveCardAccountRequestsByID(long ID)
{
try
{
using (var context = new LicenseDBEntities())
{
var car = context.CardAccountRequests
.Where(x => x.ID == ID).FirstOrDefault();
return(car);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Fine> RetrieveFines(string licenseID)
{
try
{
using (var context = new LicenseDBEntities())
{
var fine = context.Fines
.Where(f => f.LicenseID == licenseID);
return(fine.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static CardAccountRequest GetCardAccountRequestByLicenseID(string licenseID)
{
try
{
using (var context = new LicenseDBEntities())
{
var car = context.CardAccountRequests
.Where(x => x.LicenseID == licenseID).FirstOrDefault();
return(car);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Save(Fine fine, out long recordID)
{
try
{
using (var context = new LicenseDBEntities())
{
context.Fines.Add(fine);
context.SaveChanges();
}
recordID = fine.ID;
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public static Function RetrieveFunctionByID(long functionID)
{
try
{
using (var context = new LicenseDBEntities())
{
var function = context.Functions
.Where(f => f.ID == functionID);
return(function.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <CardAccountRequest> GetListofData(long branchID)
{
try
{
using (var context = new LicenseDBEntities())
{
var cars = context.CardAccountRequests
.Where(x => x.PrintStatus == 1 && x.BranchID == branchID)
.ToList();
return(cars);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <Role> RetrieveRoles()
{
try
{
using (var context = new LicenseDBEntities())
{
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 LicenseDBEntities())
{
var branches = context.Branches
.Include(b => b.Users)
.ToList();
return(branches);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static Branch RetrieveBranchByID(long?branchID)
{
try
{
using (var context = new LicenseDBEntities())
{
var branches = context.Branches
.Include(b => b.Users)
.Where(f => f.ID == branchID);
return(branches.FirstOrDefault());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static long RecordsToBePrinted(long branchID)
{
try
{
using (var context = new LicenseDBEntities())
{
var cars = context.CardAccountRequests
.Where(x => x.PrintStatus == 1 && x.BranchID == branchID)
.ToList();
return(cars.Any() ? cars.Count() : 0);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <PregeneratedCard> RetrievePregeneratedCards()
{
try
{
using (var context = new LicenseDBEntities())
{
var pregeneratedCards = context.PregeneratedCards
.Include("Branch1")
.ToList();
return(pregeneratedCards);
}
}
catch (Exception ex)
{
throw ex;
}
}
public static User AuthenticateUser(string username, string hashedPassword)
{
try
{
using (var context = new LicenseDBEntities())
{
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;
}
}
