private void BindCardImages()
 {
     CardImages txt = new CardImages();
     txt.GetCardImageByCardID(CurrentCard.CardID);
     uiGridViewCardImages.DataSource = txt.DefaultView;
     uiGridViewCardImages.DataBind();
     if (txt.RowCount < 2)
     {
         uiButtonSaveImageInfo.Visible = true;
     }
     else
     {
         uiButtonSaveImageInfo.Visible = false;
     }
 }
        private void LoadCardInfo()
        {
            CardLayouts layout = new CardLayouts();
            layout.GetCardLayoutByCardID(CardID);
            for (int i = 0; i < layout.RowCount; i++)
            {
                uiRadioButtonListLayouts.Items.Add(new ListItem(String.Format("<img src='{0}' style='width:100px' />", ".." + layout.LayoutImage), ".." + layout.LayoutImage + "#" + ".." + layout.LayeoutBackImage));
                layout.MoveNext();
            }

            if (uiRadioButtonListLayouts.Items.Count > 0)
                uiRadioButtonListLayouts.Items[0].Selected = true;

            CardColor colors = new CardColor();
            colors.GetCardColorsByCardID(CardID);
            uiRepeaterColors.DataSource = colors.DefaultView;
            uiRepeaterColors.DataBind();

            Dimension dims = new Dimension();
            dims.GetAllDims();
            uiRepeaterSizes.DataSource = dims.DefaultView;
            uiRepeaterSizes.DataBind();

            CardText texts = new CardText();
            texts.GetCardTxtByCardID(CardID);
            uiDataListCardText.DataSource = texts.DefaultView;
            uiDataListCardText.DataBind();

            CardImages images = new CardImages();
            images.GetCardImageByCardID(CardID);
            if (images.RowCount > 0)
            {
                uiDataListImages.DataSource = images.DefaultView;
                uiDataListImages.DataBind();
                uiPanelNoImages.Visible = false;
            }
            else
            {
                uiDataListImages.Visible = false;
                uiPanelNoImages.Visible = true;
            }

            Cards card = new Cards();
            card.LoadByPrimaryKey(CardID);

            Categories cat = new Categories();
            cat.LoadByPrimaryKey(card.CategoryID);

            MainCat mcat = new MainCat();
            mcat.LoadByPrimaryKey(cat.MainCatId);

            TopLevelCat tcat = new TopLevelCat();
            tcat.LoadByPrimaryKey(mcat.TopLevelCatID);

            uiImageMain.ImageUrl = "../" + card.GeneralPreviewPhoto;
            FullPath = tcat.NameEng + " > " + mcat.NameEng + " > " + cat.CatNameEng;
        }
        protected void uiGridViewCards_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "EditCard")
            {
                Cards objData = new Cards();
                objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));

                uiTextBoxCardNameEn.Text = objData.CardNameEng;
                uiTextBoxCardNameAr.Text = objData.CardNameAr;
                uiTextBoxDescEn.Text = objData.DescriptionEng;
                uiTextBoxDescAr.Text = objData.DescriptionAr;
                if (!objData.IsColumnNull("DefaultFont"))
                {
                    uiDropDownListFonts.SelectedValue = objData.DefaultFont;
                }

                if (!objData.IsColumnNull("DimensionID"))
                    uiDropDownListDim.SelectedValue = objData.DimensionID.ToString();

                uiTextBoxPriceAfter.Text = objData.PriceNow.ToString();
                uiTextBoxPriceBefore.Text = objData.PriceBefore.ToString();

                uiPanelAllCards.Visible = false;
                uiPanelEdit.Visible = true;
                tabs.Visible = true;
                tabscontent.Visible = true;
                CurrentCard = objData;

                BindData();
                BindCardTxt();
                BindCardLayout();
                BindCardColors();
                BindCardImages();

                uiLabelCatName.Text = uiDropDownListCats.SelectedItem.Text;
                uiLabelCardName.Text = objData.CardNameEng;
            }
            else if (e.CommandName == "DeleteCard")
            {
                try
                {
                    int id = Convert.ToInt32(e.CommandArgument.ToString());

                    CardImages images = new CardImages();
                    images.GetCardImageByCardID(id);
                    int irows = images.RowCount;
                    for (int i = 0; i < irows; i++)
                    {
                        images.MarkAsDeleted();
                        images.MoveNext();
                    }
                    images.Save();

                    CardLayouts layouts = new CardLayouts();
                    layouts.GetCardLayoutByCardID(id);
                    int lrows = layouts.RowCount;
                    for (int i = 0; i < lrows; i++)
                    {
                        layouts.MarkAsDeleted();
                        layouts.MoveNext();
                    }

                    layouts.Save();

                    CardText texts = new CardText();
                    texts.GetCardTxtByCardID(id);
                    int trows = texts.RowCount;
                    for (int i = 0; i < trows; i++)
                    {
                        texts.MarkAsDeleted();
                        texts.MoveNext();
                    }

                    texts.Save();

                    CardColor colors = new CardColor();
                    colors.GetCardColorsByCardID(id);
                    int crows = colors.RowCount;
                    for (int i = 0; i < crows; i++)
                    {
                        colors.MarkAsDeleted();
                        colors.MoveNext();
                    }

                    colors.Save();

                    Cards objData = new Cards();
                    objData.LoadByPrimaryKey(id);
                    objData.MarkAsDeleted();
                    objData.Save();
                    CurrentCard = null;
                    BindData();
                }
                catch (Exception ex)
                {
                    return;
                }
            }
        }