Exemple #1
0
        public IEnumerable <StudentCheckTime> GetStudentCheckTimes(string rootPath, string date)
        {
            var results  = new List <StudentCheckTime>();
            var fullPath = rootPath.GetFullPath(date);

            if (File.Exists(fullPath))
            {
                // Protect Exception Another Process
                var fs = File.Open(fullPath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);

                using (var table = Table.Open(fs))
                {
                    var reader = table.OpenReader(Encoding.GetEncoding(874));
                    while (reader.Read())
                    {
                        decimal? cuserid = reader.GetDecimal("CUSERID") == null ? 0 : reader.GetDecimal("CUSERID");
                        DateTime?chkTime = reader.GetDateTime("CHKTIME");

                        var model = new StudentCheckTime()
                        {
                            CuserId = cuserid,
                            EmpId   = reader.GetString("EMPID"),
                            EmpName = reader.GetString("EMPNAME"),
                            ChkTime = (DateTime)chkTime
                        };

                        results.Add(model);
                    }
                }
            }

            return(results);
        }
Exemple #2
0
        public static List <StudentCheckTime> GetStudentCheckTimes(this List <StudentCheckTime> models, TimeSpan timeStart, TimeSpan timeEnd)
        {
            var results = new List <StudentCheckTime>();

            foreach (var item in models)
            {
                var chkTime = item.ChkTime;
                var time    = new TimeSpan(chkTime.Hour, chkTime.Minute, chkTime.Millisecond);

                if (time.IsBetween(timeStart, timeEnd))
                {
                    var model = new StudentCheckTime()
                    {
                        CuserId = item.CuserId,
                        EmpId   = item.EmpId,
                        EmpName = item.EmpName,
                        ChkTime = item.ChkTime
                    };

                    results.Add(model);
                }
            }

            return(results);
        }
Exemple #3
0
        public ResponseMessage SentOnceNotifyMessage(StudentCheckTime model, SentType sentType)
        {
            var result = new ResponseMessage();

            if (MySqlDataConnection.SentSuccess(model.EmpId, sentType))
            {
                result = new ResponseMessage()
                {
                    success = "1"
                };
                return(result);
            }

            var studentsAddPara = GlobalConfig.AppSettings("students");

            //var roomsAddPara = GlobalConfig.AppSettings("rooms");
            //var messageAddPara = GlobalConfig.AppSettings("message");
            //var usernameAddPara = GlobalConfig.AppSettings("username");
            //var appName = GlobalConfig.AppSettings("appName");

            #region for test
            var students = studentsAddPara.Split('|');
            if (GlobalConfig.Index > students.Length - 1)
            {
                GlobalConfig.Index = 0;
            }
            var sentStd = students[GlobalConfig.Index];
            GlobalConfig.Index += 1;
            #endregion

            var studentsReq = studentsAddPara == "" ? model.EmpId : sentStd;

            var url = GlobalConfig.AppSettings("sentMessageService")
                      .Replace("{schoolCode}", GlobalConfig.AppSettings("schoolCode"))
                      .Replace("{studentCode}", studentsReq);

            var client  = new RestClient(url);
            var request = new RestRequest(Method.POST);
            request.AddBody("content-type", "application/form-data");

            #region message
            //entry
            //ทดสอบ
            //รหัสนักเรียน
            //ชื่อ
            //เวลาเข้าเรียน

            //exit
            //ทดสอบ
            //รหัสนักเรียน
            //ชื่อ
            //เวลาเลิกเรียน
            #endregion

            request.AddParameter("students", studentsReq);
            if (sentType == SentType.Entry)
            {
                request.AddParameter("message",
                                     $"ส่งจากระบบ" + System.Environment.NewLine +
                                     $"รหัสนักเรียน: {model.EmpId}" + System.Environment.NewLine +
                                     $"ชื่อ: {model.EmpName}" + System.Environment.NewLine +
                                     $"เวลาเข้าเรียน: {model.ChkTime}");
            }
            else if (sentType == SentType.Exit)
            {
                request.AddParameter("message",
                                     $"ส่งจากระบบ" + System.Environment.NewLine +
                                     $"รหัสนักเรียน: {model.EmpId}" + System.Environment.NewLine +
                                     $"ชื่อ: {model.EmpName}" + System.Environment.NewLine +
                                     $"เวลาเลิกเรียน: {model.ChkTime}");
            }

            //request.AddParameter("rooms", roomsAddPara);
            //request.AddParameter("username", usernameAddPara);

            StudentSentMessage sentMessage = new StudentSentMessage();

            var json = client.Execute <ResponseMessage>(request).Content;
            result = JsonConvert.DeserializeObject <ResponseMessage>(json);

            //if (res != null)
            //{
            if (result.success == "1")
            {
                GlobalConfig.StudentCount += 1;
                sentMessage = new StudentSentMessage()
                {
                    EmpId    = model.EmpId,
                    Status   = $"{SentStatus.Success}",
                    SentType = sentType.ToString(),
                    SentTime = DateTime.Parse(Helper.GetDateNowStringUs("yyyy-MM-dd HH:mm:ss")),
                    ChkTime  = model.ChkTime
                };

                MySqlDataConnection.SaveStudentSentMessage(sentMessage);
            }
            else
            {
                sentMessage = new StudentSentMessage()
                {
                    EmpId    = model.EmpId,
                    Status   = $"{SentStatus.Error} : {result.error}",
                    SentType = sentType.ToString(),
                    SentTime = DateTime.Parse(Helper.GetDateNowStringUs("yyyy-MM-dd HH:mm:ss")),
                    ChkTime  = model.ChkTime
                };
                MySqlDataConnection.SaveStudentSentMessage(sentMessage);
            }
            //}

            #region sent Async

            //client.ExecuteAsync(request, response =>
            //{
            //    StudentSentMessage sentMessage = new StudentSentMessage();
            //    var json = response.Content;

            //    ResponseMessage resAsync = JsonConvert.DeserializeObject<ResponseMessage>(json);

            //    result = resAsync;

            //    if (resAsync != null)
            //    {
            //        if (resAsync.success == "1")
            //        {
            //            sentMessage = new StudentSentMessage()
            //            {
            //                EmpId = model.EmpId,
            //                Status = $"{SentStatus.Success}",
            //                SentType = sentType.ToString(),
            //                SentTime = DateTime.Parse(Helper.GetDateNowStringUs("yyyy-MM-dd HH:mm:ss")),
            //                ChkTime = model.ChkTime
            //            };

            //            MySqlDataConnection.SaveStudentSentMessage(sentMessage);
            //        }
            //        else
            //        {
            //            sentMessage = new StudentSentMessage()
            //            {
            //                EmpId = model.EmpId,
            //                Status = $"{SentStatus.Error} : {resAsync.error}",
            //                SentType = sentType.ToString(),
            //                SentTime = DateTime.Parse(Helper.GetDateNowStringUs("yyyy-MM-dd HH:mm:ss")),
            //                ChkTime = model.ChkTime
            //            };
            //            MySqlDataConnection.SaveStudentSentMessage(sentMessage);
            //        }
            //    }
            //});
            #endregion

            return(result);
        }