public List <C_Extra> listarMotivos()
{
List <C_Extra> list = new List <C_Extra>();
if (con == null)
{
con = new conexion();
}
con.conectar();
SqlCommand cmd = new SqlCommand("_sp_listarMotivoExtra", con.cnxn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
C_Extra nodo = new C_Extra();
nodo.observacion = dr.GetString(1).Trim(new char[] { ' ' });
list.Add(nodo);
}
}
con.desconectar();
return(list);
}
public C_Extra BuscarSumExtra()
{
if (con == null)
{
con = new conexion();
}
con.conectar();
C_Extra ext = null;
SqlCommand cmd = new SqlCommand("_sp_BuscarSumExtra", con.cnxn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@idh", idHabitacion);
cmd.Parameters.AddWithValue("@fecha", fecha);
cmd.Parameters.AddWithValue("@ids", idSuministro);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ext = new C_Extra();
ext.idSuministro = dr.GetInt32(0);
ext.idHabitacion = dr.GetInt32(3);
ext.cantidad = dr.GetInt32(4);
ext.fecha = dr.GetDateTime(5);
ext.descripcion = dr.GetString(2).Trim(new char[] { ' ' });
ext.observacion = dr.GetString(8).Trim(new char[] { ' ' });
}
}
con.desconectar();
return(ext);
}
