private void DeleteMinimumDate(MinimumDateRuleConfiguration config)
{
var sql = "DELETE FROM MinimumDateRule WHERE RuleId = @Id";
var parameter = new SqlParameter("@Id", config.RuleId);
ExecuteNonQuery(sql, parameter);
}
private MvcHtmlString MinimumDateDetails(MinimumDateRuleConfiguration config)
{
var builder = new StringBuilder();
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelDate, config.Date.HasValue ? config.Date.Value.ToShortDateString() : "-");
builder.AppendFormat("{0}: {1}<br />", Strings.Admin.RuleDetails.InputLabelDays, config.Days.HasValue ? config.Days.ToString() : "-");
return(new MvcHtmlString(builder.ToString()));
}
private RuleConfiguration MapMinimumDate(SqlDataReader reader)
{
var config = new MinimumDateRuleConfiguration();
config.Id = (int)reader["md_Id"];
config.Date = reader["md_Date"] as DateTime?;
config.Days = reader["md_Days"] as int?;
return(config);
}
public static void MapToEntity(this MinimumDateRuleModel model, MinimumDateRuleConfiguration rule)
{
if (model.Id.HasValue)
{
rule.Id = model.Id.Value;
}
rule.Date = DateTimeUtility.NullableDateTimeFor(model.Date);
rule.Days = model.Days;
}
private void SaveMinimumDate(MinimumDateRuleConfiguration config)
{
var sql = @"
INSERT INTO
MinimumDateRule(RuleId, Date, Days)
VALUES
(@RuleId, @Date, @Days)" ;
var parameters = new[]
{
new SqlParameter("@RuleId", config.RuleId),
new SqlParameter("@Date", (object)config.Date ?? DBNull.Value),
new SqlParameter("@Days", (object)config.Days ?? DBNull.Value)
};
ExecuteNonQuery(sql, parameters);
}
private void UpdateMinimumDate(MinimumDateRuleConfiguration config)
{
var sql = @"
UPDATE
MinimumDateRule
SET
[Date] = @Date,
[Days] = @Days
WHERE
Id = @Id" ;
var parameters = new[]
{
new SqlParameter("@Id", config.Id),
new SqlParameter("@Date", (object)config.Date ?? DBNull.Value),
new SqlParameter("@Days", (object)config.Days ?? DBNull.Value)
};
ExecuteNonQuery(sql, parameters);
}
public static void MapFromEntity(this MinimumDateRuleModel model, MinimumDateRuleConfiguration rule)
{
model.Id = rule.Id;
model.Date = rule.Date.ToString("dd.MM.yyyy");
model.Days = rule.Days;
}
