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