public IList <CourtItem> Search(string name, string type)
{
IList <CourtItem> result = (from court in db.Courts
join t1 in db.CourtTypes on court.CourtTypeID equals t1.CourtTypeID into r1
from courtType in r1.DefaultIfEmpty()
select new
{
CourtTable = court,
CourtTypeTable = courtType
}).Select(list => new CourtItem
{
CourtID = list.CourtTable.CourtID,
CourtName = list.CourtTable.CourtName,
CourtTypeID = list.CourtTable.CourtTypeID,
CourtTypeName = list.CourtTypeTable.CourtTypeName
}).ToList();
if (!string.IsNullOrEmpty(name))
{
result = result.Where(p => p.CourtName.StartsWith(name, StringComparison.OrdinalIgnoreCase)).ToList();
}
if (!string.IsNullOrEmpty(type))
{
int id = Convert.ToInt32(type);
CourtType courtType = db.CourtTypes.Find(id);
result = result.Where(p => p.CourtTypeName == courtType.CourtTypeName).ToList();
}
return(result);
}
public CourtType GetCourtType(int CourtTypeID)
{
CourtType dbItem = db.CourtTypes.Find(CourtTypeID);
CourtType item = new CourtType
{
CourtTypeID = dbItem.CourtTypeID,
CourtTypeName = dbItem.CourtTypeName
};
return(item);
}