public OutUploadDocuments GetUploadDocuments(string documentID)
{
OutUploadDocuments data = new OutUploadDocuments();
try
{
DocumentsDAO dao = new DocumentsDAO();
data = dao.GetUploadDocuments(documentID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageDocuments", "GetUploadDocuments", ex, "");
}
return(data);
}
public OutUploadDocuments GetUploadDocuments(string documentID)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutUploadDocuments response = new OutUploadDocuments();
var ora = new OracleServer(connectionString);
UploadDocuments document;
List <UploadDocuments> list = new List <UploadDocuments>();
string command = string.Empty;
try
{
command = " SELECT BBS_PORTAL_LOG_IMG.CONSECUTIVO, BBS_PORTAL_LOG_IMG.DESCRIPCION_DOCUMENTO, BBS_PORTAL_LOG_IMG.NOMBRE_DOCUMENTO_CARGADO, ";
command = string.Format("{0} BBS_PORTAL_LOG_IMG.YEAR, BBS_PORTAL_LOG_IMG.MONTH FROM BBS_PORTAL_LOG_IMG WHERE ", command);
command = string.Format("{0} BBS_PORTAL_LOG_IMG.NUMERO_CEDULA = '{1}' ORDER BY BBS_PORTAL_LOG_IMG.CONSECUTIVO DESC ", command, documentID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
document = new UploadDocuments();
document.Consecutive = DBNull.Value.Equals(rdr["CONSECUTIVO"]) ? 0 : double.Parse(rdr["CONSECUTIVO"].ToString());
document.Description = DBNull.Value.Equals(rdr["DESCRIPCION_DOCUMENTO"]) ? string.Empty : rdr["DESCRIPCION_DOCUMENTO"].ToString();
document.Name = DBNull.Value.Equals(rdr["NOMBRE_DOCUMENTO_CARGADO"]) ? string.Empty : rdr["NOMBRE_DOCUMENTO_CARGADO"].ToString();
document.Year = DBNull.Value.Equals(rdr["YEAR"]) ? 0 : int.Parse(rdr["YEAR"].ToString());
document.Month = DBNull.Value.Equals(rdr["MONTH"]) ?0 : int.Parse(rdr["MONTH"].ToString());
list.Add(document);
}
rdr.Close();
response.lstUploadDocuments = list;
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("DocumentsDAO.GetUploadDocuments", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
