public static string ToSQLParameter(FieldConfigurationModeCategoryXFCModeDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryXFCModeId: if (data.FieldConfigurationModeCategoryXFCModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryXFCModeId, data.FieldConfigurationModeCategoryXFCModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryXFCModeId); } break; case FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryId: if (data.FieldConfigurationModeCategoryId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryId, data.FieldConfigurationModeCategoryId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeCategoryId); } break; case FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeId: if (data.FieldConfigurationModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FieldConfigurationModeCategoryXFCModeDataModel.DataColumns.FieldConfigurationModeId); } break; } return(returnValue); }
public static List <FieldConfigurationModeCategoryXFCModeDataModel> GetEntityDetails(FieldConfigurationModeCategoryXFCModeDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FieldConfigurationModeCategoryXFCModeSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ApplicationMode = requestProfile.ApplicationModeId , ReturnAuditInfo = returnAuditInfo , FieldConfigurationModeCategoryId = dataQuery.FieldConfigurationModeCategoryId , FieldConfigurationModeId = dataQuery.FieldConfigurationModeId }; List <FieldConfigurationModeCategoryXFCModeDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FieldConfigurationModeCategoryXFCModeDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }