private static SchedulerDailyInfo ReadInfo(SqlDataReader reader)
{
var info = new SchedulerDailyInfo
{
SchedulerDailyId = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0),
SchedulerId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1),
Unit = reader.IsDBNull(2) ? 0 : reader.GetInt32(2),
Value = reader.IsDBNull(3) ? (int?)null : reader.GetInt32(3)
};
return(info);
}
internal bool Update(Guid tenantId, SchedulerDailyInfo info)
{
try
{
var cmd = CreateProcedureCommand("dbo.SchedulerDaily_Update");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidSchedulerDailyId", info.SchedulerDailyId);
cmd.AppendGuid("@guidSchedulerId", info.SchedulerId);
cmd.AppendInt("@intUnit", info.Unit);
if (info.Value.HasValue && info.Value > 0)
{
cmd.AppendInt("@intValue", info.Value.Value);
}
ExecuteCommand(cmd);
return(true);
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "DataSchedulerDaily::SchedulerDaily_Update");
}
}
internal SchedulerDailyInfo GetSchedulerDaily(Guid tenantId, Guid schedulerId)
{
SchedulerDailyInfo info = new SchedulerDailyInfo();
try
{
var cmd = CreateProcedureCommand("dbo.SchedulerDaily_GetBySchedulerId");
cmd.AppendGuid("@guidTenantId", tenantId);
cmd.AppendGuid("@guidSchedulerId", schedulerId);
using (SqlDataReader reader = ExecuteCommandAndReturnReader(cmd))
{
while (reader.Read())
{
info = ReadInfo(reader);
}
}
}
catch (SqlException e)
{
throw ReportAndTranslateException(e, "DataSchedulerDaily::SchedulerDaily_GetBySchedulerId");
}
return(info);
}
bool IAdminSchedulerDaily.Update(Guid tenantId, SchedulerDailyInfo info)
{
return(_data.Update(tenantId, info));
}
bool IManagerSchedulerDaily.Update(Guid tenantId, SchedulerDailyInfo info)
{
return(_admin.Update(tenantId, info));
}
Guid IManagerSchedulerDaily.Create(Guid tenantId, SchedulerDailyInfo info)
{
info.SchedulerDailyId = Guid.NewGuid();
_admin.Create(tenantId, info);
return(info.SchedulerDailyId);
}
