C#

import java.io.IOException;

import javax.xml.parsers.DocumentBuilder;  
import javax.xml.parsers.DocumentBuilderFactory; 
import javax.xml.parsers.ParserConfigurationException;

import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.xml.sax.SAXException;	


public class Dom
{

	
   public static void main (String[] args)
   
   {
   String badnumber = "MPP";
   int badnumberconverted; 
   
   try {
      badnumberconverted = Integer.parseInt(badnumber);
   }catch (NumberFormatException nfEx){
  // System.out.println("banumber*1000000");
         }
      
               DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
      try {
               DocumentBuilder builder = factory.newDocumentBuilder();
               Document doc = builder.parse("repeat.xml");
               NodeList sampleIDs = doc.getElementsByTagName("Elements");
       for(int i=0;i<sampleIDs.getLength();i++){
               Node p = sampleIDs.item(i);
            if(p.getNodeType() == Node.ELEMENT_NODE){
               Element Elements = (Element) p;
               String id = Elements.getAttribute("id");
               NodeList nameList = Elements.getChildNodes();
             for(int j=0;j<nameList.getLength();j++){
               Node n = nameList.item(j);
             if(n.getNodeType() == Node.ELEMENT_NODE){
                Element name = (Element) n;
                  // System.out.println( convert(name.getTextContent()));
                System.out.println("Elements" + id + ":" + name.getTagName()+ "=" + name.getTextContent());
                  
                  }
               }
            }
         }     
      }  
               catch (ParserConfigurationException e){
      
                  e.printStackTrace();
      }
               catch (SAXException e)
      {
                  e.printStackTrace();
      }
                catch (IOException e){
         
                  e.printStackTrace();
      }
   }
   
  public static String convert(String val) 
   
   {
   
   double d = Double.parseDouble(val);
   d = d/1000000;
   
   return Double.toString(d);
   
                          
                      
        }    
   
   }

Member 12757695 wrote:

Can you tell me why I can't convert the all of essay in pdf files to word files?

Member 12757695 wrote:

Third part software is sautinSoft.Pdffocus.

public List<string> GetProductDetails(string productId)

return productionDetails.Select(m=>m.EmployeeName).ToList();

using Newtonsoft.Json;

string productId = string.Empty;  // ** Init this not Empty
List<prodDetails> productionDetails = GetProductDetails(productId);
string ProductDetailsJSON = Newtonsoft.Json.JsonConvert.SerializeObject(productionDetails);
return ProductDetailsJSON;

Liagapi wrote:

At the moment I can only get a list which contains data from one table instead of all three tables.

Liagapi wrote:

I would like the list to contain employee, project, and product.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Liagapi wrote:

IEnumerable<Employee> emps = db.Employees.ToList();
IEnumerable<Project> projs= db.Projects.ToList();
IEnumerable<Product> prods = db.Products.ToList();

Liagapi wrote:

string productId
where prd.productID == Convert.ToInt32(productId)

Liagapi wrote:

public List<string> GetProductDetails

Liagapi wrote:

join prj in projs on e.EmployeeID equals prj.ProjectID
join prd in prods on e.EmployeeID equals prd.productID

public sealed class ProductDetails
{
    public string employee { get; set; }
    public string project { get; set; }
    public string product { get; set; }
}
...
public List<ProductDetails> GetProductDetails(int productId)
{
    using (var db = new ProductContext())
    {
        var productDetails = from e in db.Employees
                             join prj in db.Projects on e.EmployeeID equals prj.ProjectID // Is this the correct join?
                             join prd in prods on e.EmployeeID equals prd.productID // Is this the correct join?
                             where prd.productID == productId
                             select new { e.EmployeeName, prj.ProjectName, prd.ProductName };
        
        return productDetails.AsEnumerable().Select(x => new ProductDetails
        {
            employee = x.EmployeeName,
            project = x.ProjectName,
            product = x.ProductName
        }).ToList();
    }
}

System.Windows.Input.Mouse.OverrideCursor = Cursors.None;