private async Task <long> ReorderMasterAmenities(ReorderRowsByIcon input)
{
long affectedRows = 0;
try
{
UnitOfWorkManager.Current.DisableFilter(AbpDataFilters.MayHaveTenant);
List <SqlParameter> pc = new List <SqlParameter>
{
new SqlParameter("PresentRowNewId", input.PresentRowNewId),
new SqlParameter("NewRowOrderValue", input.NewRowOrderValue),
new SqlParameter("Parentid ", input.ParentId)
};
var ID = await CurrentUnitOfWork.GetDbContext <CruisePMSDbContext>().Database.ExecuteSqlRawAsync("ReorderMasterAmenities @PresentRowNewId, @NewRowOrderValue,@Parentid", pc.ToArray());
if (ID > 0 || ID < 0 || ID == 0)
{
}
else
{
affectedRows = 0;
};
await CurrentUnitOfWork.SaveChangesAsync();
}
catch (Exception ex)
{
}
return(affectedRows);
}
public async Task <List <UserReportDto> > GetUsersByShiftId(int shiftId)
{
var command = CurrentUnitOfWork.GetDbContext <AttendanceDbContext>().Database.GetDbConnection().CreateCommand();
command.CommandText = "GetEmployeeByShift";
command.CommandType = CommandType.StoredProcedure;
command.Transaction = (DbTransaction)_transactionProvider.GetActiveTransaction(new ActiveTransactionProviderArgs {
{ "ContextType", typeof(AttendanceDbContext) }, { "MultiTenancySide", MultiTenancySides.Tenant }
});
var param = new SqlParameter("@shiftId", shiftId);
command.Parameters.Add(param);
using (var dataReader = await command.ExecuteReaderAsync())
{
var result = new List <UserReportDto>();
while (dataReader.Read())
{
result.Add(new UserReportDto()
{
UserId = (int)(long)dataReader[0],
UserName = dataReader[1].ToString(),
ShiftName = dataReader[2].ToString(),
ShiftId = (int)dataReader[3],
StartDate = DateTime.Parse(dataReader[4].ToString()),
EndDate = DateTime.Parse(dataReader[5].ToString())
});;
}
return(result);
}
}
public async Task <List <EmployeeReportOutput> > CalculateDaysReport(ReportInput input)
{
try
{
var formattedQuery = $"exec CalculateDays '{input.FromDate.ToString("yyyy-MM-dd")}','{input.ToDate.ToString("yyyy-MM-dd")}' , '{input.Type}','{input.DaysCount}'";
var result = await CurrentUnitOfWork.GetDbContext <AttendanceDbContext>().EmployeeReportCore.FromSqlRaw(formattedQuery).ToListAsync();
var output = ObjectMapper.Map <List <EmployeeReportOutput> >(result);
return(output);
}
catch (Exception ex)
{
throw;
}
}
public async Task <List <FingerReportOutput> > GenerateFingerReport(ReportInput input)
{
try
{
var formattedQuery = $"exec SP_Transaction_Rpt_Emp_Machine '{input.FromDate.ToString("yyyy-MM-dd")}','{input.ToDate.ToString("yyyy-MM-dd")}','{string.Join(",", input.UserIds)}' , '{GetCurrentUser().Id}',''";
var result = await CurrentUnitOfWork.GetDbContext <AttendanceDbContext>().FingerReportCore.FromSqlRaw(formattedQuery).ToListAsync();
var output = ObjectMapper.Map <List <FingerReportOutput> >(result);
return(output);
}
catch (Exception ex)
{
throw;
}
}
public async Task <List <InOutReportOutput> > GenerateInOutReport(ReportInput input)
{
try
{
var formattedQuery = $"exec SP_InOut_Summary_ByDate '{input.FromDate.ToString("yyyy-MM-dd")}','{input.ToDate.ToString("yyyy-MM-dd")}','{string.Join(",", input.UserIds)}'";
var result = await CurrentUnitOfWork.GetDbContext <AttendanceDbContext>().InOutReportOutputCore.FromSqlRaw(formattedQuery).ToListAsync();
var output = ObjectMapper.Map <List <InOutReportOutput> >(result);
return(output);
}
catch (Exception ex)
{
throw;
}
}
protected override void DoWork()
{
var twoMonthAge = Clock.Now.Subtract(TimeSpan.FromDays(60));
//删除两个月前的日志数据内容。
var audits = _auditLogRepository.GetAll().Where(a => a.ExecutionTime < twoMonthAge).ToList();
var dbdd = CurrentUnitOfWork.GetDbContext <YoyoCmsTemplateDbContext>();
dbdd.AuditLogs.RemoveRange(audits);
//foreach (var item in audits)
//{
//_auditLogRepository.Delete(item);
//}
CurrentUnitOfWork.SaveChanges();
}