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); }