public List <CENConcepto> ListarConceptosPerfil(int auxflag)
{
List <CENConcepto> listConcepto = new List <CENConcepto>();
//DESCRIPCION: Lista de clientes
CADConexion CadCx = new CADConexion(); //conexion
SqlDataReader dr; //Data reader
try
{
using (SqlConnection connection = new SqlConnection(CadCx.CxSQL()))
{
connection.Open();
using (SqlCommand command = new SqlCommand("pa_listar_datos_select_x_flag", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@flag", SqlDbType.Int).Value = auxflag;
command.CommandTimeout = CENConstante.g_const_0;
dr = command.ExecuteReader();
while (dr.Read())
{
CENConcepto dataConcepto = new CENConcepto();
dataConcepto.correlativo = Convert.ToInt32(dr["codigo"]);
dataConcepto.descripcion = Convert.ToString(dr["descripcion"]);
listConcepto.Add(dataConcepto);
}
}
dr.Close();
connection.Close();
}
return(listConcepto);
}
catch (Exception ex)
{
throw ex;
}
}
public List <CENConcepto> ListarConceptoPrecio(int prefijo)
{
//DESCRIPCION: Listar concepto precio
List <CENConcepto> lConceptoPrecio = new List <CENConcepto>();
CADConexion CadCx = new CADConexion(); //conexion
SqlDataReader dr; //Data reader
//DESCRIPCION: Listar concepto precio
try
{
using (SqlConnection connection = new SqlConnection(CadCx.CxSQL()))
{
connection.Open();
using (SqlCommand command = new SqlCommand("pa_listar_conceptos", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@p_pref", SqlDbType.Int).Value = prefijo; //Prefijo Tipos de Precios
command.CommandTimeout = CENConstante.g_const_0;
dr = command.ExecuteReader();
while (dr.Read())
{
CENConcepto dataConcepto = new CENConcepto();
dataConcepto.descripcion = dr["descripcion"].ToString();
lConceptoPrecio.Add(dataConcepto);
}
}
dr.Close();
connection.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(lConceptoPrecio);
}
public List <CENConcepto> ListarConceptos()
{
//Listar Conceptos (CORRELATIVO)
List <CENConcepto> listConcepto = new List <CENConcepto>();
CADConexion CadCx = new CADConexion(); //conexion
SqlDataReader dr; //Data reader
try
{
using (SqlConnection connection = new SqlConnection(CadCx.CxSQL()))
{
connection.Open();
using (SqlCommand command = new SqlCommand("pa_listar_conceptos", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@p_pref", SqlDbType.Int).Value = 7; //Prefijo Tipos de Precios
command.CommandTimeout = CENConstante.g_const_0;
dr = command.ExecuteReader();
while (dr.Read())
{
CENConcepto dataConcepto = new CENConcepto();
dataConcepto.correlativo = Convert.ToInt16(dr["correlativo"]);
listConcepto.Add(dataConcepto);
}
}
dr.Close();
connection.Close();
}
return(listConcepto);
}
catch (Exception ex)
{
throw ex;
}
}
//reutilizando webmetodo listar dias por tabla concepto para estadod de usuarios
public List <CENConcepto> ListarDias(int flag)
{
List <CENConcepto> listDA = new List <CENConcepto>();
SqlConnection con = null;
SqlCommand cmd = null;
SqlDataReader dr = null;
CENConcepto ObjDias = null;
CADConexion CadCx = new CADConexion();
try
{
con = new SqlConnection(CadCx.CxSQL());
cmd = new SqlCommand("pa_listar_datos_select_x_flag", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@flag", SqlDbType.Int).Value = flag;
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
ObjDias = new CENConcepto();
ObjDias.correlativo = Convert.ToInt16(dr["correlativo"]);
ObjDias.descripcion = dr["descripcion"].ToString();
listDA.Add(ObjDias);
}
}
catch (Exception e)
{
e.StackTrace.ToString();
}
finally
{
con.Close();
}
return(listDA);
}
