private void GridPackages_SelectionChanged(object sender, EventArgs e)
        {
            TravelWinRepository package = new TravelWinRepository();
            int selectedPackage         = Convert.ToInt32(gridPackages.CurrentRow.Cells["PackageId"].Value);

            data = package.GetSinglePackage(selectedPackage);
            lblPackageName.Text = data.PkgName;
            lblDesc.Text        = data.PkgDesc;

            /*************************************************
            *
            *  Causes a null value to be applied and I don't know why
            *
            *  txtStartDate.Text = data.PkgStartDate.Value.Date.ToShortDateString();
            *  txtEndDate.Text = data.PkgEndDate.Value.Date.ToShortDateString();
            *
            *************************************************/
            txtStartDate.Text       = Convert.ToDateTime(data.PkgStartDate).ToShortDateString();
            txtEndDate.Text         = Convert.ToDateTime(data.PkgEndDate).ToShortDateString();
            txtBasePrice.Text       = data.PkgBasePrice.ToString("c");
            txtCommission.Text      = Convert.ToDouble(data.PkgAgencyCommission).ToString("c");
            gridProducts.DataSource = package.GetProducts(selectedPackage);
            string image = ConfigurationManager.AppSettings["PathToProject"] + data.PackageImageLocation;

            try
            {
                //pbImage.Image = Image.FromFile(image);
                pbImage.Load(image);
            }
            catch
            {
                PictureBox errorPic = new PictureBox();
                //pbImage.Size = ;
                pbImage.Image = errorPic.ErrorImage;
            }
        }