Insert and Update Employee Data in Mantra (MSD1KW) Biometric Devices

                                                                     MSD1KW

C# Code for Set All User into DB and Devices

 private void btnSetAllUserEnrollData_Click(object sender, EventArgs e)

        {

            Cursor = Cursors.WaitCursor;

            int _flgVal = 0;

            try

            {              

                DataTable tblData = new DataTable();

                tblData = SqliteDB.SelectAllUserData();

                _flgVal = MantraBioTime.SetAllUserEnrollData(clsGlobal.DeviceType, tblData);

                if (_flgVal == 0)

                {

                    MantraBioTimeSDK.theForm.EventLogs.Items.Add("Set All User EnrollData Successfully!");

                    MantraBioTimeSDK.theForm.EventLogs.TopIndex = MantraBioTimeSDK.theForm.EventLogs.Items.Count - 1;

                }

                else

                {

                    MantraBioTimeSDK.theForm.ErrorLogs.Items.Add(MantraBioTimeException.MsgCode(_flgVal));

                    MantraBioTimeSDK.theForm.ErrorLogs.TopIndex = MantraBioTimeSDK.theForm.ErrorLogs.Items.Count - 1;

                }                

            }

            catch (Exception Ex)

            {

                MantraBioTimeSDK.theForm.ErrorLogs.Items.Add(Ex.Message);

                MantraBioTimeSDK.theForm.ErrorLogs.TopIndex = MantraBioTimeSDK.theForm.ErrorLogs.Items.Count - 1;

            }

            finally

            {

                Cursor = Cursors.Default;

            }

        }

SQLlite Query to convert Decimal to Hex value of Card

SELECT 

        DGD.[Index] As [Index], 

        DGD.MachineNo, 

        DGD.DeviceType, 

        DGD.UserId, 

        UserName, 

        pwd,

        hex(CAST(CAST([Card] AS INT) AS BLOB))  AS CardHexVal, 

        Card,

       hex(cast([Card] as blob)) AS CardHex,

        InputNo, 

        Template, 

        Privilege, 

        IsEnabled 

    FROM tblDemographicsData DGD 

    LEFT OUTER JOIN tblBiometircsData BMD 

        on DGD.UserId = BMD.UserID 

    ORDER BY CAST(DGD.UserId AS INTEGER), InputNo Asc

Contact for Support ersonu31@gmail.com