public static void MapFromEntity(this EventDurationRuleModel model, EventDurationRuleConfiguration rule)
{
model.Id = rule.Id;
model.EventId = rule.EventId;
model.EndDate = rule.EndDate.ToString("dd.MM.yyyy");
model.StartDate = rule.StartDate.ToString("dd.MM.yyyy");
}
private void DeleteEventDuration(EventDurationRuleConfiguration config)
{
var sql = "DELETE FROM EventDurationRule WHERE RuleId = @Id";
var parameter = new SqlParameter("@Id", config.RuleId);
ExecuteNonQuery(sql, parameter);
}
private MvcHtmlString EventDurationDetails(EventDurationRuleConfiguration config)
{
var builder = new StringBuilder();
var eventName = Events.FirstOrDefault(e => e.Id == config.EventId)?.Name ?? Strings.Admin.Settings.DeactivatedEvent;
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelEvent, eventName);
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelStartDate, config.StartDate.ToShortDateString());
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelEndDate, config.EndDate.ToShortDateString());
return(new MvcHtmlString(builder.ToString()));
}
public static void MapToEntity(this EventDurationRuleModel model, EventDurationRuleConfiguration rule)
{
if (model.Id.HasValue)
{
rule.Id = model.Id.Value;
}
rule.EventId = model.EventId.Value;
rule.EndDate = DateTime.Parse(model.EndDate);
rule.StartDate = DateTime.Parse(model.StartDate);
}
private RuleConfiguration MapEventDuration(SqlDataReader reader)
{
var config = new EventDurationRuleConfiguration();
config.Id = (int)reader["ed_Id"];
config.EventId = (int)reader["ed_EventId"];
config.EndDate = (DateTime)reader["ed_EndDate"];
config.StartDate = (DateTime)reader["ed_StartDate"];
return(config);
}
private void SaveEventDuration(EventDurationRuleConfiguration config)
{
var sql = @"
INSERT INTO
EventDurationRule(RuleId, EventId, StartDate, EndDate)
VALUES
(@RuleId, @EventId, @StartDate, @EndDate)" ;
var parameters = new[]
{
new SqlParameter("@RuleId", config.RuleId),
new SqlParameter("@EventId", config.EventId),
new SqlParameter("@StartDate", config.StartDate),
new SqlParameter("@EndDate", config.EndDate)
};
ExecuteNonQuery(sql, parameters);
}
private void UpdateEventDuration(EventDurationRuleConfiguration config)
{
var sql = @"
UPDATE
EventDurationRule
SET
EventId = @EventId,
StartDate = @StartDate,
EndDate = @EndDate
WHERE
Id = @Id" ;
var parameters = new[]
{
new SqlParameter("@Id", config.Id),
new SqlParameter("@EventId", config.EventId),
new SqlParameter("@StartDate", config.StartDate),
new SqlParameter("@EndDate", config.EndDate),
};
ExecuteNonQuery(sql, parameters);
}
