public OutParamGuias GetTablas()
{
OutParamGuias data = new OutParamGuias();
try
{
DocumentsDAO dao = new DocumentsDAO();
data = dao.GetTablas();
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManageDocuments", "GetTablas", ex, "");
}
return(data);
}
public OutParamGuias GetTablasAs()
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutParamGuias response = new OutParamGuias();
var ora = new OracleServer(connectionString);
ParamGuias guias;
response.ListDoc = new List <ParamGuias>();
string command = string.Empty;
try
{
command = " SELECT * FROM TABLAS WHERE IND_ESTADO = 1 ORDER BY SECTOR ";
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
guias = new ParamGuias();
guias.codigo_guia = DBNull.Value.Equals(rdr["CODIGO_TABLA"]) ? 0 : double.Parse(rdr["CODIGO_TABLA"].ToString());
guias.sector = DBNull.Value.Equals(rdr["SECTOR"]) ? 0 : double.Parse(rdr["SECTOR"].ToString());
guias.nombre = DBNull.Value.Equals(rdr["NOMBRE_DOC"]) ? "" : (rdr["NOMBRE_DOC"].ToString());
guias.path = DBNull.Value.Equals(rdr["URL_DOC"]) ? "" : (rdr["URL_DOC"].ToString());
guias.fecha = DBNull.Value.Equals(rdr["FECHA_ACT"]) ? "" : (rdr["FECHA_ACT"].ToString());
guias.fecha = guias.fecha.Substring(0, 10);
guias.nombre = guias.nombre.Replace(".pdf", "");
guias.ind_estado = DBNull.Value.Equals(rdr["IND_ESTADO"]) ? 0 : double.Parse(rdr["IND_ESTADO"].ToString());
response.ListDoc.Add(guias);
}
rdr.Close();
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("DocumentsDAO.GetTablas", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public ParamGuias GetIdGuias(double codigo)
{
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutParamGuias response = new OutParamGuias();
var ora = new OracleServer(connectionString);
ParamGuias guia = new ParamGuias();
string command = string.Empty;
try
{
command = " SELECT * FROM GUIAS ";
command += string.Format("WHERE CODIGO_GUIA = {0}", codigo);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
guia = new ParamGuias();
guia.codigo_guia = DBNull.Value.Equals(rdr["CODIGO_GUIA"]) ? 0 : double.Parse(rdr["CODIGO_GUIA"].ToString());
guia.sector = DBNull.Value.Equals(rdr["SECTOR"]) ? 0 : double.Parse(rdr["SECTOR"].ToString());
guia.nombre = DBNull.Value.Equals(rdr["NOMBRE_DOC"]) ? "" : (rdr["NOMBRE_DOC"].ToString());
guia.path = DBNull.Value.Equals(rdr["URL_DOC"]) ? "" : (rdr["URL_DOC"].ToString());
guia.fecha = DBNull.Value.Equals(rdr["FECHA_ACT"]) ? "" : (rdr["FECHA_ACT"].ToString());
guia.ind_estado = DBNull.Value.Equals(rdr["IND_ESTADO"]) ? 0 : double.Parse(rdr["IND_ESTADO"].ToString());
}
rdr.Close();
response.msg = new Response();
response.msg.errorCode = "200";
response.msg.errorMessage = "OK";
}
catch (Exception ex)
{
throw new Exception("DocumentsDAO.GetGuias", ex);
}
finally
{
ora.Dispose();
}
return(guia);
}
