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 (CurrentService != 0)
     {
         DataSet ds = new DataSet();
         ds = db.GetServicesContent(CurrentService);
         string temp = ds.Tables[0].Rows[0]["arImagepath"].ToString();
         if (temp != imagepath && string.IsNullOrEmpty(imagepath))
             db.SetArabicServiceContent(CurrentService, uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, temp, Convert.ToInt32(uiTextBoxOrder.Text));
         else
             db.SetArabicServiceContent(CurrentService, uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, imagepath, Convert.ToInt32(uiTextBoxOrder.Text));
     }
     else // add new
     {
         db.AddArabicServiceContent(uiTextBoxBrief.Text, Server.HtmlEncode(uiFCKeditorContent.Value), uiTextBoxTitle.Text, imagepath, Convert.ToInt32(uiTextBoxOrder.Text));
     }
     uiPanelViewServices.Visible = true;
     uiPanelEditService.Visible = false;
     ClearFields();
     CurrentService = 0;
     BindData();
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Request.QueryString["SID"] != null && !string.IsNullOrEmpty(Request.QueryString["SID"]))
         {
             uiPanelAllServices.Visible = false;
             uiPanelViewService.Visible = true;
             int id = Convert.ToInt32(Request.QueryString["SID"].ToString());
             DBLayer db = new DBLayer();
             DataSet ds = new DataSet();
             ds = db.GetServicesContent(id);
             uiImageService.ImageUrl = ds.Tables[0].Rows[0]["arImagePath"].ToString();
             uiLabelTitle.Text = ds.Tables[0].Rows[0]["arTitle"].ToString();
             uiLiteralBrief.Text = ds.Tables[0].Rows[0]["arBrief"].ToString();
             uiLiteralContent.Text = Server.HtmlDecode(ds.Tables[0].Rows[0]["arContent"].ToString());
         }
         else
         {
             uiPanelAllServices.Visible = true;
             uiPanelViewService.Visible = false;
             BindData();
         }
     }
     RegisterStartupScript("menu", "<script type='text/javascript'>$(\"#m4\").addClass(\"selected\");</script>");
 }
 protected void uiRepeaterCurrentServices_ItemCommand(object source, RepeaterCommandEventArgs e)
 {
     if (e.CommandName == "EditService")
     {
         CurrentService = Convert.ToInt32(e.CommandArgument.ToString());
         DBLayer db = new DBLayer();
         DataSet ds = new DataSet();
         ds = db.GetServicesContent(CurrentService);
         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]["arTitle"].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;
         }
         uiPanelViewServices.Visible = false;
         uiPanelEditService.Visible = true;
     }
     else if (e.CommandName == "DeleteService")
     {
         DBLayer db = new DBLayer();
         db.DeleteService(Convert.ToInt32(e.CommandArgument.ToString()));
         BindData();
     }
 }