protected void uiLinkButtonUpdate_Click(object sender, EventArgs e)
 {
     DBLayer db = new DBLayer();
     if (uiFileUploadPhoto.HasFile)
     {
         if (!string.IsNullOrEmpty(uiDropDownListCats.SelectedValue))
         {
             string path = "/UploadedFiles/gallery/" + DateTime.Now.ToString("ddMMyyyyhhmmss") + uiFileUploadPhoto.FileName;
             optimizePic("~" + path);
             db.AddProductContent(uiTextBoxTitle.Text, path, Convert.ToInt32(uiDropDownListCats.SelectedValue),"","","","");
             BindData();
         }
     }
 }
        private void AddNewRecord()
        {
            DBLayer db = new DBLayer();

            string filepath = "";
            if (uiFileUploadMainPicturePath.HasFile)
            {

                filepath = "/UploadedFiles/products/" + DateTime.Now.ToString("ddMMyyyyhhmmss") + "_"+  uiDropDownListCats.SelectedValue + "b_" + uiFileUploadMainPicturePath.FileName;
                //if (uiCheckBoxOptimize.Checked)
                //    optimizePic(filepath);
                //else
                    uiFileUploadMainPicturePath.SaveAs(Server.MapPath("~/" + filepath));
            }

            /*string thumbfilepath = "";
            if (uiFileUploadThumbs.HasFile)
            {
                uiFileUploadThumbs.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "s_" + uiFileUploadThumbs.FileName));
                thumbfilepath = "/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "s_" + uiFileUploadThumbs.FileName;
            }*/
            db.AddProductContent(uiTextBoxName.Text, filepath, Convert.ToInt32(uiDropDownListCats.SelectedValue), "", "", "");
        }
        private void AddNewRecord()
        {
            DBLayer db = new DBLayer();

            string filepath = "";
            if (uiFileUploadMainPicturePath.HasFile)
            {

                filepath = "/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "b_" +uiFileUploadMainPicturePath.FileName;
                if(uiCheckBoxOptimize.Checked)
                    optimizePic(filepath);
                else
                    uiFileUploadMainPicturePath.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "b_"  +uiFileUploadMainPicturePath.FileName));
            }

            string thumbfilepath = "";
            if (uiFileUploadThumbs.HasFile)
            {
                uiFileUploadThumbs.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "s_"  +uiFileUploadThumbs.FileName));
                thumbfilepath = "/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "s_" + uiFileUploadThumbs.FileName;
            }
            db.AddProductContent(uiTextBoxName.Text, filepath, Convert.ToInt32(uiDropDownListCats.SelectedValue), thumbfilepath, uiTextBoxDescription.Text, uiTextBoxPrice.Text);
        }
        private void AddNewRecord()
        {
            DBLayer db = new DBLayer();

            string filepath = "";
            if (uiFileUploadMainPicturePath.HasFile)
            {
                uiFileUploadMainPicturePath.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiFileUploadMainPicturePath.FileName));
                filepath = "/UploadedFiles/products/" + uiFileUploadMainPicturePath.FileName;
            }

            string thumbfilepath = "";
            if (uiFileUploadThumbs.HasFile)
            {
                uiFileUploadThumbs.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiFileUploadThumbs.FileName));
                thumbfilepath = "/UploadedFiles/products/" + uiFileUploadThumbs.FileName;
            }
            db.AddProductContent(uiTextBoxName.Text, filepath, Convert.ToInt32(uiDropDownListCats.SelectedValue), thumbfilepath, uiTextBoxDesignerName.Text);
        }
        private void AddNewRecord()
        {
            DBLayer db = new DBLayer();

            string filepath = "";

            DirectoryInfo dir = new DirectoryInfo(Server.MapPath("~/UploadedFiles/products/" + uiDropDownListCats.SelectedValue +"_"+ uiTextBoxName.Text));
            if (!dir.Exists)
                dir.Create();
            string thumbfilepath = "";
            if (uiFileUploadThumbs.HasFile)
            {
                uiFileUploadThumbs.SaveAs(Server.MapPath("~/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "_" + uiTextBoxName.Text + "/" + uiDropDownListCats.SelectedValue + "s_" + uiFileUploadThumbs.FileName));
                thumbfilepath = "/UploadedFiles/products/" + uiDropDownListCats.SelectedValue + "_" + uiTextBoxName.Text + "/" + uiDropDownListCats.SelectedValue + "s_" + uiFileUploadThumbs.FileName;
            }
            db.AddProductContent(uiTextBoxName.Text, uiTextBoxName_en.Text, filepath, Convert.ToInt32(uiDropDownListCats.SelectedValue), thumbfilepath, Server.HtmlEncode(uiFCKeditorDesc.Value), Server.HtmlEncode(uiFCKeditorDesc_en.Value), "");
        }