public void Update() { int TaxID = int.Parse(Request.QueryString["TaxID"]); int lv = 0; int Taxref = int.Parse(dropParent.SelectedValue); if (Taxref > 0) { Model_PostTaxonomy t = new Model_PostTaxonomy(); lv = t.GetTaxonomyByID(Taxref).Lv + 1; } else { lv = Taxref + 1; } Model_PostTaxonomy tax = new Model_PostTaxonomy { TaxID = TaxID, Lv = lv, Title = txtTitle.Text.Trim(), RefID = Taxref, Slug = slug.Text.GenerateSlug(), BodyContent = txtContent.Text.Trim(), BodyContentBuilder = txtContentBuilder.Text.Trim(), Status = bool.Parse(dropStatus.SelectedValue), BannerTypeID = byte.Parse(CoverType.Value), ShowMasterSlider = bool.Parse(radioshowmMS.SelectedValue), }; Model_TaxSEOMap seomap = new Model_TaxSEOMap(); seomap = seomap.GetSEOID(TaxID); Model_PostSeo seo = new Model_PostSeo { SEOTitle = seotitle.Text.Trim(), MetaDescription = metades.Text.Trim(), CanonicalUrl = Canonical.Text.Trim(), Metarobotsfollow = bool.Parse(droprebot.SelectedValue), FaceBookTitle = facebookTitle.Text.Trim(), FacebookDescription = facebookDes.Text.Trim(), FacebookImage = facebookImg.Value, TwitterTitle = twTitle.Text.Trim(), TwitterDescription = twDes.Text.Trim(), TwitterImages = twimg.Value, GoogleAnalytic = analytic.Text.Trim(), }; if (seomap != null) { seo.PSID = seomap.PSID; seo.UpdateSEO(seo); } else { int PSID = seo.InsertSEO_step1(seo); if (PSID > 0) { seomap = new Model_TaxSEOMap { TaxID = TaxID, PSID = PSID }; seomap.InsertMApSeo(seomap); } } if (!string.IsNullOrEmpty(hd_MID.Value)) { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.CoverImage, TaxID = TaxID, MID = int.Parse(hd_MID.Value) }; pm.insertMediaPost(pm); } else { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.CoverImage, TaxID = TaxID }; pm.DeleteTaxMedia(pm); } //Feature image if (!string.IsNullOrEmpty(feature_image_mid.Value)) { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.FeatureImage, TaxID = TaxID, MID = int.Parse(feature_image_mid.Value) }; pm.insertMediaPost(pm); } else { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.FeatureImage, TaxID = TaxID }; pm.DeleteTaxMedia(pm); } //Feature image full if (!string.IsNullOrEmpty(image_full_width_mid.Value)) { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.Feature_Image_full_Width, TaxID = TaxID, MID = int.Parse(image_full_width_mid.Value) }; pm.insertMediaPost(pm); } else { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.Feature_Image_full_Width, TaxID = TaxID }; pm.DeleteTaxMedia(pm); } //Banner Upsell if (!string.IsNullOrEmpty(banner_upsale_mid.Value)) { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.Banner_Upsell, TaxID = TaxID, MID = int.Parse(banner_upsale_mid.Value), Caption = textCationUpsale.Text }; pm.insertMediaPost(pm); } else { Model_TaxMedia pm = new Model_TaxMedia { TaxMediaTypeID = TaxMediaType.Banner_Upsell, TaxID = TaxID }; pm.DeleteTaxMedia(pm); } bool ret = tax.UpdateTaxonomy(tax); if (ret) { Response.Redirect("Taxonomy.aspx?TaxTypeID=" + this.TaxTypeID + "&PostTypeID=" + this.PostTypeID + "&Mode=Edit&TaxID=" + TaxID); } }
protected void btnPubish_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["PostID"])) { int intPostID = int.Parse(Request.QueryString["PostID"]); Model_Post p = new Model_Post { PostID = intPostID, PostTypeID = 1, Title = txtTitle.Text.Trim(), Short = "", Slug = slug.Text.GenerateSlug(), DateSubmit = DatetimeHelper._UTCNow(), UserID = this.UserActive.UserID, DatePublish = DatetimeHelper._UTCNow(), Status = bool.Parse(dropStatus.SelectedValue), ShowComment = false, BodyContent = txtContent.Text.Trim(), BodyContentBuilder = txtContentBuilder.Text.Trim(), BannerTypeID = byte.Parse(CoverType.Value), ShowMasterSlider = bool.Parse(radioshowmMS.SelectedValue), ViewCount = 1 }; Model_PostSEOMap seomap = new Model_PostSEOMap(); seomap = seomap.GetSEOID(intPostID); Model_PostSeo seo = new Model_PostSeo { SEOTitle = seotitle.Text.Trim(), MetaDescription = metades.Text.Trim(), CanonicalUrl = Canonical.Text.Trim(), Metarobotsfollow = bool.Parse(droprebot.SelectedValue), FaceBookTitle = facebookTitle.Text.Trim(), FacebookDescription = facebookDes.Text.Trim(), FacebookImage = facebookImg.Value, TwitterTitle = twTitle.Text.Trim(), TwitterDescription = twDes.Text.Trim(), TwitterImages = twimg.Value, GoogleAnalytic = analytic.Text.Trim(), }; Model_PostPricing pp = new Model_PostPricing(); if (!string.IsNullOrEmpty(hd_productPrice_id.Value)) { pp = pp.GetPostPriceAllByID(int.Parse(hd_productPrice_id.Value)); } if (pp != null) { Model_PostPricing pu = new Model_PostPricing { Price = string.IsNullOrEmpty(txtProductPrice.Text)? 0: decimal.Parse(txtProductPrice.Text), PriceID = pp.PriceID, Isvat = bool.Parse(priceVat.SelectedValue), Title = txtPriceTitle.Text }; pu.UpdataPostPrice(pu); Model_PostPricingOption cpo = new Model_PostPricingOption(); Model_PostPricingOptionQty cq0 = new Model_PostPricingOptionQty(); cq0.DeleteOPtionPriceQty(pp.PriceID); cpo.DeleteOPtionPrice(pp.PriceID); string po = Request.Form["chk_price_option"]; if (!string.IsNullOrEmpty(po)) { string[] arrpo = po.Split(','); foreach (string poi in arrpo) { Model_PostPricingOption cpoi = new Model_PostPricingOption(); cpoi.PriceID = pp.PriceID; cpoi.Title = Request.Form["po_title_s_" + poi]; int cp = cpoi.InsertPriceOPtion(cpoi); string q = Request.Form["chk_price_option_qty_" + poi]; if (!string.IsNullOrEmpty(q)) { string[] arrq = q.Split(','); foreach (string qq in arrq) { Model_PostPricingOptionQty cq = new Model_PostPricingOptionQty(); cq.PriceID = pp.PriceID; cq.PriceOptionID = cp; cq.UnitFrom = string.IsNullOrEmpty(Request.Form["po_from_s_q" + poi + "_" + qq]) ? 1 : int.Parse(Request.Form["po_from_s_q" + poi + "_" + qq]); cq.UnitTo = string.IsNullOrEmpty(Request.Form["po_to_s_q" + poi + "_" + qq]) ? 0 : int.Parse(Request.Form["po_to_s_q" + poi + "_" + qq]); cq.PriceOption = string.IsNullOrEmpty(Request.Form["po_p_s_q" + poi + "_" + qq]) ? 0 : decimal.Parse(Request.Form["po_p_s_q" + poi + "_" + qq]); cq.InsertPriceOPtionQty(cq); } } } } } if (seomap != null) { seo.PSID = seomap.PSID; seo.UpdateSEO(seo); } else { int PSID = seo.InsertSEO_step1(seo); if (PSID > 0) { seomap = new Model_PostSEOMap { PostID = intPostID, PSID = PSID }; seomap.InsertMApSeo(seomap); } } //Cover if (!string.IsNullOrEmpty(hd_MID.Value)) { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.CoverImage, PostID = intPostID, MID = int.Parse(hd_MID.Value) }; pm.insertMediaPost(pm); } else { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.CoverImage, PostID = intPostID }; pm.DeletePostMedia(pm); } //Feature image if (!string.IsNullOrEmpty(feature_image_mid.Value)) { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.FeatureImage, PostID = intPostID, MID = int.Parse(feature_image_mid.Value) }; pm.insertMediaPost(pm); } else { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.FeatureImage, PostID = intPostID }; pm.DeletePostMedia(pm); } //Check Cutom Post Field Model_PostCustomGroup pct = new Model_PostCustomGroup(); List <Model_PostCustomGroup> pctList = pct.getCustomByPostID(intPostID); if (pctList.SingleOrDefault(i => i.PcGroupName == "HomeGroup") != null) { //"HomeGroup": //banner announce Model_PostCustomItem cpi = new Model_PostCustomItem(); cpi.PostID = intPostID; cpi.PCDID = (int)CustomGroup.HomeGroup; cpi.PcGroupName = "HomeGroup"; cpi.MID = !string.IsNullOrEmpty(b1_id.Value) ? int.Parse(b1_id.Value) : 0; cpi.Caption1 = banner_home_1.Text.Trim(); cpi.URL = b1_url.Value; cpi.PcName = "banner-announce"; cpi.ClearCustomByPostIDandName(intPostID, "banner-announce"); cpi.Insert(cpi); //banner left Model_PostCustomItem cpi_1 = new Model_PostCustomItem(); cpi_1.PCDID = (int)CustomGroup.HomeGroup; cpi_1.PostID = intPostID; cpi_1.PcGroupName = "HomeGroup"; cpi_1.MID = !string.IsNullOrEmpty(b2_id.Value) ? int.Parse(b2_id.Value) : 0; cpi_1.Caption1 = banner_home_2.Text.Trim(); cpi_1.URL = b2_url.Value; cpi_1.PcName = "banner-announce-right"; cpi_1.ClearCustomByPostIDandName(intPostID, "banner-announce-right"); cpi_1.Insert(cpi_1); //banner Model_PostCustomItem cpi_2_c = new Model_PostCustomItem(); cpi_2_c.ClearCustomByPostIDandName(intPostID, "banner-client"); string chk_banner_client = Request.Form["chk_banner_client"]; if (!string.IsNullOrEmpty(chk_banner_client)) { string[] arr = chk_banner_client.Split(','); foreach (string i in arr) { Model_PostCustomItem cpi_2 = new Model_PostCustomItem(); cpi_2.PCDID = (int)CustomGroup.HomeGroup; cpi_2.PostID = intPostID; cpi_2.PcGroupName = "HomeGroup"; cpi_2.MID = !string.IsNullOrEmpty(Request.Form["b3_id_" + i]) ? int.Parse(Request.Form["b3_id_" + i]) : 0; cpi_2.Caption1 = Request.Form["caption_s_" + i]; cpi_2.URL = Request.Form["b3_url_" + i]; cpi_2.PcName = "banner-client"; cpi_2.Insert(cpi_2); } } } if (pctList.SingleOrDefault(i => i.PcGroupName == "ProductGroup") != null) { // product_detail = 1, //product_information = 2, //product_b_announce = 3, //product_b_rigth = 4 //banner announce Model_PostCustomItem cpi = new Model_PostCustomItem(); cpi.PostID = intPostID; cpi.PCDID = (int)CustomGroup.ProductGroup; cpi.PcGroupName = "ProductGroup"; cpi.MID = !string.IsNullOrEmpty(p_banner_ann_mid_8.Value) ? int.Parse(p_banner_ann_mid_8.Value) : 0; cpi.Caption1 = p_banner_ann_caption.Text.Trim(); cpi.URL = p_banner_ann_8.Value; cpi.PcName = "product-b-announce"; cpi.ClearCustomByPostIDandName(intPostID, "product-b-announce"); cpi.Insert(cpi); //banner left Model_PostCustomItem cpi_1 = new Model_PostCustomItem(); cpi_1.PCDID = (int)CustomGroup.ProductGroup; cpi_1.PostID = intPostID; cpi_1.PcGroupName = "ProductGroup"; cpi_1.MID = !string.IsNullOrEmpty(p_banner_mid_9.Value) ? int.Parse(p_banner_mid_9.Value) :0; cpi_1.Caption1 = p_banner_rigth.Text.Trim(); cpi_1.URL = p_banner_9.Value; cpi_1.PcName = "product-b-rigth"; cpi_1.ClearCustomByPostIDandName(intPostID, "product-b-rigth"); cpi_1.Insert(cpi_1); //product detail Model_PostCustomItem p_detail = new Model_PostCustomItem(); p_detail.PCDID = (int)CustomGroup.ProductGroup; p_detail.PostID = intPostID; p_detail.PcGroupName = "ProductGroup"; p_detail.ContentHTML = ProductDetail.Text; p_detail.PcName = "product-detail"; p_detail.ClearCustomByPostIDandName(intPostID, "product-detail"); p_detail.Insert(p_detail); //product information Model_PostCustomItem p_information = new Model_PostCustomItem(); p_information.PCDID = (int)CustomGroup.ProductGroup; p_information.PostID = intPostID; p_information.PcGroupName = "ProductGroup"; p_information.ContentHTML = ProductInformation.Text; p_information.PcName = "product-information"; p_information.ClearCustomByPostIDandName(intPostID, "product-information"); p_information.Insert(p_information); //Product Code Model_PostCustomItem cpi_code = new Model_PostCustomItem(); cpi_code.PCDID = (int)CustomGroup.ProductGroup; cpi_code.PostID = intPostID; cpi_code.PcGroupName = "ProductGroup"; cpi_code.TextData = txtProductCode.Text; cpi_code.PcName = "product-code"; cpi_code.ClearCustomByPostIDandName(intPostID, "product-code"); cpi_code.Insert(cpi_code); //Product Quantity Model_PostCustomItem cpi_quan = new Model_PostCustomItem(); cpi_quan.PCDID = (int)CustomGroup.ProductGroup; cpi_quan.PostID = intPostID; cpi_quan.PcGroupName = "ProductGroup"; cpi_quan.NumData = string.IsNullOrEmpty(txtProductQuantity.Text)? 0: int.Parse(txtProductQuantity.Text); cpi_quan.PcName = "product-quantity"; cpi_quan.ClearCustomByPostIDandName(intPostID, "product-quantity"); cpi_quan.Insert(cpi_quan); //Product Code //Model_PostCustomItem cpi_price = new Model_PostCustomItem(); //cpi_price.PCDID = (int)CustomGroup.ProductGroup; //cpi_price.PostID = intPostID; //cpi_price.PcGroupName = "ProductGroup"; //cpi_price.PriceData = string.IsNullOrEmpty(txtProductPrice.Text) ? 0 : decimal.Parse(txtProductPrice.Text); //cpi_price.PcName = "product-price-per-unit"; //cpi_price.ClearCustomByPostIDandName(intPostID, "product-price-per-unit"); //cpi_price.Insert(cpi_price); // product_code = 5, //product_quantity = 6, //product_price_per_unit = 7 } //Model_PostCustomGroup pct = new Model_PostCustomGroup(); //List<Model_PostCustomGroup> pctList = pct.getCustomByPostID(intPostID); //foreach (Model_PostCustomGroup pci in pctList) //{ // switch (pci.PcGroupName) // { // case "HomeGroup": // pn_home_custom.Visible = true; // break; // } //}product_tax_cat product_tax_tags Model_TaxMap ctm = new Model_TaxMap(); string product_tax_cat = Request.Form["product_tax_cat"]; string product_tax_tags = Request.Form["product_tax_tags"]; if (!string.IsNullOrEmpty(product_tax_cat)) { ctm.ClearRaxPostMap(intPostID, (byte)PostTaxonomyType.Categories); string[] arrcat = product_tax_cat.Split(','); foreach (string i in arrcat) { ctm.UpdateInsertPostTax(int.Parse(i), intPostID, (byte)PostTaxonomyType.Categories); } } if (!string.IsNullOrEmpty(product_tax_tags)) { ctm.ClearRaxPostMap(intPostID, (byte)PostTaxonomyType.Tags); string[] arrtag = product_tax_tags.Split(','); foreach (string i in arrtag) { ctm.UpdateInsertPostTax(int.Parse(i), intPostID, (byte)PostTaxonomyType.Tags); } } string gall = Request.Form["checkGall"]; if (!string.IsNullOrEmpty(gall)) { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.Gallery, PostID = intPostID }; pm.DeletePostMedia(pm); string[] arrGall = gall.Split(','); foreach (string i in arrGall) { Model_PostMedia cpm = new Model_PostMedia { PostMediaTypeID = PostMediaType.Gallery, PostID = intPostID, MID = int.Parse(i), Priority = int.Parse(Request.Form["p_gall_pri" + i]) }; cpm.insertMediaPostGall(cpm); } } else { Model_PostMedia pm = new Model_PostMedia { PostMediaTypeID = PostMediaType.Gallery, PostID = intPostID }; pm.DeletePostMedia(pm); } //Media Gallery if (p.UpdatePost(p)) { Response.Redirect(Request.Url.ToString()); } } }
public void Update() { byte intPostTypeID = byte.Parse(this.PostTypeID); Model_PostType cp = new Model_PostType { PostTypeID = intPostTypeID, Title = txtTitle.Text.Trim(), Slug = slug.Text.GenerateSlug(), // BodyContent = txtContent.Text.Trim(), //BodyContentBuilder = txtContentBuilder.Text.Trim(), //Status = bool.Parse(dropStatus.SelectedValue), BannerTypeID = byte.Parse(CoverType.Value), ShowMasterSlider = bool.Parse(radioshowmMS.SelectedValue), }; Model_PostTypeSEOMap seomap = new Model_PostTypeSEOMap(); seomap = seomap.GetSEOID(intPostTypeID); Model_PostSeo seo = new Model_PostSeo { SEOTitle = seotitle.Text.Trim(), MetaDescription = metades.Text.Trim(), CanonicalUrl = Canonical.Text.Trim(), Metarobotsfollow = bool.Parse(droprebot.SelectedValue), FaceBookTitle = facebookTitle.Text.Trim(), FacebookDescription = facebookDes.Text.Trim(), FacebookImage = facebookImg.Value, TwitterTitle = twTitle.Text.Trim(), TwitterDescription = twDes.Text.Trim(), TwitterImages = twimg.Value, GoogleAnalytic = analytic.Text.Trim(), }; if (seomap != null) { seo.PSID = seomap.PSID; seo.UpdateSEO(seo); } else { int PSID = seo.InsertSEO_step1(seo); if (PSID > 0) { seomap = new Model_PostTypeSEOMap { PostTypeID = intPostTypeID, PSID = PSID }; seomap.InsertMApSeo(seomap); } } if (!string.IsNullOrEmpty(hd_MID.Value)) { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.CoverImage, PostTypeID = intPostTypeID, MID = int.Parse(hd_MID.Value) }; pm.insertMediaPost(pm); } else { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.CoverImage, PostTypeID = intPostTypeID }; pm.DeletePostTypeMedia(pm); } //Feature image if (!string.IsNullOrEmpty(feature_image_mid.Value)) { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.FeatureImage, PostTypeID = intPostTypeID, MID = int.Parse(feature_image_mid.Value) }; pm.insertMediaPost(pm); } else { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.FeatureImage, PostTypeID = intPostTypeID }; pm.DeletePostTypeMedia(pm); } //Feature image full if (!string.IsNullOrEmpty(image_full_width_mid.Value)) { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.Feature_Image_full_Width, PostTypeID = intPostTypeID, MID = int.Parse(image_full_width_mid.Value) }; pm.insertMediaPost(pm); } else { Model_PostTypeMedia pm = new Model_PostTypeMedia { PostTypeMediaTypeID = PostTypeMediaType.Feature_Image_full_Width, PostTypeID = intPostTypeID }; pm.DeletePostTypeMedia(pm); } bool ret = cp.UpdatePostType(cp); if (ret) { Response.Redirect(Request.Url.ToString()); } //Response.Redirect("Taxonomy.aspx?TaxTypeID=" + this.TaxTypeID + "&PostTypeID=" + this.PostTypeID + "&Mode=Edit&PostTypeID=" + PostTypeID); }