public List <Budget_Zone> SelectAll()
        {
            List <Budget_Zone> ZoneList = null;

            try
            {
                string sSQL = "SELECT * FROM Zone";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    ZoneList = new List <Budget_Zone>();
                    Budget_Zone zone = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        zone          = new Budget_Zone();
                        zone.ZoneCode = ds.Tables[0].Rows[i]["ZoneCode"].ToString();
                        zone.Culture  = ds.Tables[0].Rows[i]["Culture"].ToString();
                        zone.ZoneName = ds.Tables[0].Rows[i]["ZoneName"].ToString();
                        zone.FileName = ds.Tables[0].Rows[i]["FileName"].ToString();

                        ZoneList.Add(zone);
                    }
                }
            }
            catch (Exception ex) { }
            return(ZoneList);
        }
        public List <Budget_Zone> SelectByCulture(string Culture)
        {
            List <Budget_Zone> allZone = null;

            try
            {
                string         sSQL     = "SELECT * FROM Zone WHERE Culture=@Culture";
                SqlParameter[] sqlParam = new SqlParameter[1];
                sqlParam[0]       = new SqlParameter("@Culture", SqlDbType.NVarChar);
                sqlParam[0].Value = Culture;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL, sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    DataRow oneRow;
                    allZone = new List <Budget_Zone>();
                    Budget_Zone zone = new Budget_Zone();
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        oneRow        = ds.Tables[0].Rows[i];
                        zone          = new Budget_Zone();
                        zone.ZoneCode = oneRow["ZoneCode"].ToString();
                        zone.Culture  = oneRow["Culture"].ToString();
                        zone.ZoneName = oneRow["ZoneName"].ToString();
                        zone.FileName = oneRow["FileName"].ToString();
                        allZone.Add(zone);
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(allZone);
        }
        private string getZoneName(string ZoneCode, string Culture)
        {
            Budget_Zone        zone     = new Budget_Zone();
            List <Budget_Zone> zoneList = zone.SelectByCode(ZoneCode);

            zone = zoneList.Find(x => x.Culture == Culture);
            return(zone.ZoneName);
        }