// -----------------------------------------------------
// List available report metadata
// -----------------------------------------------------
public void ListAvailableForClient(int clientUID)
{
this.reportMetadataList = new List <ReportMetadata>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" UID " +
" ,Description " +
" ,RecordType " +
" ,FieldCode " +
" ,ClientType " +
" ,ClientUID " +
" ,InformationType " +
" ,ConditionX " +
" ,CompareWith " +
" FROM ReportMetadata " +
" WHERE RecordType = 'DF' " +
" AND FieldCode not in " +
" ( select FieldCode from reportmetadata where ClientUID = {0}) ",
clientUID
);
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ReportMetadata _reportMetadata = new ReportMetadata();
_reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString());
_reportMetadata.Description = reader["Description"].ToString();
_reportMetadata.RecordType = reader["RecordType"].ToString();
_reportMetadata.FieldCode = reader["FieldCode"].ToString();
_reportMetadata.ClientType = reader["ClientType"].ToString();
try
{
_reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]);
}
catch (Exception ex)
{
_reportMetadata.ClientUID = 0;
}
_reportMetadata.InformationType = reader["InformationType"].ToString();
_reportMetadata.Condition = reader["ConditionX"].ToString();
_reportMetadata.CompareWith = reader["CompareWith"].ToString();
this.reportMetadataList.Add(_reportMetadata);
}
}
}
}
}
// -----------------------------------------------------
// List metadata for a given client
// -----------------------------------------------------
public void ListMetadataForClient(int clientUID, bool onlyEnabled = false)
{
this.reportMetadataList = new List <ReportMetadata>();
var enabledOnlyCriteria = "";
if (onlyEnabled)
{
enabledOnlyCriteria = " AND Enabled = 'Y' ";
}
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" UID " +
" ,Description " +
" ,RecordType " +
" ,FieldCode " +
" ,ClientType " +
" ,ClientUID " +
" ,InformationType " +
" ,ConditionX " +
" ,CompareWith " +
" ,Enabled " +
" FROM ReportMetadata " +
" WHERE RecordType = 'CL' " +
enabledOnlyCriteria +
" AND ClientUID = {0} ",
clientUID
);
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ReportMetadata _reportMetadata = new ReportMetadata();
_reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString());
_reportMetadata.Description = reader["Description"].ToString();
_reportMetadata.RecordType = reader["RecordType"].ToString();
_reportMetadata.FieldCode = reader["FieldCode"].ToString();
_reportMetadata.ClientType = reader["ClientType"].ToString();
_reportMetadata.InformationType = reader["InformationType"].ToString();
_reportMetadata.Enabled = Convert.ToChar(reader["Enabled"]);
try
{
_reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]);
}
catch (Exception ex)
{
_reportMetadata.ClientUID = 0;
}
_reportMetadata.InformationType = reader["InformationType"].ToString();
_reportMetadata.Condition = reader["ConditionX"].ToString();
_reportMetadata.CompareWith = reader["CompareWith"].ToString();
this.reportMetadataList.Add(_reportMetadata);
}
}
}
}
}
// -----------------------------------------------------
// List Global Fields
// -----------------------------------------------------
public void ListDefault()
{
this.reportMetadataList = new List <ReportMetadata>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" UID " +
" ,Description " +
" ,RecordType " +
" ,FieldCode " +
" ,ClientType " +
" ,ClientUID " +
" ,InformationType " +
" ,ConditionX " +
" ,CompareWith " +
" ,Enabled " +
" ,UseAsLabel " +
" FROM ReportMetadata " +
" WHERE RecordType = '{0}'",
"DF");
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ReportMetadata _reportMetadata = new ReportMetadata();
_reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString());
_reportMetadata.Description = reader["Description"].ToString();
_reportMetadata.RecordType = reader["RecordType"].ToString();
_reportMetadata.FieldCode = reader["FieldCode"].ToString();
_reportMetadata.ClientType = reader["ClientType"].ToString();
_reportMetadata.Condition = reader["ConditionX"].ToString();
_reportMetadata.CompareWith = reader["CompareWith"].ToString();
_reportMetadata.Enabled = Convert.ToChar(reader["Enabled"]);
try
{
_reportMetadata.UseAsLabel = Convert.ToChar(reader["UseAsLabel"]);
}
catch (Exception ex)
{
_reportMetadata.UseAsLabel = 'N';
}
try
{
_reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]);
}
catch (Exception ex)
{
_reportMetadata.ClientUID = 0;
}
_reportMetadata.InformationType = reader["InformationType"].ToString();
this.reportMetadataList.Add(_reportMetadata);
}
}
}
}
}
