public String GetTipo_Cambio_Exportacion(Int64 Perido)
{
string respuesta = string.Empty;
try
{
List <BEExportacion> Exportaciones = new List <BEExportacion>();
BEExportacion Exportar = new BEExportacion();
using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_Exportacion_TC"))
{
dbSQL.AddInParameter(dbCmd, "@Per_empresa", DbType.String, Perido);
using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd))
{
int Resul = dataReader.GetOrdinal("Sunat");
object[] values = new object[dataReader.FieldCount];
while (dataReader.Read())
{
dataReader.GetValues(values);
StreamWriter sw = new StreamWriter(Path.GetFullPath(@"C:\20114803228.tc"), true);
sw.WriteLine(values[Resul] == DBNull.Value ? string.Empty : values[Resul].ToString());
sw.Close();
}
}
return("Exportacion Exitosa");
}
}
catch (Exception ex)
{
ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false);
return(null);
}
finally
{
}
}
//
//Modificaciones realizadas por renzo laureano 29/11/2012
//
public String GetHoteles_Exportacion(BEPeriodoEmpresa_Mant Perido)
{
string respuesta = string.Empty;
try
{
List <BEExportacion> Exportaciones = new List <BEExportacion>();
BEExportacion Exportar = new BEExportacion();
using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_Exportacion_Hospedaje"))
{
dbSQL.AddInParameter(dbCmd, "@Per_empresa", DbType.String, Perido.codPeriodo);
if (string.IsNullOrEmpty(Perido.codLocal))
{
dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, DBNull.Value);
}
else
{
dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, Perido.codLocal);
}
if (string.IsNullOrEmpty(Perido.anioProces))
{
dbSQL.AddInParameter(dbCmd, "@Anio", DbType.Int32, DBNull.Value);
}
else
{
dbSQL.AddInParameter(dbCmd, "@Anio", DbType.Int32, Perido.anioProces);
}
if (string.IsNullOrEmpty(Perido.anioProces))
{
dbSQL.AddInParameter(dbCmd, "@Mes", DbType.Int32, DBNull.Value);
}
else
{
dbSQL.AddInParameter(dbCmd, "@Mes", DbType.Int32, Perido.mes);
}
using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd))
{
int Resul = dataReader.GetOrdinal("Sunat");
object[] values = new object[dataReader.FieldCount];
while (dataReader.Read())
{
dataReader.GetValues(values);
StreamWriter sw = new StreamWriter(Path.GetFullPath(@Perido.Ruta), true);
//StreamWriter sw = new StreamWriter(Path.GetFullPath(@"d:/20114803228.hos"), true);
sw.WriteLine(values[Resul] == DBNull.Value ? string.Empty : values[Resul].ToString());
sw.Close();
}
}
return("Exportacion Exitosa");
}
}
catch (Exception ex)
{
throw ex;
//ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false);
//return null;
}
finally
{
}
}