public DepartmentSetting GetDepartmentSettingBySettingType(string setting, DepartmentSettingTypes type)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
return(db.Query <DepartmentSetting>(@"SELECT ds.* FROM DepartmentSettings ds
WHERE ds.Setting = @setting AND ds.SettingType = @settingType" ,
new { setting = setting, settingType = type }).FirstOrDefault());
}
}
public DepartmentSetting GetDepartmentSettingByIdType(int departmentId, DepartmentSettingTypes type)
{
using (IDbConnection db = new SqlConnection(connectionString))
{
return(db.Query <DepartmentSetting>(@"SELECT ds.* FROM DepartmentSettings ds
WHERE ds.DepartmentId = @departmentId AND ds.SettingType = @settingType" ,
new { departmentId = departmentId, settingType = type }).FirstOrDefault());
}
}
public void DeleteSetting(int departmentId, DepartmentSettingTypes type)
{
var savedSetting = (from set in _departmentSettingsRepository.GetAll()
where set.DepartmentId == departmentId && set.SettingType == (int)type
select set).FirstOrDefault();
if (savedSetting != null)
{
_departmentSettingsRepository.DeleteOnSubmit(savedSetting);
}
}
public async Task <bool> DeleteSettingAsync(int departmentId, DepartmentSettingTypes type, CancellationToken cancellationToken = default(CancellationToken))
{
var savedSetting = await GetSettingByDepartmentIdType(departmentId, type);
if (savedSetting != null)
{
return(await _departmentSettingsRepository.DeleteAsync(savedSetting, cancellationToken));
}
return(false);
}
public void SaveOrUpdateSetting(int departmentId, string setting, DepartmentSettingTypes type)
{
var savedSetting = (from set in _departmentSettingsRepository.GetAll()
where set.DepartmentId == departmentId && set.SettingType == (int)type
select set).FirstOrDefault();
if (savedSetting == null)
{
DepartmentSetting newSetting = new DepartmentSetting();
newSetting.DepartmentId = departmentId;
newSetting.Setting = setting;
newSetting.SettingType = (int)type;
_departmentSettingsRepository.SaveOrUpdate(newSetting);
}
else
{
savedSetting.Setting = setting;
_departmentSettingsRepository.SaveOrUpdate(savedSetting);
}
}
public DepartmentSetting GetDepartmentSettingByUserIdType(string userId, DepartmentSettingTypes type)
{
// if (IsSqlCe)
// {
// var data = db.SqlQuery<DepartmentSetting>(@"SELECT ds.* FROM DepartmentSettings ds
// INNER JOIN DepartmentMembers dm ON ds.DepartmentId = dm.DepartmentId
// WHERE dm.UserId = @UserId AND ds.SettingType = @SettingType",
// new SqlCeParameter("@UserId", userId),
// new SqlCeParameter("@SettingType", (int)type));
// return data.FirstOrDefault();
// }
// else
// {
var data = db.SqlQuery <DepartmentSetting>(@"SELECT ds.* FROM DepartmentSettings ds
INNER JOIN DepartmentMembers dm ON ds.DepartmentId = dm.DepartmentId
WHERE dm.UserId = @UserId AND ds.SettingType = @SettingType" ,
new SqlParameter("@UserId", userId),
new SqlParameter("@SettingType", (int)type));
return(data.FirstOrDefault());
//}
}
private async Task <DepartmentSetting> GetSettingBySettingTypeAsync(string setting, DepartmentSettingTypes settingType)
{
return(await _departmentSettingsRepository.GetDepartmentSettingBySettingTypeAsync(setting, settingType));
}
private async Task <DepartmentSetting> GetSettingByDepartmentIdType(int departmentId, DepartmentSettingTypes settingType)
{
return(await _departmentSettingsRepository.GetDepartmentSettingByIdTypeAsync(departmentId, settingType));
}
public async Task <DepartmentSetting> SaveOrUpdateSettingAsync(int departmentId, string setting, DepartmentSettingTypes type, CancellationToken cancellationToken = default(CancellationToken))
{
var savedSetting = await GetSettingByDepartmentIdType(departmentId, type);
if (savedSetting == null)
{
DepartmentSetting newSetting = new DepartmentSetting();
newSetting.DepartmentId = departmentId;
newSetting.Setting = setting;
newSetting.SettingType = (int)type;
return(await _departmentSettingsRepository.SaveOrUpdateAsync(newSetting, cancellationToken));
}
else
{
savedSetting.Setting = setting;
return(await _departmentSettingsRepository.SaveOrUpdateAsync(savedSetting, cancellationToken));
}
return(null);
}
public async Task <DepartmentSetting> GetDepartmentSettingByIdTypeAsync(int departmentId, DepartmentSettingTypes type)
{
try
{
var selectFunction = new Func <DbConnection, Task <DepartmentSetting> >(async x =>
{
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("DepartmentId", departmentId);
dynamicParameters.Add("SettingType", (int)type);
var query = _queryFactory.GetQuery <SelectBySettingTypeDepartmentIdQuery>();
return(await x.QueryFirstOrDefaultAsync <DepartmentSetting>(sql: query,
param: dynamicParameters,
transaction: _unitOfWork.Transaction));
});
DbConnection conn = null;
if (_unitOfWork?.Connection == null)
{
using (conn = _connectionProvider.Create())
{
await conn.OpenAsync();
return(await selectFunction(conn));
}
}
else
{
conn = _unitOfWork.CreateOrGetConnection();
return(await selectFunction(conn));
}
}
catch (Exception ex)
{
Logging.LogException(ex);
throw;
}
}
