Function with var return type

I have a query like below
i need to implement this in function means
it should return PID ,PNAME to controller
how to write function in a class to return this..
var subactivityid = (from records in db.PLANNING_DATASHEET
where planningid.Contains(records.PLANNING_ID)
select new { PID = records.PLANNING_ID, PNAME = records.SUBACTIVITY_MASTER.SUBACTIVITY_NAME }).ToList();

var subactivityid = (from records in db.PLANNING_DATASHEET

where planningid.Contains(records.PLANNING_ID)

select new { PID = records.PLANNING_ID, PNAME = records.SUBACTIVITY_MASTER.SUBACTIVITY_NAME }).ToList();

ViewBag.SUBACTIVITY_ID = new SelectList(subactivityid, "PID", "PNAME");

I am binding dropdown like above.

but i need like this instead of linq
var subactivityid=far.getSubactivity(Planningid);

As you're using an anonymous type in the LINQ expression, you'll have to replace it with a 'named' type so you can return it from the method it's in.

public class PID_PNAME

{

public string PID { get; set; } // assumed to be string

public string PNAME { get; set; } // ditto

public PID_PNAME(string PID, string PNAME)

{

this.PID = PID;

this.PNAME = PNAME;

}

public override string ToString()

{

return String.Format("{{ PID = {0}, PNAME = {1} }}", PID, PNAME);

}

// recode getSubactivity method in your 'far' class

public List GetSubactivityID(....) // add parameter

{

// .... preliminary code

var subactivityid = (from records in db.PLANNING_DATASHEET

where planningid.Contains(records.PLANNING_ID)

select new PID_PNAME( records.PLANNING_ID, records.SUBACTIVITY_MASTER.SUBACTIVITY_NAME)).ToList();

return subactivityid

}

// calling code

var subactivityid = far.getSubactivity(Planningid);

ViewBag.SUBACTIVITY_ID = new SelectList(subactivityid, "PID", "PNAME");

1 Reply

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

Vulpes12y ago
As you're using an anonymous type in the LINQ expression, you'll have to replace it with a 'named' type so you can return it from the method it's in.

public class PID_PNAME
{
public string PID { get; set; } // assumed to be string
public string PNAME { get; set; } // ditto

public PID_PNAME(string PID, string PNAME)
{
this.PID = PID;
this.PNAME = PNAME;
}

public override string ToString()
{
return String.Format("{{ PID = {0}, PNAME = {1} }}", PID, PNAME);
}
}

// recode getSubactivity method in your 'far' class

public List GetSubactivityID(....) // add parameter
{
// .... preliminary code
var subactivityid = (from records in db.PLANNING_DATASHEET
where planningid.Contains(records.PLANNING_ID)
select new PID_PNAME( records.PLANNING_ID, records.SUBACTIVITY_MASTER.SUBACTIVITY_NAME)).ToList();

return subactivityid
}

// calling code

var subactivityid = far.getSubactivity(Planningid);
ViewBag.SUBACTIVITY_ID = new SelectList(subactivityid, "PID", "PNAME");
0