private MetaDataKeyListModel GetMetaDataKeyListModelWithEmptyRow(Int32 informationTypeID)
{
List <MetaDataKeyDTO> metaDataKeys = MetaDAC.GetMetaDataKeys(informationTypeID);
MetaDataKeyDTO emptyMetaDataKey = new MetaDataKeyDTO();
emptyMetaDataKey.InformationTypeID = informationTypeID;
emptyMetaDataKey.Title = "";
emptyMetaDataKey.RegEx = "";
metaDataKeys.Add(emptyMetaDataKey);
MetaDataKeyListModel metaDataKeyListModel = new MetaDataKeyListModel
{
InformationType = InformationTypeDAC.GetInformationType(informationTypeID, ContextManager.Current.SelectedAreaID.Value),
MetaDataKeys = metaDataKeys
};
return(metaDataKeyListModel);
}
public static Int32 StoreKey(MetaDataKeyDTO metaDataKey)
{
using (SqlConnection cnn = WordDAC.NewConnection)
using (SqlCommand cmd = cnn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[meta_pkg.store_key]";
SqlParameter idParam = cmd.Parameters.Add("id", SqlDbType.Int);
idParam.Value = (metaDataKey.ID.HasValue) ? (object)metaDataKey.ID.Value : DBNull.Value;
idParam.Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@title", metaDataKey.Title);
cmd.Parameters.AddWithValue("@regex", metaDataKey.RegEx);
cmd.Parameters.AddWithValue("@information_type_id", metaDataKey.InformationTypeID);
cnn.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(idParam.Value));
}
}
