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); }