public List<Catalogo> obtenerControlIncapacidad()
{
DataTable dtCatalogo = new DataTable();
List<Catalogo> lstCatalogo = new List<Catalogo>();
Command.CommandText = "select id, descripcion from catalogo where grupo in (15,16)";
Command.Parameters.Clear();
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.id = int.Parse(dtCatalogo.Rows[i]["id"].ToString());
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
lstCatalogo.Add(cat);
}
return lstCatalogo;
}
public List<Catalogo> obtenerGrupo(string grupo)
{
DataTable dtCatalogo = new DataTable();
List<Catalogo> lstCatalogo = new List<Catalogo>();
Command.CommandText = "select valor, valor + ' - ' + descripcion as descripcion from catalogo where grupodescripcion = @grupodescripcion";
Command.Parameters.Clear();
Command.Parameters.AddWithValue("grupodescripcion", grupo);
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.valor = dtCatalogo.Rows[i]["valor"].ToString();
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
lstCatalogo.Add(cat);
}
return lstCatalogo;
}
public List<Catalogo> obtenerGrupo(Catalogo c)
{
DataTable dtCatalogo = new DataTable();
List<Catalogo> lstCatalogo = new List<Catalogo>();
Command.CommandText = "select id, descripcion from catalogo where grupodescripcion = @grupodescripcion";
Command.Parameters.Clear();
Command.Parameters.AddWithValue("grupodescripcion",c.grupodescripcion);
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.id = int.Parse(dtCatalogo.Rows[i]["id"].ToString());
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
lstCatalogo.Add(cat);
}
return lstCatalogo;
}
public List <Catalogo> obtenerGrupo(Catalogo c)
{
DataTable dtCatalogo = new DataTable();
List <Catalogo> lstCatalogo = new List <Catalogo>();
Command.CommandText = "select valor, descripcion from catalogo where grupodescripcion = @grupodescripcion";
Command.Parameters.Clear();
Command.Parameters.AddWithValue("grupodescripcion", c.grupodescripcion);
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.valor = dtCatalogo.Rows[i]["valor"].ToString();
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
lstCatalogo.Add(cat);
}
return(lstCatalogo);
}
public List<Catalogo> obtenerCatalogos()
{
DataTable dtCatalogo = new DataTable();
List<Catalogo> lstCatalogo = new List<Catalogo>();
Command.CommandText = "select id, valor, descripcion, grupo, grupodescripcion from catalogo";
Command.Parameters.Clear();
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.id = int.Parse(dtCatalogo.Rows[i]["id"].ToString());
cat.valor = dtCatalogo.Rows[i]["valor"].ToString();
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
cat.grupo = int.Parse(dtCatalogo.Rows[i]["grupo"].ToString());
cat.grupodescripcion = dtCatalogo.Rows[i]["grupodescripcion"].ToString();
lstCatalogo.Add(cat);
}
return lstCatalogo;
}
public List <Catalogo> obtenerCatalogos()
{
DataTable dtCatalogo = new DataTable();
List <Catalogo> lstCatalogo = new List <Catalogo>();
Command.CommandText = "select id, valor, descripcion, grupo, grupodescripcion from catalogo";
Command.Parameters.Clear();
dtCatalogo = SelectData(Command);
for (int i = 0; i < dtCatalogo.Rows.Count; i++)
{
Catalogo cat = new Catalogo();
cat.id = int.Parse(dtCatalogo.Rows[i]["id"].ToString());
cat.valor = dtCatalogo.Rows[i]["valor"].ToString();
cat.descripcion = dtCatalogo.Rows[i]["descripcion"].ToString();
cat.grupo = int.Parse(dtCatalogo.Rows[i]["grupo"].ToString());
cat.grupodescripcion = dtCatalogo.Rows[i]["grupodescripcion"].ToString();
lstCatalogo.Add(cat);
}
return(lstCatalogo);
}