how to get specific data and save it?

Denmark Puso

7y787.NET

ill try to get the all ID with status of "Picked-up" in other table. im newbie here im using c# asp.net mvc

this is my code any suggest on how to do. thanks in advance

4 Replies

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

Jaimin Shethiya7y ago
Hello Denmark,

If you have used in Where in Linq query so they have return as a multiple result.

so you have to write the below code in your application.

var package = lstTest.GetAll().Where(x=> x.Status == "Picked-up").ToList();
foreach (var item in package)
{
var shipmentItem = new ShipmentItems
{
ShipmentId = model.ShipmentId,
PackageId = item.Id
};
_shipmentItemService.Add(shipmentItem);
}
return RedirectToAction("addshipmentitem");

let me know if you have needed anything.

Thanks
Ronika Jency7y ago
Hi,

package.Select(x => x.Id) - it returns all the id so can't assign one value to shipment. so use below code,

shipmentItem.PackageId = package.Select(x => x.Id == 1(give iterate value like for loop id));

So, based on every shipment have one packageid
Denmark Puso7y ago
hi Mounnad Mohamed
Thanks for reply i have an error.
Unable to cast object of type 'WhereSelectListIterator`2[ChenvelIntl.Core.Domain.Packages.Package,System.Int32]' to type 'System.IConvertible'.
Mounnad Mohamed7y ago
As i undersand every shipmentItem Has List of Package Ids

So you need to pass List of Ids to your ShipmentItem
var package = _packageService.GetAll().Where(x => x.Status == "Picked-up");
var shipmentItem = new ShipmentItems
{
ShipmentId = model.ShipmentId
};
if (package != null)
{
shipmentItem.PackageId = package.Select(x => x.Id);
}
_shipmentItemService.Add(shipmentItem);
return RedirectToAction("addshipmentitem");