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