protected void uiLinkButtonUpdate_Click(object sender, EventArgs e)
 {
     DBLayer db = new DBLayer();
     string imagepath = "";
     if (uiFileUploadImage.HasFile)
     {
         uiFileUploadImage.SaveAs(Server.MapPath(ConfigurationManager.AppSettings["UserFilePath"] + "UploadedImages/" + uiFileUploadImage.FileName));
         imagepath = ConfigurationManager.AppSettings["UserFilePath"] + "UploadedImages/" + uiFileUploadImage.FileName;
     }
     // update
     if (CurrentPackage != 0)
     {
         DataSet ds = new DataSet();
         ds = db.GetPackageContent(CurrentPackage);
         string temp = ds.Tables[0].Rows[0]["arImagepath"].ToString();
         if (temp != imagepath && string.IsNullOrEmpty(imagepath))
             db.SetArabicPackageContent(CurrentPackage, uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, temp, Convert.ToInt32(uiTextBoxOrder.Text));
         else
             db.SetArabicPackageContent(CurrentPackage, uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, imagepath, Convert.ToInt32(uiTextBoxOrder.Text));
     }
     else // add new
     {
         db.AddArabicPackageContent(uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, imagepath, Convert.ToInt32(uiTextBoxOrder.Text));
     }
     uiPanelViewPackages.Visible = true;
     uiPanelEditPackage.Visible = false;
     ClearFields();
     CurrentPackage = 0;
     BindData();
 }
 protected void uiRepeaterPackages_ItemCommand(object source, RepeaterCommandEventArgs e)
 {
     if (e.CommandName == "EditPackage")
     {
         CurrentPackage = Convert.ToInt32(e.CommandArgument.ToString());
         DBLayer db = new DBLayer();
         DataSet ds = new DataSet();
         ds = db.GetPackageContent(CurrentPackage);
         uiTextBoxBrief.Text = ds.Tables[0].Rows[0]["arBrief"].ToString();
         uiTextBoxOrder.Text = ds.Tables[0].Rows[0]["arOrder"].ToString();
         uiTextBoxTitle.Text = ds.Tables[0].Rows[0]["arPackageName"].ToString();
         uiFCKeditorContent.Value = Server.HtmlDecode(ds.Tables[0].Rows[0]["arContent"].ToString());
         if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["arImagepath"].ToString()))
         {
             uiImageCurrent.ImageUrl = ds.Tables[0].Rows[0]["arImagepath"].ToString();
             uiImageCurrent.Visible = true;
         }
         else
         {
             uiImageCurrent.Visible = false;
         }
         uiPanelViewPackages.Visible = false;
         uiPanelEditPackage.Visible = true;
     }
     else if (e.CommandName == "DeletePackage")
     {
         DBLayer db = new DBLayer();
         db.DeletePackage(Convert.ToInt32(e.CommandArgument.ToString()));
         BindData();
     }
     else if (e.CommandName == "EditSubPackage")
     {
         Session["Parentpackage"] = e.CommandArgument.ToString();
         Response.Redirect("EditTourismList.aspx");
     }
 }