static void Main(string[] args)
        {
            var seriLog = new ApplicationLogGenerator.SchedulerSerilogs();

            AccessDBReader.InitLogger(seriLog);
            AttendanceManager.InitLogger(seriLog);

            AccessDBReader.Read();
            AttendanceManager.LoadToMongoDB();

            Console.ReadLine();
        }
Esempio n. 2
0
        static void Main(string[] args)
        {
            AccessDBReader.Read();

            //var accessPoints = JsonConvert.SerializeObject(AttendanceManager.AccessPoints, Formatting.Indented);
            //System.IO.File.WriteAllText(@"C:\Temp\Attendance\AccessPoints.txt", accessPoints);

            //var employees = JsonConvert.SerializeObject(AttendanceManager.Employees, Formatting.Indented);
            //System.IO.File.WriteAllText(@"C:\Temp\Attendance\Employees.txt", employees);

            var accessEvents = JsonConvert.SerializeObject(AttendanceManager.AccessEvents, Formatting.Indented);

            System.IO.File.WriteAllText(@"C:\Temp\Attendance\AccessEvents.txt", accessEvents);

            AttendanceManager.LoadToMongoDB();
            //AttendanceManager.LoadUsersToDB();
        }
Esempio n. 3
0
        static public void ReadAccessEventLogsForMonth(int month, int year)
        {
            var tableName = "DeviceLogs_" + month.ToString() + "_" + year.ToString();

            if (!TableExists(tableName))
            {
                return;
            }

            OleDbCommand command = new OleDbCommand();

            command.Connection  = _accessDBconnection;
            command.CommandText = "select DeviceId,UserId,LogDate,DeviceLogId from " + tableName;

            OleDbDataAdapter da = new OleDbDataAdapter(command);
            DataTable        dt = new DataTable();

            da.Fill(dt);

            DataColumn UserId      = dt.Columns["UserId"];
            DataColumn DeviceId    = dt.Columns["DeviceId"];
            DataColumn LogDate     = dt.Columns["LogDate"];
            DataColumn DeviceLogId = dt.Columns["DeviceLogId"];

            List <AccessEvent> accessEvents = new List <AccessEvent>();

            foreach (DataRow row in dt.Rows)
            {
                AccessEvent d        = new AccessEvent();
                var         useId    = int.Parse(row[UserId].ToString());
                var         employee = AttendanceManager.EmployeeById(useId);
                if (employee == null)
                {
                    continue;
                }
                d.EmployeeID        = employee.ID;
                d.EmployeeFirstName = employee.FirstName;
                d.EmployeeLastName  = employee.LastName;

                var accessPoint = AttendanceManager.AccessPointById(int.Parse(row[DeviceId].ToString()));
                d.AccessPointID        = accessPoint.ID;
                d.AccessPointName      = accessPoint.Name;
                d.AccessPointIPAddress = accessPoint.IpAddress;

                var dtString = row[LogDate].ToString().Trim();
                var tokens   = dtString.Split(new char[] { ' ', '-', ':' });
                var ye       = int.Parse(tokens[2]);
                var mo       = int.Parse(tokens[1]);
                var dy       = int.Parse(tokens[0]);
                var h        = int.Parse(tokens[3]);
                var m        = int.Parse(tokens[4]);
                var s        = int.Parse(tokens[5]);
                d.EventTime = new DateTime(ye, mo, dy, h, m, s);

                var deviceLogId = row[DeviceLogId].ToString();

                var y = ye.ToString().Substring(2);

                var idStr = d.AccessPointID.ToString() + y + mo.ToString() + deviceLogId;
                var logId = int.Parse(idStr);
                d.ID = logId;

                accessEvents.Add(d);
            }

            var monthlyLog = new MonthlyAccessLog();

            monthlyLog.Month        = new DateTime(year, month, 1);
            monthlyLog.AccessEvents = accessEvents;

            AttendanceManager.MonthlyAccessLogs.Add(monthlyLog);
        }