private void UpdateEventGroup(EventGroupRuleConfiguration config) { var sql = "DELETE FROM Event2EventGroupRule WHERE EventGroupRuleId = @EventGroupRuleId"; var parameters = new[] { new SqlParameter("@EventGroupRuleId", config.Id) }; ExecuteNonQuery(sql, parameters); SaveEventGroupData(config); }
private RuleConfiguration MapEventGroup(SqlDataReader reader) { var config = new EventGroupRuleConfiguration(); config.Id = (int)reader["eg_Id"]; return(config); }
public static void MapToEntity(this EventGroupRuleModel model, EventGroupRuleConfiguration rule) { if (model.Id.HasValue) { rule.Id = model.Id.Value; } rule.EventIds = model.EventIds.Select(i => int.Parse(i)).ToList(); }
private MvcHtmlString EventGroupDetails(EventGroupRuleConfiguration config) { var builder = new StringBuilder(); foreach (var id in config.EventIds) { builder.AppendFormat("- {0}<br />", Events.FirstOrDefault(e => e.Id == id)?.Name ?? Strings.Admin.Settings.DeactivatedEvent); } return(new MvcHtmlString(builder.ToString())); }
private void DeleteEventGroup(EventGroupRuleConfiguration config) { var sql = "DELETE FROM Event2EventGroupRule WHERE EventGroupRuleId = @EventGroupRuleId"; var parameter = new SqlParameter("@EventGroupRuleId", config.Id); ExecuteNonQuery(sql, parameter); sql = "DELETE FROM EventGroupRule WHERE RuleId = @Id"; parameter = new SqlParameter("@Id", config.RuleId); ExecuteNonQuery(sql, parameter); }
private void SaveEventGroup(EventGroupRuleConfiguration config) { var sql = @" INSERT INTO EventGroupRule(RuleId) VALUES (@RuleId); SELECT SCOPE_IDENTITY()" ; var parameters = new[] { new SqlParameter("@RuleId", config.RuleId) }; config.Id = Convert.ToInt32(ExecuteScalar(sql, parameters)); SaveEventGroupData(config); }
private void SaveEventGroupData(EventGroupRuleConfiguration config) { foreach (var id in config.EventIds) { var sql = @" INSERT INTO Event2EventGroupRule(EventId, EventGroupRuleId) VALUES (@EventId, @EventGroupRuleId)" ; var parameters = new[] { new SqlParameter("@EventId", id), new SqlParameter("@EventGroupRuleId", config.Id) }; ExecuteNonQuery(sql, parameters); } }
private void LoadEventGroupData(EventGroupRuleConfiguration config) { var sql = "SELECT * FROM Event2EventGroupRule WHERE EventGroupRuleId = @Id"; var parameter = new SqlParameter("@Id", config.Id); using (var transaction = new TransactionScope()) using (var connection = NewSqlConnection()) using (var command = new SqlCommand(sql, connection)) { connection.Open(); command.Parameters.Add(parameter); using (var reader = command.ExecuteReader()) { while (reader.Read()) { config.EventIds.Add((int)reader["EventId"]); } } transaction.Complete(); } }
public static void MapFromEntity(this EventGroupRuleModel model, EventGroupRuleConfiguration rule) { model.Id = rule.Id; model.EventIds = rule.EventIds.Select(i => i.ToString()).ToArray(); }