/// <summary>
/// Retrieve client's field information
/// </summary>
/// <param name="field">Field name - use Client.FieldName</param>
/// <param name="clientUID"></param>
/// <returns></returns>
internal static ReadFieldResponse ReadFieldClient(ReadFieldRequest readFieldRequest)
{
var ret = "";
//
// EA SQL database
//
ReadFieldResponse rfr = new ReadFieldResponse();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
const string commandString = " SELECT @field FROM Client " +
" WHERE UID = @clientUID ";
using (var command = new MySqlCommand(
commandString, connection))
{
command.Parameters.AddWithValue("@field", readFieldRequest.field);
command.Parameters.AddWithValue("@clientUID", readFieldRequest.clientUID);
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
try
{
ret = reader[readFieldRequest.field].ToString();
}
catch (Exception)
{
rfr.responseStatus.Message = "Error retrieving data. (ReadFieldClient) " + commandString;
}
}
}
}
return(rfr);
}
/// <summary>
///
/// </summary>
/// <param name="readFieldRequest"></param>
/// <returns></returns>
public ReadFieldResponse ReadFieldClient(ReadFieldRequest readFieldRequest)
{
var response = RepClient.ReadFieldClient(readFieldRequest);
return(response);
}
