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(); } }