public List <Budget_Provinces> SelectByCode(string Code)
{
List <Budget_Provinces> allProvince = null;
try
{
string sSQL = "SELECT * FROM Provinces WHERE ProvinceCode=@ProvinceCode";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@ProvinceCode", SqlDbType.NVarChar);
sqlParam[0].Value = Code;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
allProvince = new List <Budget_Provinces>();
DataRow oneRow;
Budget_Provinces province = new Budget_Provinces();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oneRow = ds.Tables[0].Rows[i];
province = new Budget_Provinces();
province.ProvinceCode = oneRow["ProvinceCode"].ToString();
province.Culture = oneRow["Culture"].ToString();
province.ProvinceName = oneRow["ProvinceName"].ToString();
province.ZoneCode = oneRow["ZoneCode"].ToString();
province.ZoneName = getZoneName(province.ZoneCode, province.Culture);
allProvince.Add(province);
}
}
}
catch (Exception ex)
{
}
return(allProvince);
}
public List <Budget_Provinces> SelectAll()
{
List <Budget_Provinces> ProvincesList = null;
try
{
string sSQL = "SELECT * FROM Provinces";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
if (ds.Tables[0].Rows.Count > 0)
{
ProvincesList = new List <Budget_Provinces>();
Budget_Provinces province = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
province = new Budget_Provinces();
province.ProvinceCode = ds.Tables[0].Rows[i]["ProvinceCode"].ToString();
province.Culture = ds.Tables[0].Rows[i]["Culture"].ToString();
province.ProvinceName = ds.Tables[0].Rows[i]["ProvinceName"].ToString();
province.ZoneCode = ds.Tables[0].Rows[i]["ZoneCode"].ToString();
province.ZoneName = getZoneName(province.ZoneCode, province.Culture);
ProvincesList.Add(province);
}
}
}
catch (Exception ex) { }
return(ProvincesList);
}
