Esempio n. 1
0
        private static List <CityItem> CitiesRepository()
        {
            List <CityItem> all = new List <CityItem>();

            String        sql = "dbo.p_City_Get";
            SqlConnection cnn = new SqlConnection(ConnectionStrings.sqlUsers);
            SqlCommand    cmd = new SqlCommand(sql, cnn);
            SqlDataReader rdr = null;

            cmd.CommandType = CommandType.StoredProcedure;

            try
            {
                cnn.Open();
                rdr = cmd.ExecuteReader();

                if (rdr.HasRows)
                {
                    while (rdr.Read())
                    {
                        CityItem x = new CityItem();

                        x.Value     = rdr.GetByte(0).ToString();
                        x.Text      = rdr.GetString(1);
                        x.CultureId = rdr.GetByte(2);
                        x.CountryId = rdr.GetByte(3);

                        all.Add(x);
                    }
                }
            }
            catch (SqlException e)
            { }
            catch (Exception ex)
            { }
            finally
            {
                if (!(rdr == null))
                {
                    rdr.Close();
                    rdr.Dispose();
                }

                cnn.Close();
                cnn.Dispose();
                cmd.Dispose();
            }
            return(all);
        }
Esempio n. 2
0
        public static List <CityItem> Cities(int cultureId, int countryId, bool addDefault)
        {
            List <CityItem> r = new List <CityItem>();

            var x = from a in Properties.Cities where a.CultureId == cultureId && a.CountryId == countryId select a;

            r = x.ToList <CityItem>();

            if (addDefault)
            {
                CityItem defaultItem = new CityItem();

                defaultItem.Text  = Resources.Labels.Labels.Select;
                defaultItem.Value = "0";

                r.Insert(0, defaultItem);
            }

            return(r);
        }