private void UpdateDateRange(DateRangeRuleConfiguration config)
{
var sql = @"
UPDATE
DateRangeRule
SET
AvailabilityStatusId = @AvailabilityStatusId,
EventId = @EventId,
EndDate = @EndDate,
EndTime = @EndTime,
StartDate = @StartDate,
StartTime = @StartTime
WHERE
Id = @Id" ;
var parameters = new[]
{
new SqlParameter("@Id", config.Id),
new SqlParameter("@AvailabilityStatusId", config.AvailabilityStatus),
new SqlParameter("@EventId", (object)config.EventId ?? DBNull.Value),
new SqlParameter("@EndDate", (object)config.EndDate ?? DBNull.Value),
new SqlParameter("@EndTime", (object)config.EndTime ?? DBNull.Value),
new SqlParameter("@StartDate", config.StartDate),
new SqlParameter("@StartTime", (object)config.StartTime ?? DBNull.Value)
};
ExecuteNonQuery(sql, parameters);
}
private void DeleteDateRange(DateRangeRuleConfiguration config)
{
var sql = "DELETE FROM DateRangeRule WHERE RuleId = @Id";
var parameter = new SqlParameter("@Id", config.RuleId);
ExecuteNonQuery(sql, parameter);
}
public static void MapFromEntity(this DateRangeRuleModel model, DateRangeRuleConfiguration rule)
{
model.Id = rule.Id;
model.EventId = rule.EventId;
model.EndDate = rule.EndDate.ToString("dd.MM.yyyy");
model.EndTime = rule.EndTime.ToString("hh\\:mm");
model.StartDate = rule.StartDate.ToString("dd.MM.yyyy");
model.StartTime = rule.StartTime.ToString("hh\\:mm");
model.Status = rule.AvailabilityStatus;
}
private RuleConfiguration MapDateRange(SqlDataReader reader)
{
var config = new DateRangeRuleConfiguration();
config.Id = (int)reader["dr_Id"];
config.AvailabilityStatus = (AvailabilityStatus)reader["dr_AvailabilityStatusId"];
config.EventId = reader["dr_EventId"] as int?;
config.EndDate = reader["dr_EndDate"] as DateTime?;
config.EndTime = reader["dr_EndTime"] as TimeSpan?;
config.StartDate = (DateTime)reader["dr_StartDate"];
config.StartTime = reader["dr_StartTime"] as TimeSpan?;
return(config);
}
public static void MapToEntity(this DateRangeRuleModel model, DateRangeRuleConfiguration rule)
{
if (model.Id.HasValue)
{
rule.Id = model.Id.Value;
}
rule.AvailabilityStatus = model.Status.Value;
rule.EventId = model.EventId;
rule.EndDate = DateTimeUtility.NullableDateTimeFor(model.EndDate);
rule.EndTime = DateTimeUtility.NullableTimeSpanFor(model.EndTime);
rule.StartDate = DateTime.Parse(model.StartDate);
rule.StartTime = DateTimeUtility.NullableTimeSpanFor(model.StartTime);
}
private MvcHtmlString DateRangeDetails(DateRangeRuleConfiguration config)
{
var builder = new StringBuilder();
var eventName = Events.FirstOrDefault(e => e.Id == config.EventId)?.Name ?? Strings.Admin.Settings.DeactivatedEvent;
var scope = !config.EventId.HasValue ? Strings.Admin.RuleDetails.ScopeAllEvents : eventName;
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelStatus, Strings.Admin.GetStatusName(config.AvailabilityStatus));
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelRuleScope, scope);
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelStartDate, config.StartDate.ToShortDateString());
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelStartTime, config.StartTime.HasValue ? config.StartTime.Value.ToString("hh\\:mm") : "-");
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelEndDate, config.EndDate.HasValue ? config.EndDate.Value.ToShortDateString() : "-");
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelEndTime, config.EndTime.HasValue ? config.EndTime.Value.ToString("hh\\:mm") : "-");
return(new MvcHtmlString(builder.ToString()));
}
private void SaveDateRange(DateRangeRuleConfiguration config)
{
var sql = @"
INSERT INTO
DateRangeRule(RuleId, AvailabilityStatusId, EventId, EndDate, EndTime, StartDate, StartTime)
VALUES
(@RuleId, @AvailabilityStatusId, @EventId, @EndDate, @EndTime, @StartDate, @StartTime)" ;
var parameters = new[]
{
new SqlParameter("@RuleId", config.RuleId),
new SqlParameter("@AvailabilityStatusId", config.AvailabilityStatus),
new SqlParameter("@EventId", (object)config.EventId ?? DBNull.Value),
new SqlParameter("@EndDate", (object)config.EndDate ?? DBNull.Value),
new SqlParameter("@EndTime", (object)config.EndTime ?? DBNull.Value),
new SqlParameter("@StartDate", config.StartDate),
new SqlParameter("@StartTime", (object)config.StartTime ?? DBNull.Value)
};
ExecuteNonQuery(sql, parameters);
}
