public static Cierre TraerFechaCierreProx()
{
string sql = "Cierres_TProxFecCierre";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
try
{
Cierre cierre = new Cierre();
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
cierre.FecCierre = ds["FecCierre"].ToString();
cierre.Mensual = ds["Mensual"].ToString();
}
ds.Close();
ds.Dispose();
}
return(cierre);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en CierresDAO.TraerFechaCierreProx", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public static List <EstadoReclamo> Traer_Proximos(int idEstado)
{
string sql = "EstadoReclamo_Proximo";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
db.AddInParameter(dbCommand, "@idEstado", DbType.Int32, idEstado);
List <EstadoReclamo> ListEstado = new List <EstadoReclamo>();
EstadoReclamo oEst = null;
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
oEst = new EstadoReclamo();
oEst.DescEstado = ds["DescEstado"].ToString();
oEst.IdEstado = int.Parse(ds["IdEstado"].ToString());
oEst.Control = ds.GetNullableString("Control");
oEst.ControlTexto = ds.GetNullableString("ControlTexto");
oEst.ControlIdModelo = ds.GetNullableInt32("ControlIdModelo") == null ? 0 : ds.GetInt32("ControlIdModelo");
oEst.EsFinal = ds.GetNullableBoolean("EsFinal") == null ? false : ds.GetBoolean("EsFinal");
oEst.FecManual = ds.GetNullableBoolean("FecManual") == null ? false : ds.GetBoolean("FecManual");
oEst.MensajeInfo = ds.GetNullableString("MensajeInfo");
oEst.EstadoAnme = ds.GetNullableInt32("EstadoAnme") == null ? 0 : ds.GetInt32("EstadoAnme");
oEst.PaseAutomatico = ds.GetNullableBoolean("PaseAutomatico") == null ? false : ds.GetBoolean("PaseAutomatico");
oEst.TieneObservacion = ds.GetNullableBoolean("TieneObservacion") == null ? false : ds.GetBoolean("TieneObservacion");
ListEstado.Add(oEst);
}
ds.Close();
ds.Dispose();
}
return(ListEstado);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}->Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.Trae_Todos", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public static List <ModeloImpresion> ModeloImpresionTraer(int idEstado)
{
string sql = "EstadoReclamo_impresion";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
db.AddInParameter(dbCommand, "@IdEstado", DbType.Int64, idEstado);
List <ModeloImpresion> LstModeloImpresion = new List <ModeloImpresion>();
ModeloImpresion oModeloImpresion = null;
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
oModeloImpresion = new ModeloImpresion();
oModeloImpresion.IdModelo = ds["idModeloImpresion"].ToString() == null?0:int.Parse(ds["idModeloImpresion"].ToString());
oModeloImpresion.Imprime = ds["Imprime"].ToString() == null?false:bool.Parse(ds["Imprime"].ToString());
LstModeloImpresion.Add(oModeloImpresion);
}
ds.Close();
ds.Dispose();
}
return(LstModeloImpresion);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}->Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.ModeloImpresionTraer", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public static List <EstadoDocumentacion> Tipos_EstadosDocumentacion_Trae()
{
string sql = "TipoEstadoDocumentacion_Trae";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
List <EstadoDocumentacion> ListEstado = new List <EstadoDocumentacion>();
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
ListEstado.Add(new EstadoDocumentacion(int.Parse(ds["idEstadodocumentacion"].ToString()),
ds["descripcion"].ToString(), true,
Convert.ToBoolean(ds["verOnlineCarga"]),
Convert.ToBoolean(ds["debeIngresarCaja"]),
Convert.ToBoolean(ds["apruebaNovedad"])));
}
ds.Close();
ds.Dispose();
}
return(ListEstado);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.Tipos_EstadosDocumentacion_Trae", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public static Estado Traer(int idEstado)
{
string sql = "EstadoReclamo_Trae_IdEstado";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
db.AddInParameter(dbCommand, "@IdEstado", DbType.Int64, idEstado);
Estado oEst = null;
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
oEst = new Estado();
oEst.DescEstado = ds["DescEstado"].ToString();
oEst.IdEstado = int.Parse(ds["IdEstado"].ToString());
}
ds.Close();
ds.Dispose();
}
return(oEst);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.Traer", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public static List <EstadoCaratulacion> Tipos_EstadosCaratulacion_Trae()
{
string sql = "EstadoNovCaratulacion_Traer";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
DbParameterCollection dbParametros = null;
List <EstadoCaratulacion> ListEstado = new List <EstadoCaratulacion>();
try
{
dbParametros = dbCommand.Parameters;
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
ListEstado.Add(new EstadoCaratulacion(int.Parse(ds["IdEstado"].ToString()),
ds["DescEstadoNov"].ToString(), true,
short.Parse(ds["idEstadoExpediente"].ToString())));
}
ds.Close();
ds.Dispose();
}
return(ListEstado);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en EstadoDAO.Tipos_EstadosCaratulacion_Trae", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
public List <Cierre> TraerCierresAnteriores()
{
sql = "Cierres_TT";
Database db = DatabaseFactory.CreateDatabase("DAT_V01");
DbCommand dbCommand = db.GetStoredProcCommand(sql);
try
{
List <Cierre> lstCierre = new List <Cierre>();
using (NullableDataReader ds = new NullableDataReader(db.ExecuteReader(dbCommand)))
{
while (ds.Read())
{
lstCierre.Add(new Cierre(
ds.GetString("FecCierre"),
ds.GetString("Mensual"),
ds.GetNullableDateTime("FecAplicacionPagos")));
}
ds.Close();
ds.Dispose();
}
return(lstCierre);
}
catch (Exception ex)
{
log.Error(string.Format("{0}->{1}-> Error:{2}->{3}", DateTime.Now, System.Reflection.MethodBase.GetCurrentMethod(), ex.Source, ex.Message));
throw new Exception("Error en CierresDAO.TraerCierresAnteriores", ex);
}
finally
{
db = null;
dbCommand.Dispose();
}
}
