public List<string> GetAllDriverNames(int UserId) { List<int> gettedIds = new List<int>(); List<string> gettedNames = new List<string>(); SQLDB sqlDB = new SQLDB(connectionString); SQLDB_Records sqlDB_Records = new SQLDB_Records(connectionString); sqlDB.OpenConnection(); gettedIds = sqlDB.GetAllDataBlocksId_byCardType(UserId, 0); sqlDB.CloseConnection(); gettedNames = sqlDB_Records.Get_DriverNames_ByDataBlockIdList(gettedIds); return gettedNames; }
public List<int> GetAllDataBlockId_byCardType(int cardType) { List<int> gettedIds = new List<int>(); SQLDB sqlDB = new SQLDB(connectionString); int UserId = 0; sqlDB.OpenConnection(); gettedIds = sqlDB.GetAllDataBlocksId_byCardType(UserId, cardType); sqlDB.CloseConnection(); return gettedIds; }