public static DataTable Search(ConnectionStringXApplicationDataModel data, RequestProfile requestProfile)
{
var list = GetEntityDetails(data, requestProfile, 0);
var dt = list.ToDataTable();
return(dt);
}
public IEnumerable <ConnectionStringXApplicationDataModel> ListDatabaseNames()
{
var data = new ConnectionStringXApplicationDataModel();
var listConnectionStrings = ConnectionStringXApplicationDataManager.GetEntityDetails(data, SessionVariables.RequestProfile, ApplicationCommon.ReturnAuditInfo);
return(listConnectionStrings);
}
public static List <ConnectionStringXApplicationDataModel> GetEntityDetails(ConnectionStringXApplicationDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails)
{
const string sql = @"dbo.ConnectionStringXApplicationSearch ";
var parameters =
new
{
AuditId = requestProfile.AuditId
, ApplicationId = requestProfile.ApplicationId
, ConnectionStringId = dataQuery.ConnectionStringId
, ConnectionStringXApplicationId = dataQuery.ConnectionStringXApplicationId
};
List <ConnectionStringXApplicationDataModel> result;
using (var dataAccess = new DataAccessBase(DataStoreKey))
{
result = dataAccess.Connection.Query <ConnectionStringXApplicationDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList();
}
return(result);
}
public static string ToSQLParameter(ConnectionStringXApplicationDataModel data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId:
if (data.ConnectionStringXApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId, data.ConnectionStringXApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringXApplicationId);
}
break;
case ConnectionStringXApplicationDataModel.DataColumns.ApplicationId:
if (data.ApplicationId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ApplicationId, data.ApplicationId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ApplicationId);
}
break;
case ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId:
if (data.ConnectionStringId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId, data.ConnectionStringId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionStringId);
}
break;
case ConnectionStringXApplicationDataModel.DataColumns.ConnectionString:
if (!string.IsNullOrEmpty(data.ConnectionString))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringXApplicationDataModel.DataColumns.ConnectionString, data.ConnectionString);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.ConnectionString);
}
break;
case ConnectionStringXApplicationDataModel.DataColumns.Application:
if (!string.IsNullOrEmpty(data.Application))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ConnectionStringXApplicationDataModel.DataColumns.Application, data.Application);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ConnectionStringXApplicationDataModel.DataColumns.Application);
}
break;
default:
returnValue = BaseDataManager.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
