Lambda expression good people please help me on the follow

Bongani Gumede

if (collection["Department"] == "" || collection["Department"] == null || collection["Department"] == "0")

{

var Department = (from x in db.Departments

where x.Id == 1

orderby x.description ascending

select x.Id).First();

Result.DepartmentId = Department;

}

else

{

var Department = (from x in db.Departments

where x.description == collection["Department"]

orderby x.description ascending

select x.Id).First();

Result.DepartmentId = Department;

}

3 Replies

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

Jenith Thakkar8y ago
Accepted answer
You need to store value in var Department like below

if (collection["Department"] == "" || collection["Department"] == null || collection["Department"] == "0")
{
var Department =db.Departments.where(x=>x.Id==1).orderby(x=>x.description).select(x=>x.Id).First();
Result.DepartmentId = Department;
}
else
{
var Department =db.Departments.where(y=>y.description== collection["Department"]).orderby(y=>y.description).select(y=>y.Id).First();
Result.DepartmentId = Department;
}
0
Bongani Gumede8y ago
Department is a 'type', which is not valid in the given context - need help
0
Jenith Thakkar8y ago
if (collection["Department"] == "" || collection["Department"] == null || collection["Department"] == "0")
{
db.Departments.where(x=>x.Id==1).orderby(x=>x.description).select(x=>x.Id).First();
Result.DepartmentId = Department;
}
else
{
db.Departments.where(y=>y.description== collection["Department"]).orderby(y=>y.description).select(y=>y.Id).First();
Result.DepartmentId = Department;
}
0