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 });
}
