//public ActionResult SaveRateTable(LookupTableModel model)
//{
// TableStrategy.SaveRatingTableModel(model);
// return View("RatingTables", TableStrategy.GetRatingTables());
//}
public ActionResult SaveLookupTableKey(LookupTableKeyModel model)
{
TableStrategy.SaveLookupTableKey(model);
return View(TableStrategy.GetLookupTable(model.TableId));
}
public virtual void SaveLookupTableKey(LookupTableKeyModel model)
{
if(model == null)
throw new ArgumentNullException("model");
var lookupTable = GetLookupTable(model.TableId);
var parameters = new Dictionary<string, object>();
parameters["Table"] = model.TableName;
parameters["Schema"] = model.TableSchema;
parameters["Property"] = "LookupType";
parameters["Value"] = model.LookupType.ToString();
parameters["Column"] = model.Name;
using (var command = _contexts[lookupTable.Properties.Context].GetCommand(LookupTableCommand.SaveLookupTableKey))
{
command.Execute(parameters);
}
}
public void SaveLookupTableKey(LookupTableKeyModel model)
{
RatingTableQuery(FlatTableQueries.UpdateColumnExtendedProperty(model.TableName, model.Name, "LookupType", model.LookupType.ToString()));
}
