public int RemoveAndInsert(RedirectManagerModel model)
{
var sql = $"delete from RedirectManager where OldUrl = '{model.OldUrl}'; " +
$"insert into RedirectManager values ('{model.OldUrl}', '{model.NewUrl}', {model.Type}, {(model.IncludeQuery ? 1 : 0)})";
Logger.Debug("Start RemoveAndInsert()");
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteNonQuery(sql));
}
public int InsertOrUpdate(RedirectManagerModel model)
{
var sql = $"insert into RedirectManager values ('{model.OldUrl}', '{model.NewUrl}', {model.Type}, {(model.IncludeQuery ? 1 : 0)})";
if (model.Id > 0)
{
sql = $"UPDATE RedirectManager SET OldUrl = '{model.OldUrl}', NewUrl = '{model.NewUrl}', RedirectType = {model.Type}, IncludeQuery = {(model.IncludeQuery ? 1 : 0)} where id = {model.Id}";
}
Logger.Debug("Start InsertOrUpdate()");
Logger.Debug($"SQL: {sql}");
return(SqlUtil.ExecuteNonQuery(sql));
}
