private void DeleteMultipleBooking(MultipleBookingRuleConfiguration config)
{
var sql = "DELETE FROM MultipleBookingRule WHERE RuleId = @Id";
var parameter = new SqlParameter("@Id", config.RuleId);
ExecuteNonQuery(sql, parameter);
}
private MvcHtmlString MultipleBookingDetails(MultipleBookingRuleConfiguration 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.InputLabelNumberOfParallelBookings, config.NumberOfParallelBookings);
return(new MvcHtmlString(builder.ToString()));
}
public static void MapToEntity(this MultipleBookingRuleModel model, MultipleBookingRuleConfiguration rule)
{
if (model.Id.HasValue)
{
rule.Id = model.Id.Value;
}
rule.EventId = model.EventId.Value;
rule.NumberOfParallelBookings = model.NumberOfParallelBookings.Value;
}
private RuleConfiguration MapMultipleBooking(SqlDataReader reader)
{
var config = new MultipleBookingRuleConfiguration();
config.Id = (int)reader["mb_Id"];
config.EventId = (int)reader["mb_EventId"];
config.NumberOfParallelBookings = (int)reader["mb_NumberOfParallelBookings"];
return(config);
}
private void SaveMultipleBooking(MultipleBookingRuleConfiguration config)
{
var sql = @"
INSERT INTO
MultipleBookingRule(RuleId, EventId, NumberOfParallelBookings)
VALUES
(@RuleId, @EventId, @NumberOfParallelBookings)" ;
var parameters = new[]
{
new SqlParameter("@RuleId", config.RuleId),
new SqlParameter("@EventId", config.EventId),
new SqlParameter("@NumberOfParallelBookings", config.NumberOfParallelBookings)
};
ExecuteNonQuery(sql, parameters);
}
private void UpdateMultipleBooking(MultipleBookingRuleConfiguration config)
{
var sql = @"
UPDATE
MultipleBookingRule
SET
RuleId = @RuleId,
EventId = @EventId,
NumberOfParallelBookings = @NumberOfParallelBookings
WHERE
Id = @Id" ;
var parameters = new[]
{
new SqlParameter("@Id", config.Id),
new SqlParameter("@RuleId", config.RuleId),
new SqlParameter("@EventId", config.EventId),
new SqlParameter("@NumberOfParallelBookings", config.NumberOfParallelBookings)
};
ExecuteNonQuery(sql, parameters);
}
public static void MapFromEntity(this MultipleBookingRuleModel model, MultipleBookingRuleConfiguration rule)
{
model.Id = rule.Id;
model.EventId = rule.EventId;
model.NumberOfParallelBookings = rule.NumberOfParallelBookings;
}
