//-----------------------------------------------------------------------------------------------------------//
//-----------------------------------------------------------------------------------------------------------//
//-----------------------------------------------------------------------------------------------------------//
//-----------------------------------------------------------------------------------------------------------//
//-----------------------------------------------------------------------------------------------------------//
void update_number_shop(decimal id_product, decimal count)
{
Product ac = new Product();
ProductDatum dm = new ProductDatum();
dm.Number_Shop = count;
dm.Id = id_product;
ac.Update_Number_Shop(dm);
}
//---------------------------------------Delete ---------------------------------------------------
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Product ac2 = new Product();
ProductDatum dm2 = new ProductDatum();
string id = ((Label)(GridView1.Rows[e.RowIndex].FindControl("Lblid"))).Text;
dm.Id = decimal.Parse(id);
dm2.Id_Group = dm.Id;
if (ac.SelectAll(dm).Rows.Count == 0 && ac2.Select_Product_Group_Node(dm2).Rows.Count == 0)
{
ac.Delete(dm);
Cancel();
FillGrid();
}
else
{
Label3.Visible = true;
}
}
void fillgrid()
{
Product ac = new Product();
ProductDatum dm = new ProductDatum();
dm.Title = TextBox1.Text;
dm.Id_State = decimal.Parse(DropDownList1.SelectedValue);
decimal price1 = 0;
decimal price2 = 999999999;
if (TextBox3.Text.Length > 0)
{
price1 = decimal.Parse(TextBox3.Text);
}
if (TextBox4.Text.Length > 0)
{
price2 = decimal.Parse(TextBox4.Text);
}
GridView1.DataSource = ac.Select_Product_Search(dm, price1, price2);
GridView1.DataBind();
}
//----------------------------------------------------------------------------------------------
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 FillPath()
{
lblPath.Text = "";
if (Request.QueryString["ID_Root"] != null && Request.QueryString["ID_Root"].Length > 0)
{
if (Request.QueryString["ID_Root"] != "-1")
{
dm.Id = int.Parse(Request.QueryString["ID_Root"]);
DataTable dt = ac.SelectOne(dm);
string delimitedInfo = dt.Rows[0]["Path"].ToString();
string[] discreteInfo = delimitedInfo.Split(new char[] { ',' });
string title = "";
DataTable dt2 = new DataTable();
foreach (string Data in discreteInfo)
{
if (Data == "-1")
{
title = "صفحه اصلی";
}
else
{
dm.Id = int.Parse(Data);
dt2 = ac.SelectOne(dm);
if (dt2.Rows.Count > 0)
{
title = dt2.Rows[0]["Title"].ToString();
}
}
lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=ProductCategory&ID_Root=" +
Data + "'>" + title + "</a>" + "<img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=ProductCategory&ID_Root=" +
dt.Rows[0]["ID"].ToString() + "'>" + dt.Rows[0]["Title"].ToString() + "</a>" + "<img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
else
{
lblPath.Text = lblPath.Text + "<a href='./index.aspx'>صفحه اصلی</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
}
else
{
lblPath.Text = lblPath.Text + "<a href='./index.aspx'>صفحه اصلی</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
if (Request.QueryString["ID_Product"] != null)
{
Product ac3 = new Product();
ProductDatum dm3 = new ProductDatum();
dm3.Id = decimal.Parse(Request.QueryString["ID_Product"]);
DataTable dt3 = ac3.Select_Product_One(dm3);
if (dt3.Rows.Count > 0)
{
lblPath.Text = lblPath.Text + "<a href='./index.aspx?ID_Product=" + Request.QueryString["ID_Product"] +
"&ID_Root=" + dt3.Rows[0]["id_group"].ToString() + "'>" + dt3.Rows[0]["Title"].ToString() + "</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
else
{
Response.Redirect("~/index.aspx?Type=404");
}
}
if (Request.QueryString["ID_Page"] != null)
{
Page_Manage ac4 = new Page_Manage();
Page_ManageDatum dm4 = new Page_ManageDatum();
dm4.Id = decimal.Parse(Request.QueryString["ID_Page"]);
DataTable dt4 = ac4.Select_page_One(dm4);
if (dt4.Rows.Count > 0)
{
lblPath.Text = lblPath.Text + "<a href='./index.aspx?Type=PageArchive'>آرشیو صفحات</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>" +
"<a href='./index.aspx?ID_Page=" + Request.QueryString["ID_Page"] +
"'>" + dt4.Rows[0]["Title"].ToString() + "</a><img src='./Administrator/files/Design/arrow_rtl.png' class='PathArrow'/>";
}
else
{
Response.Redirect("~/index.aspx?Type=404");
}
}
}
