protected void Page_Load(object sender, EventArgs e)
        {
            var data   = new IgniteTourRepository(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
            var cities = data.GetCities();

            lvCities.DataSource = cities.OrderBy(c => c.StartDate).ToArray();
            lvCities.DataBind();
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         var data = new IgniteTourRepository(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
         ddlRegion.DataSource = data.GetRegions();
         ddlRegion.DataBind();
     }
 }
        protected void btnInsert_Click(object sender, EventArgs e)
        {
            if (Page.IsValid)
            {
                var city = new TourCity()
                {
                    DateDisplayed    = txtDateDisplayed.Text,
                    ImageUrl         = txtImage.Text,
                    LastUpdateDate   = DateTime.Now,
                    LastUpdateUserId = User.Identity.GetUserId(),
                    Name             = txtName.Text,
                    StartDate        = dtDate.Date,
                    TourRegionId     = int.Parse(ddlRegion.SelectedValue),
                    Visible          = cbVisible.Checked
                };
                var data = new IgniteTourRepository(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
                data.InsertCity(city);

                Response.Redirect(ResolveUrl("~/Cities/List"));
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                var data = new IgniteTourRepository(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);
                ddlRegion.DataSource = data.GetRegions();
                ddlRegion.DataBind();

                var city = data.GetCity(CityId);
                if (city != null)
                {
                    txtName.Text            = city.Name;
                    txtDateDisplayed.Text   = city.DateDisplayed;
                    txtImage.Text           = city.ImageUrl;
                    txtName.Text            = city.Name;
                    dtDate.Date             = city.StartDate;
                    ddlRegion.SelectedValue = city.TourRegionId.ToString();
                    cbVisible.Checked       = city.Visible;

                    txtUserLastEdit.Text = city.LastUpdateUserName;
                    txtDateLastEdit.Text = city.LastUpdateDate.ToString();
                }
            }
        }