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