protected void rptBlogGroup_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { HiddenField hfBlogGroupID = (HiddenField)e.Item.FindControl("hfBlogGroupID"); Guid BlogGroupID = new Guid(hfBlogGroupID.Value.ToString()); Repeater rptBlogs = (Repeater)e.Item.FindControl("rptBlogs"); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Blogs.AsEnumerable() join aa in db.BlogGroups on u.fk_BlogGroupID equals aa.BlogGroupID where u.fk_BlogGroupID == BlogGroupID && u.IsDelete == false select new { BlogTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.BlogTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_BlogTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_BlogTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_BlogTitle : u.BlogTitle))), u.BlogName, aa.BlogGroupName }).ToList(); rptBlogs.DataSource = n; rptBlogs.DataBind(); } } }
public void rptRelatedProductsBind() { if (Request.QueryString["ColorID"] != null) { Guid ProductColorID = new Guid(Request.QueryString["ColorID"].ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { ProductColors n = db.ProductColors.Find(ProductColorID); Products o = db.Products.Find(n.fk_ProductID); if (!IdentifyCulture.cultureName().Contains("fa")) { var m = (from u in db.ProductColors join aa in db.Products on u.fk_ProductID equals aa.ProductID join aaa in db.ProductGroup on aa.fk_ProductGroupID equals aaa.ProductGroupID where u.fk_ProductID != n.fk_ProductID && aa.fk_ProductGroupID == o.fk_ProductGroupID && aa.IsDelete == false && aaa.IsDelete == false && u.IsDelete == false && aa.IsAlienCulture == true && aa.IsActive == true && u.ProductImage != null select new { u.ProductColorID, u.ProductImage, aa.ProductTitle, aaa.ProductGroupName, aa.ProductName }).ToList(); rptRelatedProducts.DataSource = m; rptRelatedProducts.DataBind(); } else { var m = (from u in db.ProductColors join aa in db.Products on u.fk_ProductID equals aa.ProductID join aaa in db.ProductGroup on aa.fk_ProductGroupID equals aaa.ProductGroupID where u.fk_ProductID != n.fk_ProductID && aa.fk_ProductGroupID == o.fk_ProductGroupID && aa.IsDelete == false && aaa.IsDelete == false && u.IsDelete == false && aa.IsAlienCulture != true && aa.IsActive == true && u.ProductImage != null select new { u.ProductColorID, u.ProductImage, aa.ProductTitle, aaa.ProductGroupName, aa.ProductName }).ToList(); rptRelatedProducts.DataSource = m; rptRelatedProducts.DataBind(); } } } }
public void ChooseTitleAndDesc() { string ProductGroupName = Page.RouteData.Values["ProductGroupName"].ToString(); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.ProductGroup.AsEnumerable() where a.IsDelete == false && a.ProductGroupName == ProductGroupName select new { ProductGroupTitle = (IdentifyCulture.cultureName().Contains("fa")) ? a.ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_ProductGroupTitle : a.ProductGroupTitle))), desc = (IdentifyCulture.cultureName().Contains("fa")) ? a.ProductGroupDesc : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_ProductGroupDesc : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_ProductGroupDesc : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_ProductGroupDesc : a.ProductGroupDesc))), }).FirstOrDefault(); if (string.IsNullOrEmpty(n.desc)) { pnlDesc.Visible = false; } else { pnlDesc.Visible = true; ltPageDesc.Text = n.desc; } if (IdentifyCulture.cultureName().Contains("fa")) { ScriptManager.RegisterStartupScript(this, GetType(), "PageScriptfa", "$('.newfa').removeClass('fa-arrow-right'); $('.newfa').addClass('fa-arrow-left');", true); Page.Title = "فرش های " + n.ProductGroupTitle + " | وب سایت رسمی فرش مشهد"; Page.MetaDescription = "خرید فرش " + n.ProductGroupTitle + " در فروشگاه آنلاین فرش مشهد، ارائه دهنده بهترین فرش های ماشینی با ارزانترین قیمت و ارسال رایگان به سراسر کشور. "; } else if (IdentifyCulture.cultureName().Contains("en")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("ru")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("zh")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else { Page.Title = "فرش های " + n.ProductGroupTitle + " | وب سایت رسمی فرش مشهد"; Page.MetaDescription = "خرید فرش " + n.ProductGroupTitle + " در فروشگاه آنلاین فرش مشهد، ارائه دهنده بهترین فرش های ماشینی با ارزانترین قیمت و ارسال رایگان به سراسر کشور. "; } } }
protected void rptSize_ItemCommand(object source, RepeaterCommandEventArgs e) { if (Request.QueryString["ColorID"] != null) { Guid ProductColorID = new Guid(Request.QueryString["ColorID"].ToString()); int SizeID = int.Parse(e.CommandArgument.ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.ProductColorSizes where a.fk_ProductColorID == ProductColorID && a.fk_SizeID == SizeID && a.IsAvailable == true select a).FirstOrDefault(); if (n.Stock != 0) { if (CheckDiscountAndReturnDisconuntPercent(SizeID) == 0) { string[] pricestring = (String.Format("{0:N}", n.ProductPrice)).Split('/'); lblPrice.Text = pricestring[0] + "تومان"; pnlNewPrice.Visible = false; disablePrice(false); lblPrice.CssClass = "fontBRoya floatLeft marginright20 directionRTL pricestyle"; } else { disablePrice(false); //new price double percent = CheckDiscountAndReturnDisconuntPercent(SizeID); double pricenew = CalculateNewPrice(percent, (decimal)n.ProductPrice); pnlNewPrice.Visible = true; string[] pricestring_New = (String.Format("{0:n}", pricenew)).Split('/'); ltNewPrice.Text = (IdentifyCulture.cultureName().Contains("fa")) ? string.Format("{0:N0}", pricestring_New[0]) + " تومان" : ((IdentifyCulture.cultureName().Contains("en")) ? string.Format("{0:N0}", pricestring_New[0]) + " Toman" : ((IdentifyCulture.cultureName().Contains("ru")) ? string.Format("{0:N0}", pricestring_New[0]) + " RS" : ((IdentifyCulture.cultureName().Contains("zh")) ? string.Format("{0:N0}", pricestring_New[0]) + " RS" : string.Format("{0:N0}", pricestring_New[0]) + " تومان"))); //old price lblPrice.CssClass = "fontBRoya floatLeft marginright20 directionRTL pricestyle oldPrice"; string[] pricestring = (String.Format("{0:n}", n.ProductPrice)).Split('/'); lblPrice.Text = (IdentifyCulture.cultureName().Contains("fa")) ? string.Format("{0:N0}", pricestring[0]) + " تومان" : ((IdentifyCulture.cultureName().Contains("en")) ? string.Format("{0:N0}", pricestring[0]) + " Toman" : ((IdentifyCulture.cultureName().Contains("ru")) ? string.Format("{0:N0}", pricestring[0]) + " RS" : ((IdentifyCulture.cultureName().Contains("zh")) ? string.Format("{0:N0}", pricestring[0]) + " RS" : string.Format("{0:N0}", pricestring[0]) + " تومان"))); } } else { disablePrice(true); } ViewState["SizeID"] = SizeID; rptSizeBind(); } } }
protected void Page_Load(object sender, EventArgs e) { //UpdateAlienImages(); // HttpCookie cookie = Request.Cookies["CurrentLanguage"]; if (IdentifyCulture.cultureName().Contains("fa")) { var persianCulture = new PersianCulture(); Thread.CurrentThread.CurrentCulture = persianCulture; Thread.CurrentThread.CurrentUICulture = persianCulture; imglogo.ImageUrl = "~/images/Logo2.png"; imgSh.ImageUrl = "~/images/Shoar.png"; const string styleFormat = "<LINK href=\"{0}\" type=\"text/css\" rel=\"stylesheet\">"; string linkText; linkText = String.Format(styleFormat, StyleSheetPathFa); StyleSheet.Text = linkText; } else { imglogo.ImageUrl = "~/images/Logo-eng.png"; imgSh.ImageUrl = "~/images/Shor-Eng.png"; const string styleFormat = "<LINK href=\"{0}\" type=\"text/css\" rel=\"stylesheet\">"; string linkText; linkText = String.Format(styleFormat, StyleSheetPath); StyleSheet.Text = linkText; } if (!Page.IsPostBack) { ChooseTitleAndDesc(); rptProductGroupBind(); OrderLoad(); rptRecentProductsBind(); rptLinksBind(); rptBlogsBind(); rptSliderBind(); rptMiddelTextBind(); rptBuyingManualBind(); rptMainProductGroupBind(); rptTextBind(); PaymentBtnAddress(); //UpdatePaymentDate(); } }
public void rptAccordionBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var nn = (from u in db.Texts.AsEnumerable() where u.GroupID == 6 && u.IsDelete == false select new { u.TextName, u.TextID, u.TextImage, TextTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextTitle : u.TextTitle))), TextDescription = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextDescription : u.TextDescription))), }).FirstOrDefault(); // lblAccordTitle.Text = nn.TextTitle; // lblAccordDesc.Text = nn.TextDescription; var t = (from u in db.Texts.AsEnumerable() where u.GroupID == 20 && u.IsDelete == false select u).Count(); var n = (from u in db.Texts.AsEnumerable() where u.GroupID == 20 && u.IsDelete == false select new { u.TextName, u.TextID, u.TextImage, TextTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextTitle : u.TextTitle))), TextDescription = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextDescription : u.TextDescription))), }).ToList(); rptTextTabGroups.DataSource = n; rptTextTabGroups.DataBind(); rptTextBody.DataSource = n; rptTextBody.DataBind(); } }
public void callInfo() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.Texts where a.TextID == 1067 select a).FirstOrDefault(); lblCall.Text = (IdentifyCulture.cultureName().Contains("fa")) ? n.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? n.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? n.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? n.China_TextDescription : n.TextDescription))); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (IdentifyCulture.cultureName().Contains("fa")) { ScriptManager.RegisterStartupScript(this, GetType(), "PageScriptfa", "$('.newfa').removeClass('fa-arrow-right'); $('.newfa').addClass('fa-arrow-left');", true); } rptFactoryInfoBind(); rptheadquartersBind(); ChooseTitleAndDesc(); } }
public void ChooseTitleAndDesc() { if (Page.RouteData.Values["BlogName"] != null) { string BlogName = Page.RouteData.Values["BlogName"].ToString().ToLower(); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Blogs.AsEnumerable() where u.BlogName.ToLower() == BlogName select new { u.BlogTitle, u.EN_BlogTitle , u.China_BlogTitle, u.Rus_BlogTitle , BlogText = (IdentifyCulture.cultureName().Contains("fa")) ? (u.BlogText.Length > 200 ? u.BlogText.Substring(0, 200) : u.BlogText) : ((IdentifyCulture.cultureName().Contains("en")) ? (u.EN_BlogText.Length > 200 ? u.EN_BlogText.Substring(0, 200) : u.EN_BlogText) : ((IdentifyCulture.cultureName().Contains("ru")) ? (u.Rus_BlogText.Length > 200 ? u.Rus_BlogText.Substring(0, 200) : u.Rus_BlogText) : ((IdentifyCulture.cultureName().Contains("zh")) ? (u.China_BlogText.Length > 200 ? u.China_BlogText.Substring(0, 200) : u.China_BlogText) : (u.BlogText.Length > 200 ? u.BlogText.Substring(0, 200) : u.BlogText)))), }).FirstOrDefault(); if (IdentifyCulture.cultureName().Contains("fa")) { Page.Title = n.BlogTitle + " | وب سایت رسمی فرش مشهد"; } else if (IdentifyCulture.cultureName().Contains("en")) { Page.Title = n.EN_BlogTitle + " | mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("ru")) { Page.Title = n.Rus_BlogTitle + " | mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("zh")) { Page.Title = n.China_BlogTitle + " | mashad carpet website"; } else { Page.Title = n.BlogTitle + " | وب سایت رسمی فرش مشهد"; } Page.MetaDescription = n.BlogText; } } }
protected void rptTickets_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { HiddenField hfTicketID = (HiddenField)e.Item.FindControl("hfTicketID"); Guid TicketID = new Guid(hfTicketID.Value.ToString()); Label lblStatus = (Label)e.Item.FindControl("lblStatus"); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Tickets where u.TicketID == TicketID select u).FirstOrDefault(); if (n.Status == 1) { lblStatus.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "در انتظار پاسخ" : ((IdentifyCulture.cultureName().Contains("en")) ? "waiting for an answer" : ((IdentifyCulture.cultureName().Contains("ru")) ? "В ожидании ответа" : ((IdentifyCulture.cultureName().Contains("zh")) ? "等待回复" : "در انتظار پاسخ"))); } //lblStatus.Text="در انتظار پاسخ"; else if (n.Status == 2) { lblStatus.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "پاسخ داده شده" : ((IdentifyCulture.cultureName().Contains("en")) ? "has been answered" : ((IdentifyCulture.cultureName().Contains("ru")) ? "Ответил" : ((IdentifyCulture.cultureName().Contains("zh")) ? "回答" : "پاسخ داده شده"))); } //lblStatus.Text = "پاسخ داده شده"; else if (n.Status == 3) { lblStatus.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "پاسخ مشتری" : ((IdentifyCulture.cultureName().Contains("en")) ? "Customer response" : ((IdentifyCulture.cultureName().Contains("ru")) ? "Клиент ответ" : ((IdentifyCulture.cultureName().Contains("zh")) ? "客户响应" : "پاسخ مشتری"))); } //lblStatus.Text = "پاسخ مشتری"; else if (n.Status == 4) { lblStatus.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "بسته شده" : ((IdentifyCulture.cultureName().Contains("en")) ? "closed" : ((IdentifyCulture.cultureName().Contains("ru")) ? "запертый" : ((IdentifyCulture.cultureName().Contains("zh")) ? "锁定" : "بسته شده"))); } //lblStatus.Text = "بسته شده"; } } }
protected void Page_Load(object sender, EventArgs e) { if (IdentifyCulture.cultureName().Contains("fa")) { var persianCulture = new PersianCulture(); Thread.CurrentThread.CurrentCulture = persianCulture; Thread.CurrentThread.CurrentUICulture = persianCulture; ScriptManager.RegisterStartupScript(this, GetType(), "PageScriptfa", "$('.newfa').removeClass('fa-arrow-right'); $('.newfa').addClass('fa-arrow-left');", true); } if (!Page.IsPostBack) { LoadLabels(); CreatePDFFactor(); } }
public void rptSlideBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Texts.AsEnumerable() where u.GroupID == 1 && u.IsDelete == false select new { TextDescription = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextDescription : u.TextDescription))), }).ToList(); rptSlide.DataSource = n; rptSlide.DataBind(); } }
public void ChooseTitleAndDesc() { string ProductName = Page.RouteData.Values["ProductName"].ToString(); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.Products.AsEnumerable() where a.IsDelete == false && a.ProductName != ProductName select new { ProductTitle = (IdentifyCulture.cultureName().Contains("fa")) ? a.ProductTitle : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_ProductTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_ProductTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_ProductTitle : a.ProductTitle))), }).FirstOrDefault(); if (IdentifyCulture.cultureName().Contains("fa")) { UpdatePanel1.Visible = true; pnlAvailableSize.Visible = true; Page.Title = ProductName + " | وب سایت رسمی فرش مشهد"; Page.MetaDescription = "خرید فرش " + n.ProductTitle + " در فروشگاه آنلاین فرش مشهد، ارائه دهنده بهترین فرش های ماشینی با ارزانترین قیمت و ارسال رایگان به سراسر کشور. "; } else if (IdentifyCulture.cultureName().Contains("en")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("ru")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else if (IdentifyCulture.cultureName().Contains("zh")) { Page.Title = "carpet online shopping | mashad carpet website"; Page.MetaDescription = "mashad carpet website"; } else { Page.Title = n.ProductTitle + " | وب سایت رسمی فرش مشهد"; Page.MetaDescription = "خرید فرش " + n.ProductTitle + " در فروشگاه آنلاین فرش مشهد، ارائه دهنده بهترین فرش های ماشینی با ارزانترین قیمت و ارسال رایگان به سراسر کشور. "; } } }
public void rptColorBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Colors.AsEnumerable() where u.IsDelete == false select new { u.ColorID, u.ColorNo, ColorTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.ColorTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.ColorEN_Title : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_ColorTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_ColorTitle : u.ColorTitle))), }).ToList(); rptColors.DataSource = n; rptColors.DataBind(); } }
public void rptBlogGroupBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.BlogGroups.AsEnumerable() where u.IsDelete == false select new { u.BlogGroupName, BlogGroupTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.BlogGroupTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_BlogGroupTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_BlogGroupTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_BlogGroupTitle : u.BlogGroupTitle))), u.BlogGroupID }).ToList(); rptBlogGroup.DataSource = n; rptBlogGroup.DataBind(); } }
protected void rptSlider_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { HiddenField hfID = (HiddenField)e.Item.FindControl("hfID"); Repeater rptSliderText = (Repeater)e.Item.FindControl("rptSliderText"); int ID = Convert.ToInt32(hfID.Value); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.SliderTexts.AsEnumerable() where a.fk_SliderID == ID orderby a.datay descending select new { a.SliderTextID, a.datax, a.datay, a.fk_SliderID, a.InAndOutClass, a.IsLink, a.LinkAddress, a.Slider, a.fontsize, a.speed, a.start, a.textColor, Text = (IdentifyCulture.cultureName().Contains("fa")) ? a.Text : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_Text : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_Text : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_Text : a.Text))), }).ToList(); rptSliderText.DataSource = n; rptSliderText.DataBind(); } } }
public void rptProductsBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { if (!IdentifyCulture.cultureName().Contains("fa")) { var n = (from a in db.ProductGroup.AsEnumerable() where a.fk_ProductGroupID == null && a.IsDelete == false && a.IsAlienCulture == true orderby a.Priority select new { a.ProductGroupName, a.ProductGroupImage, ProductGroupTitle = (IdentifyCulture.cultureName().Contains("fa")) ? a.ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_ProductGroupTitle : a.ProductGroupTitle))), }).ToList(); rptProductgroups.DataSource = n; rptProductgroups.DataBind(); } else { var n = (from a in db.ProductGroup.AsEnumerable() where a.fk_ProductGroupID == null && a.IsDelete == false && a.IsAlienCulture != true orderby a.Priority select new { a.ProductGroupName, a.ProductGroupImage, ProductGroupTitle = a.ProductGroupTitle, }).ToList(); rptProductgroups.DataSource = n; rptProductgroups.DataBind(); } } }
public void rptLinksBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Links.AsEnumerable() orderby u.RegisterDate where u.IsDelete == false select new { u.imgFile, u.LinkAddres, linktitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.title : ((IdentifyCulture.cultureName().Contains("en")) ? u.title_En : ((IdentifyCulture.cultureName().Contains("ru")) ? u.title_Ru : ((IdentifyCulture.cultureName().Contains("zh")) ? u.title_Ch : u.title))) }); rptLinks.DataSource = n; rptLinks.DataBind(); } }
public void rptTabsBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Texts.AsEnumerable() where u.GroupID == 3 && u.IsDelete == false && u.TextID != 3 select new { TextTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextTitle : u.TextTitle))), u.TextID, u.TextImage, TextDescription = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextDescription : u.TextDescription))), }).ToList(); rptTabs.DataSource = n; rptTabs.DataBind(); rptTabPane.DataSource = n; rptTabPane.DataBind(); var m = (from u in db.Texts.AsEnumerable() where u.TextID == 3 select new { u.TextImage, TextDescription = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextDescription : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextDescription : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextDescription : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextDescription : u.TextDescription))), }).FirstOrDefault(); lblDesc.Text = m.TextDescription; TextImage.ImageUrl = "/Uploads/TextImages/" + m.TextImage; } }
public void LoadBannerImages() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.ProductGroup.AsEnumerable() where a.IsDelete == false && a.fk_ProductGroupID == null select new { a.imgSliderImage, a.ProductGroupID, ProductGroupTitle = (IdentifyCulture.cultureName().Contains("fa")) ? a.ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("en")) ? a.EN_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? a.Rus_ProductGroupTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? a.China_ProductGroupTitle : a.ProductGroupTitle))), a.ProductGroupName }).ToList(); rptbannerImages.DataSource = n; rptbannerImages.DataBind(); } }
protected void rptColors_ItemCommand(object source, RepeaterCommandEventArgs e) { if (Request.QueryString["ColorID"] != null) { Guid ProductColorID = new Guid(Request.QueryString["ColorID"].ToString()); int colorID = Convert.ToInt32(e.CommandArgument.ToString()); using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from a in db.ProductColors where a.ProductColorID == ProductColorID select a).FirstOrDefault(); var p = (from a in db.Products where a.ProductID == n.fk_ProductID select a).FirstOrDefault(); var pg = (from a in db.ProductGroup where a.ProductGroupID == p.fk_ProductGroupID select a).FirstOrDefault(); var m = (from a in db.ProductColors where a.fk_ProductID == n.fk_ProductID && a.fk_ColorID == colorID select a).FirstOrDefault(); Response.Redirect("~/carpet-online-shopping/" + pg.ProductGroupName + "/" + p.ProductName + "/?ColorID=" + m.ProductColorID); var c = (from a in db.Colors where a.ColorID == colorID && a.IsDelete == false select a).FirstOrDefault(); if (c != null) { lblColorTitle.Text = (IdentifyCulture.cultureName().Contains("fa")) ? c.ColorTitle : ((IdentifyCulture.cultureName().Contains("en")) ? c.ColorEN_Title : ((IdentifyCulture.cultureName().Contains("ru")) ? c.Rus_ColorTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? c.China_ColorTitle : c.ColorTitle))); } } } }
protected void Page_Load(object sender, EventArgs e) { if (IdentifyCulture.cultureName().Contains("fa")) { var persianCulture = new PersianCulture(); Thread.CurrentThread.CurrentCulture = persianCulture; Thread.CurrentThread.CurrentUICulture = persianCulture; ScriptManager.RegisterStartupScript(this, GetType(), "PageScriptfa", "$('.newfa').removeClass('fa-arrow-right'); $('.newfa').addClass('fa-arrow-left');", true); } if (!Page.IsPostBack) { FindBlog(); rptPopularBlogsBind(); rptLatestBlogsBind(); rptBlogGroupBind(); rptRelatedBlogsBind(); ChooseTitleAndDesc(); } }
public void rptPortfolioBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Texts.AsEnumerable() where u.GroupID == 10 && u.IsDelete == false select new { u.TextName, u.TextID, u.TextImage, TextTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.TextTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_TextTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_TextTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_TextTitle : u.TextTitle))), u.TextDescription }).ToList(); rptPortfolio.DataSource = n; rptPortfolio.DataBind(); } }
public void ddlProvinceBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var pg = (from u in db.Province select u).ToList(); ddlProvince.Items.Clear(); //ddlProvince.Items.Add(new ListItem("استان ", "-1")); ddlProvince.Items.Add(new ListItem((IdentifyCulture.cultureName().Contains("fa") ? "استان" : ((IdentifyCulture.cultureName().Contains("en")) ? "Province" : ((IdentifyCulture.cultureName().Contains("ru")) ? "провинция" : ((IdentifyCulture.cultureName().Contains("zh")) ? "省" : "استان")))), "-1")); foreach (var t in pg) { //ddlProvince.Items.Add(new ListItem(t.ProvinceName, t.ProvinceID.ToString())); ddlProvince.Items.Add(new ListItem((IdentifyCulture.cultureName().Contains("fa") ? t.ProvinceName: ((IdentifyCulture.cultureName().Contains("en")) ? t.EN_ProvinceName : ((IdentifyCulture.cultureName().Contains("ru")) ? t.Rus_ProvinceName : ((IdentifyCulture.cultureName().Contains("zh")) ? t.China_ProvinceName : t.ProvinceName)))), t.ProvinceID.ToString())); } } }
public void ChooseTitleAndDesc() { if (IdentifyCulture.cultureName().Contains("fa")) { Page.Title = "ورود به حساب کاربری"; } else if (IdentifyCulture.cultureName().Contains("en")) { Page.Title = "Login"; } else if (IdentifyCulture.cultureName().Contains("ru")) { Page.Title = "Login"; } else if (IdentifyCulture.cultureName().Contains("zh")) { Page.Title = "Login"; } else { Page.Title = "ورود به حساب کاربری"; } }
public void ChooseTitleAndDesc() { if (IdentifyCulture.cultureName().Contains("fa")) { Page.Title = "ثبت نام | فرش مشهد"; } else if (IdentifyCulture.cultureName().Contains("en")) { Page.Title = "Register"; } else if (IdentifyCulture.cultureName().Contains("ru")) { Page.Title = "Register"; } else if (IdentifyCulture.cultureName().Contains("zh")) { Page.Title = "Register"; } else { Page.Title = "ثبت نام"; } }
public void rptRelatedBlogsBind() { if (Page.RouteData.Values["BlogName"] != null) { string BlogGroupName = Page.RouteData.Values["BlogGroupName"].ToString(); string BlogName = Page.RouteData.Values["BlogName"].ToString().ToLower(); using (MashadCarpetEntities db = new MashadCarpetEntities()) { //var m = (from u in db.Blogs.AsEnumerable() where u.BlogName == BlogName select u).FirstOrDefault(); var n = (from u in db.Blogs.AsEnumerable() join aa in db.BlogGroups on u.fk_BlogGroupID equals aa.BlogGroupID where u.IsDelete == false && u.BlogName.ToLower() != BlogName.ToLower() && aa.BlogGroupName == BlogGroupName select new { u.BlogImage, u.SubmitDate, BlogTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.BlogTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_BlogTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_BlogTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_BlogTitle : u.BlogTitle))), BlogText = (IdentifyCulture.cultureName().Contains("fa")) ? (u.BlogSummery) : ((IdentifyCulture.cultureName().Contains("en")) ? (u.EN_BlogSummery) : ((IdentifyCulture.cultureName().Contains("ru")) ? (u.Rus_BlogSummery) : ((IdentifyCulture.cultureName().Contains("zh")) ? (u.China_BlogSummery) : (u.BlogSummery)))), u.BlogName, aa.BlogGroupName }).ToList(); rptRelatedBlogs.DataSource = n; rptRelatedBlogs.DataBind(); } } }
protected void rptTickets_ItemCommand(object source, RepeaterCommandEventArgs e) { Guid TicketID = new Guid(e.CommandArgument.ToString()); ViewState["TicketID"] = TicketID; if (e.CommandName == "Show") { pnlTickets.Visible = false; pnlAswers.Visible = true; using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Tickets join i in db.Users on u.fk_UserID equals i.UserID where u.TicketID == TicketID select new { u.TicketDate, i.UserName, i.UserFamily, u.TicketMessage }).FirstOrDefault(); //lblDate.Text = "تاریخ: " + string.Format("{0:d}", n.TicketDate); lblDate.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "تاریخ:" + string.Format("{0:d}", n.TicketDate) : ((IdentifyCulture.cultureName().Contains("en")) ? "Date:" + string.Format("{0:d}", n.TicketDate) : ((IdentifyCulture.cultureName().Contains("ru")) ? "история:" + string.Format("{0:d}", n.TicketDate) : ((IdentifyCulture.cultureName().Contains("zh")) ? "历史:" + string.Format("{0:d}", n.TicketDate) : "تاریخ" + string.Format("{0:d}", n.TicketDate)))); lblUserName.Text = "نام کاربر: " + n.UserName + " " + n.UserFamily; lblUserName.Text = (IdentifyCulture.cultureName().Contains("fa")) ? "نام کاربر: " + n.UserName + " " + n.UserFamily : ((IdentifyCulture.cultureName().Contains("en")) ? "user name: " + n.UserName + " " + n.UserFamily : ((IdentifyCulture.cultureName().Contains("ru")) ? "имя пользователя: " + n.UserName + " " + n.UserFamily : ((IdentifyCulture.cultureName().Contains("zh")) ? "用户名: " + n.UserName + " " + n.UserFamily : "نام کاربر: " + n.UserName + " " + n.UserFamily))); lblText.Text = n.TicketMessage; rptAnswersBind(TicketID); } } }
public void rptPopularBlogsBind() { using (MashadCarpetEntities db = new MashadCarpetEntities()) { var n = (from u in db.Blogs.AsEnumerable() join aa in db.BlogGroups on u.fk_BlogGroupID equals aa.BlogGroupID where u.IsDelete == false orderby u.VisitCounts descending select new { aa.BlogGroupName, u.BlogImage, u.SubmitDate, //u.BlogTitle, BlogTitle = (IdentifyCulture.cultureName().Contains("fa")) ? u.BlogTitle : ((IdentifyCulture.cultureName().Contains("en")) ? u.EN_BlogTitle : ((IdentifyCulture.cultureName().Contains("ru")) ? u.Rus_BlogTitle : ((IdentifyCulture.cultureName().Contains("zh")) ? u.China_BlogTitle : u.BlogTitle))), u.BlogName }).ToList().Take(3); rptPopularBlogs.DataSource = n; rptPopularBlogs.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (IdentifyCulture.cultureName().Contains("fa")) { imgSh.ImageUrl = "~/images/Shoar.png"; } else { imgSh.ImageUrl = "~/images/Shor-Eng.png"; } rptUnitsBind(); FindMashadText(); rptAccordionBind(); rptService1Bind(); //rptService2Bind(); rpHonor1Bind(); rpHonor2Bind(); rptPortfolioBind(); rptSlideBind(); ChooseTitleAndDesc(); } }