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);
}
