/// <summary>
/// Método para consultar la vista ViewCorrespondence
/// </summary>
/// <returns> Lista de resultados de consultar vista </returns>
public List <CorrespondenceViewDto> GetViewCorrespondence()
{
List <CorrespondenceViewDto> correspondenceView = new List <CorrespondenceViewDto>();
string queryString = "SELECT * FROM develop.view_correspondence;";
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
CorrespondenceViewDto correspondence = new CorrespondenceViewDto();
correspondence.Description = reader[0].ToString();
correspondence.Consecutive = reader[1].ToString();
correspondence.Type_Correspondence = reader[2].ToString();
correspondence.Sender = reader[3].ToString();
correspondence.Addressee = reader[4].ToString();
correspondence.ReceptionDate = (DateTime)reader[5];
correspondence.FileName = reader[6].ToString();
correspondence.File = reader[7].ToString();
correspondenceView.Add(correspondence);
}
reader.Close();
}
catch (Exception ex)
{
throw new ArgumentException("Error 04: Ocurrió un error consultando la vista de la base de datos.");
}
return(correspondenceView);
}
}
/// <summary>
/// Métod para consultar la vista de correspondence
/// </summary>
/// <returns> Objeto de la transacción </returns>
public TransactionDto <List <CorrespondenceViewDto> > GetViewCorrespondence()
{
TransactionDto <List <CorrespondenceViewDto> > transaction = new TransactionDto <List <CorrespondenceViewDto> >();
transaction.Data = new List <CorrespondenceViewDto>();
try
{
string _class = MethodBase.GetCurrentMethod().ReflectedType.Name;
string _method = MethodBase.GetCurrentMethod().Name;
_logger.LogInformation("Acceso al " + _class + "/" + _method);
var getViewCorrespondence = _correspondenceRepository.GetViewCorrespondence();
if (getViewCorrespondence.Count == 0)
{
transaction.Message = "No existen registros en la vista.";
return(transaction);
}
foreach (var item in getViewCorrespondence)
{
CorrespondenceViewDto correspondenceView = new CorrespondenceViewDto();
correspondenceView.Description = item.Description;
correspondenceView.Consecutive = item.Consecutive;
correspondenceView.Type_Correspondence = item.Type_Correspondence;
correspondenceView.Sender = item.Sender;
correspondenceView.Addressee = item.Addressee;
correspondenceView.ReceptionDate = item.ReceptionDate;
correspondenceView.FileName = item.FileName;
correspondenceView.File = item.File;
transaction.Data.Add(correspondenceView);
}
transaction.Message = "Datos consultados correctamente.";
transaction.Status = Status.Success;
}
catch (ArgumentException ex)
{
transaction.Message = ex.Message;
}
return(transaction);
}
