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)); } }