public FPMachine RefreshObject(FPMachine fpMachine, IFPUserService _fpUserService, IFPTemplateService _fpTemplateService)
{
if (_validator.ValidRefreshObject(fpMachine, this))
{
if (FPMachines.fpDevices[fpMachine.Id] != null) //FPMachines.fpDevices.Add(fpMachine.Id, new FPDevice.ZKEvents());
{
lock (FPMachines.fpDevices[fpMachine.Id]._locker)
{
fpMachine.IsConnected = FPMachines.fpDevices[fpMachine.Id].bIsConnected;
if (fpMachine.IsConnected)
{
fpMachine.MachineNumber = FPMachines.fpDevices[fpMachine.Id].iMachineNumber;
fpMachine.IsInSync = true;
string st = "";
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetPlatform(fpMachine.MachineNumber, ref st))
{
fpMachine.Platform = st;
}
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetFirmwareVersion(fpMachine.MachineNumber, ref st))
{
fpMachine.FirmwareVer = st;
}
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetSysOption(fpMachine.MachineNumber, "~ZKFPVersion", out st))
{
fpMachine.ArithmeticVer = st;
}
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetSerialNumber(fpMachine.MachineNumber, out st))
{
fpMachine.SerialNumber = st;
}
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceMAC(fpMachine.MachineNumber, ref st))
{
fpMachine.EthernetMAC = st;
}
int usercount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.UserCount, ref usercount))
{
fpMachine.UserCount = _fpUserService.GetQueryable().Where(x => !x.IsDeleted).Count();
if (fpMachine.UserCount != usercount)
{
fpMachine.IsInSync = false;
}
fpMachine.UserCount = usercount;
}
int admincount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.AdminCount, ref admincount))
{
if (fpMachine.AdminCount != admincount)
{
fpMachine.IsInSync = false;
}
fpMachine.AdminCount = admincount;
}
int pwdcount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.PasswordCount, ref pwdcount))
{
if (fpMachine.PasswordCount != pwdcount)
{
fpMachine.IsInSync = false;
}
fpMachine.PasswordCount = pwdcount;
}
int fpcount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.FPTemplateCount, ref fpcount))
{
fpMachine.FPCount = _fpTemplateService.GetQueryable().Where(x => !x.IsDeleted).Count();
if (fpMachine.FPCount != fpcount)
{
fpMachine.IsInSync = false;
}
fpMachine.FPCount = fpcount;
}
int facecount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.FaceCount, ref facecount))
{
int cnt = ((facecount >= 9999999) ? 0 : facecount);
if (fpMachine.FCCount != cnt)
{
fpMachine.IsInSync = false;
}
fpMachine.FCCount = cnt;
}
int attcount = 0;
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetDeviceStatus(fpMachine.MachineNumber, (int)FPDevice.DeviceStatusType.AttLogCount, ref attcount))
{
fpMachine.AttLogCount = attcount;
}
}
}
_repository.UpdateObject(fpMachine);
}
}
return(fpMachine);
}
public bool UploadAllUserData(FPMachine fpMachine, bool ReSyncAll, bool SyncDateTime, IFPUserService _fpUserService, IFPTemplateService _fpTemplateService, IEmployeeService _employeeService)
{
if (fpMachine == null || fpMachine.Id <= 0)
{
fpMachine.Errors.Add("Generic", "FingerPrint Machine ID not found!");
}
else
{
if (FPMachines.fpDevices[fpMachine.Id] == null)
{
fpMachine.IsConnected = false; // FPMachines.fpDevices.Add(FPMachineId, new FPDevice.ZKEvents());
}
else
{
fpMachine.IsConnected = FPMachines.fpDevices[fpMachine.Id].bIsConnected;
}
if (fpMachine.IsConnected == false)
{
fpMachine.Errors.Add("Generic", "Please connect the device first!");
return(false);
}
bool ok = true;
lock (FPMachines.fpDevices[fpMachine.Id]._locker)
{
//judge whether the device supports 9.0 fingerprint arithmetic
string sOption = "~ZKFPVersion";
string sValue = "";
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetSysOption(fpMachine.MachineNumber, sOption, out sValue))
{
//if (sValue == "10")
//{
// fpMachine.Errors.Add("Generic", "Your device is not using 9.0 arithmetic!");
// return false;
//}
}
FPMachines.fpDevices[fpMachine.Id].Disable(); //.axCZKEM1.DisableDeviceWithTimeOut(fpMachine.MachineNumber, FPMachines.fpDevices[fpMachine.Id].DisabledTime); //.EnableDevice(fpMachine.MachineNumber, false); // Prevent user from using the device
try
{
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.BeginBatchUpdate(fpMachine.MachineNumber, (int)FPDevice.BatchUpdateFlag.Overwrite); //create memory space for batching data
int idwEnrollNumber = 0;
string sName = "";
string sPassword = "";
int iPrivilege = 0;
bool bEnabled = false;
string card = "";
//int pin2 = 0;
int grp = 0;
string TZstr = "";
string sTmpData = "";
byte[] bTmpData = new byte[2048];
//int iTmpLength = 0;
//FPDevice._Template9_ tmp9;
byte[] rsv = new byte[4];
//int iLastEnrollNumber = 0; //the former enrollnumber you have upload (define original value as 0)
// if ReSync = True then Delete All User Data first
if (ReSyncAll)
{
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.ClearAdministrators(fpMachine.MachineNumber);
//FPMachines.fpDevices[fpMachine.Id].axCZKEM1.ClearGLog(fpMachine.MachineNumber); // Clear attendance data
//FPMachines.fpDevices[fpMachine.Id].axCZKEM1.ClearData(fpMachine.MachineNumber, (int)FPDevice.DataFlag.UserInfo);
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.ClearKeeperData(fpMachine.MachineNumber); // Clear All Data
}
//Sync Machine's DateTime
if (SyncDateTime)
{
DateTime curutc = DateTime.Now.ToUniversalTime().AddMinutes((double)fpMachine.TimeZoneOffset);
string winTZ = fpMachine.TimeZone.ToUpper(); // FPDevice.Convertion.IanaToWindows(fpMachine.TimeZone);
TimeZoneInfo destTZ = TimeZoneInfo.GetSystemTimeZones().Where(x => x.Id.ToUpper() == winTZ).FirstOrDefault();
DateTime curtime = TimeZoneInfo.ConvertTime(curutc, destTZ);
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetDeviceTime2(fpMachine.MachineNumber, curtime.Year, curtime.Month, curtime.Day, curtime.Hour, curtime.Minute, curtime.Second);
}
var userlist = _fpUserService.GetQueryable().Where(x => (ReSyncAll || !x.IsInSync));
// Remove deleted user first to prevent deleting existing user with the same UserID
foreach (var fpUser in userlist.Where(x => x.IsDeleted).ToList()) //for (int i = 0; i < list.Count; i++)
{
idwEnrollNumber = fpUser.PIN;
//if (ReSyncAll || !fpUser.IsInSync) //identify whether the user information has been uploaded
{
if (fpUser.IsDeleted)
{
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.DeleteEnrollData(fpMachine.MachineNumber, idwEnrollNumber, fpMachine.MachineNumber, (int)FPDevice.EnrollBackupNumber.AllUserData)) // 12 = delete the user and it's linked data (eg. templates)
{
fpUser.IsInSync = true;
_fpUserService.GetRepository().Update(fpUser);
//_fpUserService.DeleteObject(fpUser.Id);
}
}
}
}
// TODO: Create New Users to get the EnrollNumber, current workaround is by assigning UserID on server side upon creation
// Update Users
foreach (var fpUser in userlist.Where(x => !x.IsDeleted).ToList()) //for (int i = 0; i < list.Count; i++)
{
idwEnrollNumber = fpUser.PIN;
sName = fpUser.Name ?? "";
iPrivilege = fpUser.Privilege;
sPassword = fpUser.Password ?? "";
bEnabled = fpUser.IsEnabled;
//pin2 = fpUser.PIN2;
card = fpUser.Card ?? "";
grp = fpUser.Group;
TZstr = fpUser.TimeZones ?? "";
//if (ReSyncAll || !fpUser.IsInSync) //identify whether the user information has been uploaded
{
//FPMachines.fpDevices[fpMachine.Id].axCZKEM1.GetUserInfo(fpMachine.MachineNumber, idwEnrollNumber, sName, sPassword, iPrivilege, bEnabled);
if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetUserInfo(fpMachine.MachineNumber, idwEnrollNumber, sName, sPassword, iPrivilege, bEnabled)) //upload user information to the memory
{
// TODO: Newly created data doesn't have RollNumber yet
//FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetPIN2(idwEnrollNumber, pin2);
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetStrCardNumber(card);
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetUserGroup(fpMachine.MachineNumber, idwEnrollNumber, grp);
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetUserTZStr(fpMachine.MachineNumber, idwEnrollNumber, TZstr);
var tmplist = _fpTemplateService.GetQueryable().Where(x => x.FPUserId == fpUser.Id && (ReSyncAll || !x.IsInSync));
// Remove deleted template first
foreach (var tmp in tmplist.Where(x => x.IsDeleted).ToList())
{
//if (ReSyncAll || !tmp.IsInSync)
{
//if (FPMachines.fpDevices[fpMachine.Id].axCZKEM1.DeleteEnrollData(fpMachine.MachineNumber, idwEnrollNumber, fpMachine.MachineNumber, tmp.FingerID))
//{
// //tmp.IsInSync = true;
// //_fpTemplateService.GetRepository().Update(tmp);
// _fpTemplateService.DeleteObject(tmp.Id);
//}
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.DeleteEnrollData(fpMachine.MachineNumber, idwEnrollNumber, fpMachine.MachineNumber, tmp.FingerID);
var err = FPMachines.fpDevices[fpMachine.Id].GetLastError();
if (err == (int)FPDevice.ErrorCode.NoError || err == (int)FPDevice.ErrorCode.DataNotFound || err == (int)FPDevice.ErrorCode.OperationFailed || err == (int)FPDevice.ErrorCode.IOError)
{
// Hard delete soft deleted templates when it's no longer exist in the machine
_fpTemplateService.DeleteObject(tmp.Id);
}
}
}
ok = true;
// Update or Create template
foreach (var tmp in tmplist.Where(x => !x.IsDeleted).ToList())
{
//if (ReSyncAll || !tmp.IsInSync)
{
//bTmpData = Convert.FromBase64String(tmp.Template); //Encoding.UTF8.GetBytes(tmp.Template);
sTmpData = tmp.Template;
if (!FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetUserTmpExStr(fpMachine.MachineNumber, idwEnrollNumber.ToString(), tmp.FingerID, (int)FPDevice.TemplateFlag.Normal, sTmpData)) //upload templates information to the memory
{
var err = FPMachines.fpDevices[fpMachine.Id].GetLastError();
if (err != (int)FPDevice.ErrorCode.TimedOut && err != (int)FPDevice.ErrorCode.NotInitialized)
{
////tmp.IsDeleted = true;
////_fpTemplateService.GetRepository().Update(tmp);
//_fpTemplateService.DeleteObject(tmp.Id); // Don't delete on error, otherwise server will loose template data
// Mark failed template creation as not InSync instead of deleting it automatically (should be deleted manually on server side)
tmp.IsInSync = false;
}
ok = false;
break;
}
tmp.IsInSync = true;
_fpTemplateService.GetRepository().Update(tmp);
}
}
if (fpUser.VerifyMode != (int)FPDevice.VerifyMethod.UnSet)
{
rsv = FPDevice.Convertion.HexStringToByteArray(fpUser.Reserved ?? "00");
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.SetUserInfoEx(fpMachine.MachineNumber, idwEnrollNumber, fpUser.VerifyMode, ref rsv[0]);
}
else
{
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.DeleteUserInfoEx(fpMachine.MachineNumber, idwEnrollNumber);
}
if (ok)
{
fpUser.IsInSync = ok;
_fpUserService.GetRepository().Update(fpUser);
}
}
else
{
fpMachine.Errors.Add("Generic", "Upload failed (Error:" + FPMachines.fpDevices[fpMachine.Id].GetLastErrorMsg() + ")");
break;
}
}
//iLastEnrollNumber = idwEnrollNumber;//change the value of iLastEnrollNumber dynamicly
}
int errc = FPMachines.fpDevices[fpMachine.Id].GetLastError();
if (errc != (int)FPDevice.ErrorCode.NoError && errc != (int)FPDevice.ErrorCode.IOError)
{
fpMachine.Errors.Add("Generic", "Upload Failed (Error:" + FPMachines.fpDevices[fpMachine.Id].GetErrorMsg(errc) + ")");
ok = false;
//FPMachines.fpDevices[fpMachine.Id].axCZKEM1.CancelBatchUpdate(fpMachine.MachineNumber);
}
FPMachines.fpDevices[fpMachine.Id].axCZKEM1.BatchUpdate(fpMachine.MachineNumber); //download all the information in the memory
}
finally
{
FPMachines.fpDevices[fpMachine.Id].Refresh(); //.axCZKEM1.RefreshData(fpMachine.MachineNumber); //the data in the device should be refreshed
FPMachines.fpDevices[fpMachine.Id].Enable(); //.axCZKEM1.EnableDevice(fpMachine.MachineNumber, true);
}
}
return(ok);
}
return(false);
}
public dynamic GetList(string _search, long nd, int rows, int?page, string sidx, string sord, string filters = "", int ParentId = 0)
{
// Construct where statement
string strWhere = GeneralFunction.ConstructWhere(filters);
string filter = null;
GeneralFunction.ConstructWhereInLinq(strWhere, out filter);
if (filter == "")
{
filter = "true";
}
// Get Data
var q = _fpUserService.GetQueryable().Where(x => !x.IsDeleted).Include(x => x.FPTemplates);
var query = (from model in q
select new
{
model.Id,
model.EmployeeId,
EmployeeNIK = model.Employee != null ? model.Employee.NIK : "",
EmployeeName = model.Employee != null ? model.Employee.Name : "",
model.PIN,
model.PIN2,
model.Privilege,
model.Name,
model.Password,
model.Card,
model.Group,
model.TimeZones,
model.VerifyMode,
model.IsEnabled,
model.IsInSync,
FPCount = model.FPTemplates.Where(x => !x.IsDeleted).Count(),
model.Reserved, //Reserved = BitConverter.ToString(model.Reserved),
model.Remark,
model.CreatedAt,
model.UpdatedAt,
}).Where(filter).OrderBy(sidx + " " + sord); //.ToList();
var list = query.AsEnumerable();
var pageIndex = Convert.ToInt32(page) - 1;
var pageSize = rows;
var totalRecords = query.Count();
var totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
// default last page
if (totalPages > 0)
{
if (!page.HasValue)
{
pageIndex = totalPages - 1;
page = totalPages;
}
}
list = list.Skip(pageIndex * pageSize).Take(pageSize);
return(Json(new
{
total = totalPages,
page = page,
records = totalRecords,
//rows = list,
rows = (
from model in list
select new
{
id = model.Id,
cell = new object[] {
model.Id,
model.EmployeeId,
model.EmployeeNIK,
model.EmployeeName,
model.PIN,
model.PIN2,
model.Privilege,
model.Name,
model.Password,
model.Card,
model.Group,
model.TimeZones,
model.VerifyMode,
model.IsEnabled,
model.IsInSync, //_fpTemplateService.IsUserInSync(model.Id),
model.FPCount,
model.Reserved,
model.Remark,
model.CreatedAt,
model.UpdatedAt,
}
}).ToArray()
}, JsonRequestBehavior.AllowGet));
}