public async Task <int> SyncUsers(string userid, string token)
{
// 先到clockify获取数据
var ls = await _clockifyService.GetUsers(userid, token);
var employees = new List <Employee>();
var employeeTitles = new List <EmployeeTitle>();
foreach (var l in ls)
{
employees.Add(new Employee()
{
Gid = l.id,
FullName = l.name,
Email = l.email,
ProfilePicture = l.profilePicture,
Status = l.status,
CreatedDate = DateTime.Now,
CreatedUserID = userid,
CreatedUserName = userid,
IsDeleted = false,
UpdatedDate = DateTime.Now,
UpdatedUserID = userid,
UpdatedUserName = userid
});
employeeTitles.Add(new EmployeeTitle()
{
EmployeeGid = l.id,
IsDeleted = false,
IsLatest = true,
Month = DateTime.Now.ToString("yyyyMM"),
RoleId = 0
});
}
// 然后在本地插入或者同步数据
await _employeeService.Clear();
await _employeeTitleService.SqlExecuteNonQuery($"delete from EmployeeTitle where Month>='{DateTime.Now.ToString("yyyyMM")}' and Month<'{DateTime.Now.AddMonths(1).ToString("yyyyMM")}'");
var affectedRecordCount = await _employeeService.AddManyAsync(employees);
affectedRecordCount = await _employeeTitleService.AddManyAsync(employeeTitles);
return(affectedRecordCount);
}
