/// <summary>
/// Updates frequency step.
/// </summary>
/// <param name="dto">The DTO object.</param>
/// <exception cref="System.ArgumentNullException"></exception>
/// <exception cref="System.ArgumentException">The input DTO is null.</exception>
public void UpdateFrequencyStep(FrequencyStepDto dto)
{
if (dto == null) throw new ArgumentNullException(string.Format(CultureInfo.InvariantCulture, Resources.NullArguementException, "dto"));
const string CommandText = @"
UPDATE [dbo].[stepFrequency]
SET [Hours] = @Hours ,
[IsFrequencyEvent] = @IsFrequencyEvent ,
[SelectedFields] = @SelectedFields
WHERE FieldId = @fieldId";
using (var cmd = new SqlCommand(CommandText))
{
cmd.Parameters.AddWithValue("@fieldId", dto.FieldId);
cmd.Parameters.AddWithValue("@Hours", dto.Hours);
cmd.Parameters.AddWithValue("@IsFrequencyEvent", dto.IsFrequencyEvent);
cmd.Parameters.AddWithValue("@SelectedFields", dto.SelectedFields);
Database.Execute(cmd);
}
}
/// <summary>
/// Inserts frequency step.
/// </summary>
/// <param name="dto">The DTO object.</param>
/// <exception cref="System.ArgumentNullException">The input DTO is null.</exception>
public void InsertFrequencyStep(FrequencyStepDto dto)
{
if (dto == null) throw new ArgumentNullException(string.Format(CultureInfo.InvariantCulture, Resources.NullArguementException, "dto"));
const string CommandText = @"
INSERT INTO [dbo].[stepFrequency]
([FieldId]
,[Hours]
,[IsFrequencyEvent]
,[SelectedFields])
VALUES
(@FieldId
,@Hours
,@IsFrequencyEvent
,@SelectedFields)";
using (var cmd = new SqlCommand(CommandText))
{
cmd.Parameters.AddWithValue("@fieldId", dto.FieldId);
cmd.Parameters.AddWithValue("@Hours", dto.Hours);
cmd.Parameters.AddWithValue("@IsFrequencyEvent", dto.IsFrequencyEvent);
cmd.Parameters.AddWithValue("@SelectedFields", dto.SelectedFields);
Database.Execute(cmd);
}
}
