public Dictionary <int, string> GetCityList(string ProvinceName)
{
try
{
Dictionary <int, string> OutputDictionary = new Dictionary <int, string>();
if (new Security(UserProfileObj).AuthenticateUser())
{
DataSet OutputDataset = ProvinceDataLayer.GetDatasetOfProvinces();
DataView DVTable = OutputDataset.Tables[0].DefaultView;
DVTable.Sort = "province asc";
DataTable dtSorted = DVTable.ToTable();
DataRow[] DrFiltered = dtSorted.Select("province = '" + ProvinceName + "'");
foreach (DataRow dr in DrFiltered)
{
OutputDictionary.Add(int.Parse(dr["cid"].ToString()), dr["city"].ToString());
}
}
return(OutputDictionary);
}
catch (Exception ex)
{
Logger.Instance().Log(Fatal.Instance(), ex);
throw ex;
}
}
public static List <IProvince> GetProvinceList()
{
List <IProvince> ListOfProvince = new List <IProvince>();
try
{
DataSet OutputDataset = ProvinceDataLayer.GetDatasetOfProvinces();
DataView dvOutputDataset = new DataView(OutputDataset.Tables[0]);
DataTable dtOutputDataset = dvOutputDataset.ToTable(true, "province");
foreach (DataRow dr in dtOutputDataset.Rows)
{
ListOfProvince.Add(new Province(dr["Province"].ToString()));
}
return(ListOfProvince);
}
catch (Exception ex)
{
Logger.Instance().Log(Fatal.Instance(), ex);
throw ex;
}
}
