public Tuple <List <StudentCheckTime>, List <StudentCheckTime> > GetStudentCheckTimesExit(string date)
{
var data = DbfDataConnection.GetStudentCheckTimes(GlobalConfig.DbfPath, date);
if (data.ToList().Count == 0)
{
List <StudentCheckTime> item1 = new List <StudentCheckTime>();
List <StudentCheckTime> item2 = new List <StudentCheckTime>();
return(Tuple.Create(item1, item2));
}
var exitStartTime = GlobalConfig.AppSettings("exitStartTime").Split(':');
var exitEndTime = GlobalConfig.AppSettings("exitEndTime").Split(':');
var timeStart = new TimeSpan(int.Parse(exitStartTime[0]), int.Parse(exitStartTime[1]), int.Parse(exitStartTime[2]));
var timeEnd = new TimeSpan(int.Parse(exitEndTime[0]), int.Parse(exitEndTime[1]), int.Parse(exitEndTime[2]));
// get student exit from dbf file
var studentsExitDbf = GetStudentCheckTimes(data, timeStart, timeEnd);
// get student entry from MySql
var studentsExitDb = MySqlDataConnection.GetStudentCheckTimes(date.GetDate(), timeStart, timeEnd);
// get diff between dbf and mysql
var studentsExit = studentsExitDbf.Where(s => !studentsExitDb.Any(s2 => s2.EmpId == s.EmpId));
return(Tuple.Create(studentsExit.StudentCheckTimesFirstTime(), studentsExitDbf.StudentCheckTimesFirstTime()));
}
public List <StudentCheckTime> GetStudentsExitDbf(string date)
{
var data = DbfDataConnection.GetStudentCheckTimes(GlobalConfig.DbfPath, date);
if (date.ToList().Count == 0)
{
return(new List <StudentCheckTime>());
}
var exitStartTime = GlobalConfig.AppSettings("exitStartTime").Split(':');
var exitEndTime = GlobalConfig.AppSettings("exitEndTime").Split(':');
var timeStart = new TimeSpan(int.Parse(exitStartTime[0]), int.Parse(exitStartTime[1]), int.Parse(exitStartTime[2]));
var timeEnd = new TimeSpan(int.Parse(exitEndTime[0]), int.Parse(exitEndTime[1]), int.Parse(exitEndTime[2]));
// get student exit from dbf file
var studentsExitDbf = GetStudentCheckTimes(data, timeStart, timeEnd);
return(studentsExitDbf.StudentCheckTimesFirstTime());
}
