public void InsertList([FromBody] List <CheckInOut> list)
{
CheckInOutRepository checkInOutRepository = new CheckInOutRepository(new Domain.Staff.ErpStaffDbContext());
foreach (var item in list)
{
checkInOutRepository.InsertCheckInOut(item);
}
//Xóa trùng lặp
string sqlQuery = " WITH CTE AS " +
" ( SELECT TimeStr, UserEnrollNumber, ROW_NUMBER() OVER ( PARTITION BY TimeStr,UserEnrollNumber ORDER BY TimeStr DESC,UserEnrollNumber) AS RowID "+
" FROM [dbo].[CheckInOut] ) " +
" DELETE FROM CTE " +
" WHERE RowID > 1; ";
Domain.Helper.SqlHelper.ExecuteSQL(sqlQuery);
}
public void InsertList([FromBody] CheckInOutInsertListModel model)
{
if (model.ListCheckInOut != null && model.ListCheckInOut.Count > 0)
{
CheckInOutRepository checkInOutRepository = new CheckInOutRepository(new Domain.Staff.ErpStaffDbContext());
foreach (var item in model.ListCheckInOut)
{
item.CreatedDate = DateTime.Now;
checkInOutRepository.InsertCheckInOut(item);
}
//Xóa trùng lặp
string sqlQuery = " WITH CTE AS " +
" ( SELECT FPMachineId, TimeStr, UserId, ROW_NUMBER() OVER ( PARTITION BY FPMachineId, TimeStr, UserId ORDER BY TimeStr DESC, UserId, FPMachineId) AS RowID "+
" FROM [dbo].[Staff_CheckInOut] ) " +
" DELETE FROM CTE " +
" WHERE RowID > 1; ";
Domain.Helper.SqlHelper.ExecuteSQL(sqlQuery);
}
}
public void Insert([FromBody] CheckInOut checkInOut)
{
CheckInOutRepository checkInOutRepository = new CheckInOutRepository(new Domain.Staff.ErpStaffDbContext());
checkInOutRepository.InsertCheckInOut(checkInOut);
}