private void Fill()
{
if (Request.QueryString["ID_Product"] != null)
{
dm.Id = decimal.Parse(Request.QueryString["ID_Product"].ToString());
}
DataTable dt = ac.Select_Product_One(dm);
TextTitle.Text = dt.Rows[0]["title"].ToString();
FCKeditor2.Value = dt.Rows[0]["text_short"].ToString();
FCKeditor1.Value = dt.Rows[0]["text_long"].ToString();
TextBox4.Text = dt.Rows[0]["price"].ToString();
TextBox3.Text = dt.Rows[0]["post_price"].ToString();
TextBox5.Text = dt.Rows[0]["weight"].ToString();
TextBox6.Text = dt.Rows[0]["rate"].ToString();
TextBox1.Text = dt.Rows[0]["MetaKeyword"].ToString();
TextBox2.Text = dt.Rows[0]["MetaDescription"].ToString();
DropDownList1.SelectedIndex = -1;
DropDownListVaziat.Items.FindByValue(dt.Rows[0]["id_State"].ToString()).Selected = true;
TextBox8.Text = dt.Rows[0]["catalug"].ToString();
TextBox7.Text = dt.Rows[0]["demo"].ToString();
FileUpload1.ToolTip = dt.Rows[0]["pic"].ToString();
Image1.ImageUrl = dt.Rows[0]["pic"].ToString();
Product_Grouping ac2 = new Product_Grouping();
Product_GroupingDatum dm2 = new Product_GroupingDatum();
dm2.Id = decimal.Parse(dt.Rows[0]["ID_Group"].ToString());
DataTable dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
string delimitedInfo = dt2.Rows[0]["Path"].ToString();
string[] discreteInfo = delimitedInfo.Split(new char[] { ',' });
int i = 1;
foreach (string Data in discreteInfo)
{
if (Data == "-1")
{
FillDr(int.Parse(Data), (DropDownList)FindControl("DropDownList" + i.ToString()));
}
else
{
((DropDownList)(FindControl("DropDownList" + (i - 1).ToString()))).Items.FindByValue(Data).Selected = true;
FillDr(int.Parse(Data), (DropDownList)FindControl("DropDownList" + i.ToString()));
}
i++;
}
((DropDownList)(FindControl("DropDownList" + (i - 1).ToString()))).Items.FindByValue(dt.Rows[0]["ID_Group"].ToString()).Selected = true;
}
}
private void FillDr(int ID_Category, DropDownList Dr)
{
string DR_ID = Dr.ID.Substring(Dr.ID.Length - 1, 1);
Dr.Items.Clear();
Dr.DataValueField = "ID";
Dr.DataTextField = "Title";
Dr.Items.Add("همه");
Dr.Items[0].Value = "0";
Product_Grouping bl = new Product_Grouping();
Product_GroupingDatum dm2 = new Product_GroupingDatum();
dm2.Id = ID_Category;
Dr.DataSource = bl.SelectAll(dm2);
Dr.DataBind();
Dr.Visible = true;
}
//----------------------------------------------------------------------------------------------
protected void LinkButton1_Click(object sender, EventArgs e)
{
StreamWriter asw = new StreamWriter(Server.MapPath("~//administrator//files//Web.sitemap"), false, System.Text.Encoding.UTF8);
asw.Write("");
asw.Close();
string p = "";
string title = "";
string desc = "";
int i = 0;
OneRecord ac2 = new OneRecord();
OneRecordDatum dm2 = new OneRecordDatum();
DataTable dt2;
dm2.Type = "MetaTagTitle";
dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
title = dt2.Rows[0]["text"].ToString();
}
dm2.Type = "MetaTagDescription";
dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
desc = dt2.Rows[0]["text"].ToString();
}
p += "<?xml version='1.0' encoding='utf-8' ?>" +
"<siteMap xmlns='http://schemas.microsoft.com/AspNet/SiteMap-File-1.0' >";
p += "<siteMapNode url='~/index.aspx' title='" + title + "' description='" + desc + "' >";
//-----------------
title = "ثبت نام سایت";
desc = "در این بخش می توانید با ثبت نام در سایت از امکانات بیشتری بهره مند گردید";
p += "<siteMapNode url='~/index.aspx?Type=UserRegister' title='" + title + "' description='" + desc + "' />";
title = "جستجو پیشرفته";
desc = "در این بخش می توانید با امکانات بیشتری به جستجوی محصول مورد نظر خود بپردازید";
p += "<siteMapNode url='~/index.aspx?Type=Search' title='" + title + "' description='" + desc + "' />";
title = "نقشه سایت";
desc = "در این بخش می توانید با نقشه سایت و امکانات سایت را دسته بندی شده مشاهده نمایید";
p += "<siteMapNode url='~/index.aspx?Type=SiteMap' title='" + title + "' description='" + desc + "' />";
//----------------
Page_Manage ac = new Page_Manage();
Page_ManageDatum dm = new Page_ManageDatum();
dm.Place = "Down";
DataTable dt = ac.Select_User(dm);
for (i = 0; i < dt.Rows.Count; i++)
{
title = dt.Rows[i]["title"].ToString();
desc = dt.Rows[i]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Page=" + dt.Rows[i]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
//---------------
title = "آرشیو صفحات";
desc = "در این بخش می توانید با آرشیو صفحات ثبت شده را مشاهده نمایید";
p += "<siteMapNode url='~/index.aspx?Type=PageArchive' title='" + title + "' description='" + desc + "' >";
dm.Place = "Right";
dt = ac.Select_User(dm);
for (i = 0; i < dt.Rows.Count; i++)
{
title = dt.Rows[i]["title"].ToString();
desc = dt.Rows[i]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Page=" + dt.Rows[i]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
//---------------
Product_Grouping ac3 = new Product_Grouping();
Product_GroupingDatum dm3 = new Product_GroupingDatum();
dm3.Id = -1;
int i2 = 0;
int i3 = 0;
int i4 = 0;
int i5 = 0;
int i6 = 0;
DataTable dt3;
DataTable dt4;
DataTable dt5;
DataTable dt6;
DataTable dtp;
Product acp = new Product();
ProductDatum dmp = new ProductDatum();
int j = 0;
dt = ac3.SelectAll(dm3);
for (i = 0; i < dt.Rows.Count; i++)
{
title = dt.Rows[i]["Title"].ToString();
desc = dt.Rows[i]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt.Rows[i]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dm3.Id = int.Parse(dt.Rows[i]["id"].ToString());
dt2 = ac3.SelectAll(dm3);
for (i2 = 0; i2 < dt2.Rows.Count; i2++)
{
title = dt2.Rows[i2]["Title"].ToString();
desc = dt2.Rows[i2]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt2.Rows[i2]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dm3.Id = int.Parse(dt2.Rows[i2]["id"].ToString());
dt3 = ac3.SelectAll(dm3);
for (i3 = 0; i3 < dt3.Rows.Count; i3++)
{
title = dt3.Rows[i3]["Title"].ToString();
desc = dt3.Rows[i3]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt3.Rows[i3]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dm3.Id = int.Parse(dt3.Rows[i3]["id"].ToString());
dt4 = ac3.SelectAll(dm3);
for (i4 = 0; i4 < dt4.Rows.Count; i4++)
{
title = dt4.Rows[i4]["Title"].ToString();
desc = dt4.Rows[i4]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt4.Rows[i4]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dm3.Id = int.Parse(dt4.Rows[i4]["id"].ToString());
dt5 = ac3.SelectAll(dm3);
for (i5 = 0; i5 < dt5.Rows.Count; i5++)
{
title = dt5.Rows[i5]["Title"].ToString();
desc = dt5.Rows[i5]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt5.Rows[i5]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dm3.Id = int.Parse(dt5.Rows[i5]["id"].ToString());
dt6 = ac3.SelectAll(dm3);
for (i6 = 0; i6 < dt6.Rows.Count; i6++)
{
title = dt6.Rows[i6]["Title"].ToString();
desc = dt6.Rows[i6]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Root=" + dt6.Rows[i6]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' >";
dmp.Id_Group = int.Parse(dt6.Rows[i6]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
dmp.Id_Group = int.Parse(dt5.Rows[i5]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
dmp.Id_Group = int.Parse(dt4.Rows[i4]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
dmp.Id_Group = int.Parse(dt3.Rows[i3]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
dmp.Id_Group = int.Parse(dt2.Rows[i2]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
dmp.Id_Group = int.Parse(dt.Rows[i]["id"].ToString());
dtp = acp.Select_Product_Group_Node_SiteMap(dmp);
for (j = 0; j < dtp.Rows.Count; j++)
{
title = dtp.Rows[j]["Title"].ToString();
desc = dtp.Rows[j]["MetaDescription"].ToString();
p += "<siteMapNode url='~/index.aspx?ID_Product=" + dtp.Rows[j]["id"].ToString() + "' title='" + title +
"' description='" + desc + "' />";
}
p += "</siteMapNode>";
}
//---------------
p += "</siteMapNode></siteMap>";
File.AppendAllText(Server.MapPath("~//administrator//files//Web.sitemap"), p, System.Text.Encoding.UTF8);
Response.Redirect("index.aspx");
}
private void FillMeta()
{
Product_Grouping acg = new Product_Grouping();
Product_GroupingDatum dmg = new Product_GroupingDatum();
bool Home = false;
if (Request.QueryString["ID_Root"] != null)
{
if (Request.QueryString["ID_Root"] != "-1")
{
dmg.Id = decimal.Parse(Request.QueryString["ID_Root"]);
DataTable dt = acg.SelectOne(dmg);
if (dt.Rows.Count > 0)
{
SetMetaTags("گروه " + dt.Rows[0]["title"].ToString(),
dt.Rows[0]["MetaDescription"].ToString(),
dt.Rows[0]["MetaKeyword"].ToString());
}
else
{
Home = true;
}
}
else
{
Home = true;
}
}
else
{
Home = true;
}
if (Home)
{
OneRecord ac2 = new OneRecord();
OneRecordDatum dm2 = new OneRecordDatum();
string title = "فروشگاه اینترنتی فراجهش شمال";
string key = "";
string desc = "";
DataTable dt2;
dm2.Type = "MetaTagTitle";
dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
title = dt2.Rows[0]["text"].ToString();
}
dm2.Type = "MetaTagKeyword";
dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
key = dt2.Rows[0]["text"].ToString();
}
dm2.Type = "MetaTagDescription";
dt2 = ac2.SelectOne(dm2);
if (dt2.Rows.Count > 0)
{
desc = dt2.Rows[0]["text"].ToString();
}
SetMetaTags(title, desc, key);
}
}
