How to return multiple object in this senerio.

zeeshan akram

6y809Learn iOS Programming

Anyone can suggest me How to return these to objects.

public ProductViewModel GetProductByID(int ID) {
try {
var product = (from p in _db.Products where p.ProductID == ID
select new {
p.PName,
p.PDescription,
p.Model,
p.Condition,
p.UnitPrice,
p.ManificturedPrice,
p.Discount,
p.UnitWeight,
p.UnitInStock
}).FirstOrDefault();
var productDetail = (from pd in _db.ProductDetails join b in _db.Products on pd.ProductID equals b.ProductID where pd.ProductID == ID select new {
pd.ProductID,
pd.OS,
pd.ProcessorType,
pd.RAM,
pd.ScreenSize,
pd.TouchScreen,
pd.BatteryLife,
pd.Camera
}).ToList();
return new {
product,
productDetail
};
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty6y ago
Accepted answer
Declare the below variable in the ProductViewModel class.
public class ProductViewModel
{
    public List listProducts { get; set; }
    public List listProductDetails { get; set; }
}
In GetProductByID method
public ProductViewModel GetProductByID(int ID)
{
    ProductViewModel productViewModel = new ProductViewModel();
    try
    {
        var product = (from p in _db.Products
                       where p.ProductID == ID

                       select new
                       {
                           p.PName,
                           p.PDescription,
                           p.Model,
                           p.Condition,
                           p.UnitPrice,
                           p.ManificturedPrice,
                           p.Discount,
                           p.UnitWeight,
                           p.UnitInStock
                       }).FirstOrDefault();

        var productDetail = (from pd in _db.ProductDetails
                             join b in _db.Products on pd.ProductID equals b.ProductID
                             where pd.ProductID == ID
                             select new
                             {
                                 pd.ProductID,
                                 pd.OS,
                                 pd.ProcessorType,
                                 pd.RAM,
                                 pd.ScreenSize,
                                 pd.TouchScreen,
                                 pd.BatteryLife,
                                 pd.Camera
                             }).ToList();

        productViewModel.listProducts = product;
        productViewModel.listProductDetails = productDetail;
        return productViewModel;
    }
    catch { }
}
+1
warner jonn6y ago
you can use the new included Tuples syntax.

(string, string, string) LookupName(long id) // tuple return type

{

... // retrieve first, middle and last from data storage

return (first, middle, last); // tuple literal

}

which could then be used like this:

var names = LookupName(id);

WriteLine($"found {names.Item1} {names.Item3}.");

http://csharp.net-informations.com/collection/tuple.htm
0
Ravi Patel6y ago
1. public class Product
2. {
3. // all your property
4. }
5. public class ProductDetail
6. {
7. //all your property
8. }
9. public class ProductViewModel
10. {
11. public Product products{get;set;}
12. public ListProductDetails{get;set;}
13. }
//final code
1. public ProductViewModel GetProductByID(int ID)
2. {
3. try
4. {
5. var product = (from p in _db.Products
6. where p.ProductID == ID
7. select new Product
8. {
9. PName= p.PName,
10. // same way for other property
11. }).FirstOrDefault();
12. var productDetail = (from pd in _db.ProductDetails
13. join b in _db.Products on pd.ProductID equals b.ProductID
14. where pd.ProductID == ID
15. select new ProductDetail
16. {
17. ProductID= pd.ProductID,
18. // same way for other property
19. }).ToList();
20. return new ProductViewModel{products= product, ProductDetails=productDetail };
21. }
0

Kunjahamed P6y ago

You can Use Tuples (Tuple.)

A tuple is a data structure that contains a sequence of elements of different data types. It can be used where you want to have a data structure to hold an object with properties, but you don't want to create a separate type for it.

Tuple

The following example creates a tuple with three elements:

Tuple person =

new Tuple (1, "Steve", "Jobs");

In the above example, we created an instance of the Tuple which holds a record of a person. We specified a type for each element and passed values to the constructor. Specifying the type of each element is cumbersome. So, C# includes a static helper class Tuple which returns an instance of the Tuple without specifying the type of each element, as shown below.

var person = Tuple.Create(1, "Steve", "Jobs");

Ref:https://www.tutorialsteacher.com/csharp/csharp-tuple

https://www.geeksforgeeks.org/c-sharp-tuple/

https://docs.microsoft.com/en-us/dotnet/csharp/tuples