private void createConnection() { try { string connectionString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)" + "(HOST=" + netDet.IP_DB + ")(PORT=" + netDet.PORT_DB + ")))" + "(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=" + netDet.SID + ")));" + "User Id=" + netDet.DBNAME + ";Password= "******";"; // string connectionString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=" + netDet.IP_DB + ")(PORT=" + netDet.PORT_DB + "))" + //"(CONNECT_DATA=(SID=" + netDet.SID + ")));User Id=" + netDet.DBNAME + ";Password="******";"; orcConn = new OracleConnection(connectionString); orcConn.Open(); NotificationHelper.CreateNotification("Connection Opened"); FileHelper.writeToLog("\r\n" + "Connection Opened"); } catch (Exception e) { NotificationHelper.CreateNotification(e.Message); FileHelper.writeToLog(e.Message); } }
public List <Record> getAllLogData() { List <Record> records = new List <Record>(); if (!open()) { return(records); } int idwErrorCode = 0; string sdwEnrollNumber = ""; int idwVerifyMode = 0; int idwInOutMode = 0; int idwYear = 0; int idwMonth = 0; int idwDay = 0; int idwHour = 0; int idwMinute = 0; int idwSecond = 0; int idwWorkcode = 0; axCZKEM1.EnableDevice(iMachineNumber, false); //disable the device if (axCZKEM1.ReadGeneralLogData(iMachineNumber)) //read all the attendance records to the memory { while (axCZKEM1.SSR_GetGeneralLogData(iMachineNumber, out sdwEnrollNumber, out idwVerifyMode, out idwInOutMode, out idwYear, out idwMonth, out idwDay, out idwHour, out idwMinute, out idwSecond, ref idwWorkcode))//get records from the memory { string hour = idwHour.ToString(), min = idwMinute.ToString(); if (hour.Length == 1) { hour = "0" + hour; } if (min.Length == 1) { min = "0" + min; } Record record = new Record(int.Parse(sdwEnrollNumber), idwMonth.ToString() + "/" + idwDay.ToString() + "/" + idwYear.ToString(), hour + "." + min); records.Add(record); } axCZKEM1.EnableDevice(iMachineNumber, true);//enable the device axCZKEM1.Disconnect(); return(records); } else { axCZKEM1.GetLastError(ref idwErrorCode); if (idwErrorCode != 0) { NotificationHelper.CreateNotification("Reading data from terminal failed,ErrorCode: " + idwErrorCode.ToString()); FileHelper.writeToLog("Reading data from terminal failed,ErrorCode: " + idwErrorCode.ToString(), "Error"); } else { NotificationHelper.CreateNotification("No data from terminal returns!"); FileHelper.writeToLog("No data from terminal returns!", "Error"); } } return(null); }