public IList <BuildingType> GetAll() { if ((from t in _connection.Table <BuildingType>() select t).ToList().Count == 0) { tblBuildingType tblbt = new tblBuildingType(); BuildingType bt = new BuildingType(); bt.BuildingTypeName = "Church"; tblbt.Add(bt); bt = new BuildingType(); bt.BuildingTypeName = "School"; tblbt.Add(bt); bt = new BuildingType(); bt.BuildingTypeName = "Residence"; tblbt.Add(bt); bt = new BuildingType(); bt.BuildingTypeName = "Gym/Auditorium"; tblbt.Add(bt); bt = new BuildingType(); bt.BuildingTypeName = "Other:"; tblbt.Add(bt); } return((from t in _connection.Table <BuildingType>() select t).ToList()); }
public List <LocationListModal> LocationViewList() { //var q = _connection.Query<LocationListModal>("SELECT Location.LocationId, Client.ID, buildingtype.BuildingTypeName, Client.Name, Location.issupload FROM Location INNER JOIN buildingtype ON location.buildingtypeid = buildingtype.buildingtypeid INNER JOIN client ON location.clientid = client.ID").ToList(); List <LocationListModal> llm = new List <LocationListModal>(); List <Location> loc = (from t in _connection.Table <Location>() select t).ToList(); tblBuildingType btype = new tblBuildingType(); tblClient client = new tblClient(); foreach (Location l in loc) { llm.Add(new LocationListModal { LocationId = l.LocationId, sync = l.issupload, BuildingName = btype.GetName(l.BuildingTypeID), ClientID = l.ClientID, ClientName = client.GetName(l.ClientID) }); } //llm.Add(new LocationListModal { LocationId = 1, sync = true, BuildingName = "Building 1", ClientID = 1, ClientName = "Kaushal" }); return(llm); //(from LocationId in Location, //from ClientID in Client) //return q; //(x => new LocationListModal { LocationId = x.locationid, ClientID = x.clientid, BuildingName = x.buildingtypename, ClientName = x.clientname }); }