protected void btnEdit_Click(object sender, EventArgs e)
{
btnSave.Text = "Cập nhật";
GridViewRow row = (GridViewRow)((LinkButton)sender).Parent.Parent;
var ID_find = Convert.ToInt32(row.Cells[0].Text);
Cls_ShopsProducts cls = Cls_ShopsProducts.getOject_Key_Not_Date(ID_find);
txtID_Product.Text = ID_find.ToString();
txtID_Catalog.SelectedValue = cls.ID_Catalog.ToString();
txtProductName.Text = cls.ProductName.ToString();
txtProductCode.Text = cls.ProductCode.ToString();
txtPriceOut.Text = cls.PriceOut.ToString();
txtColor.Text = cls.Color.ToString();
txtAmount.Text = cls.Amount.ToString();
txtWeight.Text = cls.Weight.ToString();
txtSummaryContent.Text = cls.SummaryContent.ToString();
txtTitleWeb.Text = cls.TitleWeb.ToString();
txtImage.Text = cls.Image.ToString();
txtDetail.Text = cls.Description.ToString();
txtLinkSEO.Text = cls.LinkSEO.ToString();
Console.WriteLine(cls.Hidden.ToString());
if (cls.Hidden == true)
{
cbHidden.Checked = true;
}
else
{
cbHidden.Checked = false;
}
popup.Show();
}
protected void ds_Selecting(object sender, ObjectDataSourceSelectingEventArgs e)
{
int id = Convert.ToInt32(Request["idProduct"].ToString());
int idCata = Convert.ToInt32(Cls_ShopsProducts.getOject_Key(Convert.ToInt16(Request["idProduct"])).ID_Catalog);
string sql = "SELECT TOP(6) *, tbShopsCatalogs.LinkSEO as linkSEOCatalog FROM tbShopsProducts, tbShopsCatalogs WHERE tbShopsCatalogs.ID_Catalog = tbShopsProducts.ID_Catalog and tbShopsProducts.Hidden = 1 and ID_Product <> " + id + " and tbShopsProducts.ID_Catalog = " + idCata;
e.InputParameters["sSQL"] = sql;
}
protected void grv_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int ID = Convert.ToInt32(grv.DataKeys[e.RowIndex].Values[0]);
Cls_ShopsProducts cls = new Cls_ShopsProducts();
cls.ID_Product_find = ID;
if (cls.doDelete() == 1)
{
string sMessages = "alert('Đã xóa thành công');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
else
{
string sMessages = "alert('Đã xảy ra lỗi trong quá trình xóa dữ liệu');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
BindData();
}
public DataTable getPrdSelecting(object idCata)
{
string sql = "SELECT *, tbShopsCatalogs.LinkSEO as linkSEOCatalog FROM tbShopsProducts, tbShopsCatalogs WHERE tbShopsCatalogs.ID_Catalog = tbShopsProducts.ID_Catalog and tbShopsProducts.Hidden = 1 and tbShopsProducts.ID_Catalog = " + idCata.ToString();
return(Cls_ShopsProducts.getDataTable_SQL_pro(sql));
}
private void BindData()
{
grv.DataSource = Cls_ShopsProducts.getDataTableJoinShopsCatalogs("tbShopsProducts.ID_Catalog = tbShopsCatalogs.ID_Catalog");
grv.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (btnSave.Text == "Lưu")
{
Cls_ShopsProducts cls = new Cls_ShopsProducts();
cls.ID_Catalog = Convert.ToInt32(txtID_Catalog.SelectedValue.ToString());
cls.ProductName = txtProductName.Text.Trim();
cls.ProductCode = txtProductCode.Text.Trim();
cls.Image = txtImage.Text.Trim();
cls.PriceOut = Convert.ToDouble(txtPriceOut.Text.Trim());
cls.Color = txtColor.Text.Trim();
cls.Amount = Convert.ToInt32(txtAmount.Text.Trim());
cls.Weight = Convert.ToDouble(txtWeight.Text.Trim());
cls.SummaryContent = txtSummaryContent.Text.Trim();
cls.Description = txtDetail.Text.Trim();
cls.TitleWeb = txtTitleWeb.Text.Trim();
cls.LinkSEO = txtLinkSEO.Text.Trim();
cls.H1SEO = txtProductName.Text.Trim();
cls.KeywordSEO = txtProductName.Text.Trim();
cls.AddTime = DateTime.Now;
cls.EditTime = DateTime.Now;
if (cbHidden.Checked)
{
cls.Hidden = true;
}
else
{
cls.Hidden = false;
}
if (cls.doInsert() == 1)
{
string sMessages = "alert('Đã thêm dữ liệu thành công!');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
else
{
string sMessages = "alert('Đã xảy ra lỗi trong quá trình thêm dữ liệu! Bạn vui lòng kiểm tra lại!');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
}
else if (btnSave.Text == "Cập nhật")
{
Cls_ShopsProducts cls = new Cls_ShopsProducts();
cls.ID_Product_find = Convert.ToInt32(txtID_Product.Text.Trim());
cls.ID_Catalog = Convert.ToInt32(txtID_Catalog.SelectedValue.ToString());
cls.ProductName = txtProductName.Text.Trim();
cls.ProductCode = txtProductCode.Text.Trim();
cls.Image = txtImage.Text.Trim();
cls.PriceOut = Convert.ToDouble(txtPriceOut.Text.Trim());
cls.Color = txtColor.Text.Trim();
cls.Amount = Convert.ToInt32(txtAmount.Text.Trim());
cls.Weight = Convert.ToDouble(txtWeight.Text.Trim());
cls.SummaryContent = txtSummaryContent.Text.Trim();
cls.Description = txtDetail.Text.Trim();
cls.TitleWeb = txtTitleWeb.Text.Trim();
cls.LinkSEO = txtLinkSEO.Text.Trim();
cls.H1SEO = txtProductName.Text.Trim();
cls.KeywordSEO = txtProductName.Text.Trim();
cls.EditTime = DateTime.Now;
if (cbHidden.Checked)
{
cls.Hidden = true;
}
else
{
cls.Hidden = false;
}
if (cls.doUpdate() == 1)
{
string sMessages = "alert('Đã chỉnh sửa dữ liệu thành công!');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
else
{
string sMessages = "alert('Đã xảy ra lỗi trong quá trình chỉnh sửa dữ liệu! Bạn vui lòng kiểm tra lại!');";
ScriptManager.RegisterStartupScript(UpdatePanel1, UpdatePanel1.GetType(), "", sMessages, true);
}
}
BindData();
}
protected void btnAddToCart_Click(object sender, EventArgs e)
{
RepeaterItem item = (sender as Button).NamingContainer as RepeaterItem;
int idPrd = Convert.ToInt16(((Button)sender).CommandArgument);
int quantity = Convert.ToInt32((item.FindControl("txtQuantity") as TextBox).Text);
if (Session["cart_items"] != null)
{
DataTable dt = (DataTable)Session["cart_items"];
DataTable dtProduct = Cls_ShopsProducts.getDataTable_Join_ShopsCatalogs(idPrd);
DataRow[] checkPrd = dt.Select("ID_Product = " + idPrd);
if (checkPrd.Length > 0)
{
DataRow dr = checkPrd[0];
dr["Quantity"] = Convert.ToInt32(dr["Quantity"]) + quantity;
dr["Total"] = Convert.ToInt32(dr["Quantity"]) * Convert.ToDouble(dtProduct.Rows[0]["PriceOut"]);
dt.AcceptChanges();
Session["cart_items"] = dt;
}
else
{
DataRow dr = dt.NewRow();
dr["ID_Product"] = idPrd;
dr["ProductName"] = Convert.ToString(dtProduct.Rows[0]["ProductName"]);
dr["Amount"] = Convert.ToString(dtProduct.Rows[0]["Amount"]);
dr["Quantity"] = quantity;
dr["PriceOut"] = Convert.ToString(dtProduct.Rows[0]["PriceOut"]);
dr["Total"] = Convert.ToInt32(dr["Quantity"]) * Convert.ToDouble(dtProduct.Rows[0]["PriceOut"]);
dr["LinkSEO"] = Convert.ToString(dtProduct.Rows[0]["LinkSEO"]);
dr["CatalogName"] = Convert.ToString(dtProduct.Rows[0]["CatalogName"]);
dr["linkSEOCatalog"] = Convert.ToString(dtProduct.Rows[0]["linkSEOCatalog"]);
dt.Rows.Add(dr);
dt.AcceptChanges();
Session["cart_items"] = dt;
}
}
else
{
DataTable dtProduct = Cls_ShopsProducts.getDataTable_Join_ShopsCatalogs(idPrd);
DataTable dt = new DataTable();
dt.Columns.Add("ID_Product", typeof(int));
dt.Columns.Add("ProductName", typeof(string));
dt.Columns.Add("Amount", typeof(int));
dt.Columns.Add("Quantity", typeof(int));
dt.Columns.Add("PriceOut", typeof(double));
dt.Columns.Add("Total", typeof(double));
dt.Columns.Add("LinkSEO", typeof(string));
dt.Columns.Add("CatalogName", typeof(string));
dt.Columns.Add("linkSEOCatalog", typeof(string));
DataRow dr = dt.NewRow();
dr["ID_Product"] = idPrd;
dr["ProductName"] = Convert.ToString(dtProduct.Rows[0]["ProductName"]);
dr["Amount"] = Convert.ToString(dtProduct.Rows[0]["Amount"]);
dr["Quantity"] = quantity;
dr["PriceOut"] = Convert.ToString(dtProduct.Rows[0]["PriceOut"]);
dr["Total"] = Convert.ToInt32(dr["Quantity"]) * Convert.ToDouble(dtProduct.Rows[0]["PriceOut"]);
dr["LinkSEO"] = Convert.ToString(dtProduct.Rows[0]["LinkSEO"]);
dr["CatalogName"] = Convert.ToString(dtProduct.Rows[0]["CatalogName"]);
dr["linkSEOCatalog"] = Convert.ToString(dtProduct.Rows[0]["linkSEOCatalog"]);
dt.Rows.Add(dr);
dt.AcceptChanges();
Session["cart_items"] = dt;
}
}
