//public static bool OwnerHasContractsInProgress(int ownerID) //{ // EMMADataSet.ContractsDataTable table = new EMMADataSet.ContractsDataTable(); // contractsTableAdapter.FillByStatus(table, ownerID.ToString(), 1); // return table.Count > 0; //} public static EMMADataSet.IDTableDataTable GetInvolvedStationIDs(List<long> ownerIDs, ContractStationType type) { StringBuilder ownerIDString = new StringBuilder(""); foreach (int ownerID in ownerIDs) { if (ownerIDString.Length != 0) { ownerIDString.Append(","); } ownerIDString.Append(ownerID); } EMMADataSet.IDTableDataTable table = new EMMADataSet.IDTableDataTable(); lock (contractsTableAdapter) { if (type == ContractStationType.Pickup) { IDTableAdapter.FillStationIDsByContractPickup(table, ownerIDString.ToString()); } else { IDTableAdapter.FillStationIDsByContractDest(table, ownerIDString.ToString()); } } return table; }
public static EveDataSet.staStationsDataTable GetContractStations(List<long> ownerIDs, ContractStationType type) { StringBuilder stationIDs = new StringBuilder(""); EMMADataSet.IDTableDataTable idTable = Contracts.GetInvolvedStationIDs(ownerIDs, type); foreach (EMMADataSet.IDTableRow id in idTable) { stationIDs.Append(" "); stationIDs.Append(id.ID); } EveDataSet.staStationsDataTable retVal = new EveDataSet.staStationsDataTable(); lock (stationsTableAdapter) { stationsTableAdapter.FillByIDs(retVal, stationIDs.ToString()); } return retVal; }