public DataTable ListarEquipo()
{
Cn = ObjCn.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTAEQUIPO", Cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListarProblemas()
{
Cn = ObjCn.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTAPROBLEMA", Cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListarFichaDevolucion()
{
Cn = ObjCn.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTAFICHADEVOLUCION", Cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListaCliente()
{
cn = objCon.getConecta();
SqlDataAdapter da = new SqlDataAdapter("sp_ListaClientes", cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListarSolucion(int id)
{
Cn = ObjCn.getConecta();
Cn.Open();
using (SqlTransaction tr = Cn.BeginTransaction(IsolationLevel.Serializable))
{
SqlCommand cmd = new SqlCommand("SP_LISTASOLUCION", Cn, tr);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ProblemaId", SqlDbType.Int).Value = id;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
}
public DataTable ListarContratista()
{
Cn = ObjCn.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTARCONTRATISTA", Cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable ListarCliente()
{
Cn = ObjCn.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTACLIENTES", Cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
//listanto contratista
public DataTable LISTACONTRATISTA()
{
cn = objCON.getConecta();
SqlDataAdapter da = new SqlDataAdapter("SP_LISTACONTRATISTA", cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
public DataTable LlenarAvalas()
{
cn = objCon.getConecta();
cn.Open();
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM tblmvTelefonoCliente", cn);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
