public List <VolarisState> GetAllState(string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand("GetVolarisCatStates");
List <VolarisState> CatLineClassesList = new List <VolarisState>();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _catairlinclaid = dr.GetOrdinal("Code");
int _catairlinclaname = dr.GetOrdinal("Name");
while (dr.Read())
{
VolarisState item = new VolarisState();
item.StateID = dr.GetString(_catairlinclaid);
item.Name = dr.GetString(_catairlinclaname);
CatLineClassesList.Add(item);
}
}
return(CatLineClassesList);
}
/// <summary>
/// Gets the states by country.
/// </summary>
/// <param name="countryID">The country ID.</param>
/// <param name="connectionString">The connection string.</param>
/// <returns></returns>
public List <VolarisState> GetStatesByCountry(string countryID, string connectionString)
{
Database dataBase = DatabaseFactory.CreateDatabase(connectionString);
DbCommand dataBaseCommand = dataBase.GetStoredProcCommand("GetVolarisStates");
dataBase.AddInParameter(dataBaseCommand, "countryId", DbType.String, countryID);
var states = new List <VolarisState>();
using (IDataReader dataReader = dataBase.ExecuteReader(dataBaseCommand))
{
while (dataReader.Read())
{
int idPosition = dataReader.GetOrdinal("CatCitId");
int namePosition = dataReader.GetOrdinal("CatCitName");
int countryId = dataReader.GetOrdinal("CatCitCouId");
var state = new VolarisState();
state.StateID = dataReader.GetString(countryId);
state.Id = dataReader.GetString(idPosition);
state.Name = dataReader.GetString(namePosition);
states.Add(state);
}
}
return(states);
}
