private void LoadData(string Id)
{
try
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(Convert.ToInt32(Id));
if (ds.Tables[0].Rows.Count > 0)
{
txtTenCuaHang.Text = ds.Tables[0].Rows[0]["TenCuaHang"].ToString();
if (ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() != "")
{
ddlLoaiGianHang.SelectedValue = ds.Tables[0].Rows[0]["LoaiCuaHangID"].ToString();
}
else
{
ddlLoaiGianHang.SelectedIndex = 0;
}
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void LoadGianHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectCuaHangAtViTriCuaHang(1);
int n = ds.Tables[0].Rows.Count;
for (int j = 0; j < 4; j++)
{
TableRow tr = new TableRow();
for (int i = 0; i < 4; i++)
{
TableCell td = new TableCell();
string content = "";
if (j*4 + i < n)
{
content += "<table width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">";
content += "<tr><td><a href=\"estore.aspx?sid=" + ds.Tables[0].Rows[j*4 + i]["CuaHangID"]
+ "\"><img src=\"" + ds.Tables[0].Rows[j*4 + i]["Anh"]
+ "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>";
content += "<td><a href=\"estore.aspx?sid=" + ds.Tables[0].Rows[j*4 + i]["CuaHangID"]
+ "\"><b>" + ds.Tables[0].Rows[j*4 + i]["TenCuaHang"] + "</b></a></td></tr></table>";
}
td.Text = content;
td.HorizontalAlign = HorizontalAlign.Left;
if (j == 0) td.Width = Unit.Percentage(25);
tr.Cells.Add(td);
}
tblGianHang.Rows.Add(tr);
}
}
private bool CheckExistCuaHang(int id)
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(id);
if (ds.Tables[0].Rows.Count > 0)
return true;
return false;
}
protected void btnSave_Click(object sender, EventArgs e)
{
CuaHang ch = new CuaHang();
string path = Server.MapPath("../Upload/StoreImages");
string randomString = "";
string relativePath = "";
if (fileStore.PostedFile.FileName != "")
{
try
{
if (fileStore.PostedFile.ContentLength <= 300000)
{
int pos = fileStore.PostedFile.FileName.LastIndexOf('\\');
string absolutePath = path + "\\" + fileStore.PostedFile.FileName.Remove(0, pos + 1);
if (File.Exists(absolutePath))
{
randomString = DateTime.Now.Ticks + "_";
absolutePath = path + "\\" + randomString + fileStore.PostedFile.FileName.Remove(0, pos + 1);
}
//fileStore.PostedFile.SaveAs(absolutePath);
Common.ResizeFromStream(absolutePath, 320, fileStore.PostedFile.InputStream);
//File.Delete(Server.MapPath(imgAnhQuangCao.Src));
relativePath = "./Upload/StoreImages/" + randomString +
fileStore.PostedFile.FileName.Remove(0, pos + 1);
}
else
{
Response.Redirect("../message.aspx?msg=File size is too big!");
return;
}
}
catch (Exception ex)
{
Response.Redirect("../message.aspx?msg=" + ex.Message);
return;
}
}
if (relativePath != "")
{
ch.UpdateFields(sid, txtTen.Text, txtGioiThieu.Text, null, txtEmail.Text, relativePath, txtDiDong.Text,
txtCoDinh.Text,
txtLienHe.Text, txtDiaChi.Text, txtWebSite.Text, txtFax.Text, txtYahoo.Text, null, null,
null, null, null, null,
null, null, null, null, null, null, null, null);
}
else
{
ch.UpdateFields(sid, txtTen.Text, txtGioiThieu.Text, null, txtEmail.Text, null, txtDiDong.Text,
txtCoDinh.Text,
txtLienHe.Text, txtDiaChi.Text, txtWebSite.Text, txtFax.Text, txtYahoo.Text, null, null,
null, null, null,
null, null, null, null, null, null, null, null, null);
}
string strScript = "<script language='JavaScript'>" + "window.parent.RefreshStoreInfo();</script>";
ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript);
}
private void LoadHoTro()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID());
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("../message.aspx?msg=You haven't got a store yet");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
lblTenCuaHang.Text = dr["TenCuaHang"].ToString();
lblCoDinh.Text = dr["DienThoaiCoDinh"].ToString();
lblDiDong.Text = dr["DienThoaiDiDong"].ToString();
CuaHangID = int.Parse(dr["CuaHangID"].ToString());
}
}
// Tạo cửa hàng
protected void pnlUser_ContentRefresh(object sender, EventArgs e)
{
try
{
CuaHang cuahang = new CuaHang();
if (CheckExistCuaHang(int.Parse(hidID.Value)) != true)
{
cuahang.InsertFields(null, null, int.Parse(hidID.Value), null, null, null, null,
null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, 3);
}
LoadGridData();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
CuaHang ch = new CuaHang();
ch.UpdateFields(int.Parse(Request.QueryString["sid"]),
null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null,
short.Parse(ddlBaoDam.SelectedValue),null, short.Parse(ddlLoaiGianHang.SelectedValue));
string strScript = "<script language='JavaScript'>" + "window.parent.Refresh();</script>";
ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void LoadCuaHang(int CuaHangID)
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(CuaHangID);
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("./message.aspx?msg=Failed in loading store");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
string content = "";
content += "Gian Hàng: " + dr["TenCuaHang"] + "<br/>";
content += "Địa chỉ liên hệ: " + dr["DiaChi"] + "<br/>";
content += "Điện thoại: " + dr["DienThoaiCoDinh"] + " - " +
dr["DienThoaiDiDong"];
content += "Email: " + dr["Email"];
ViewState["email"] = dr["Email"].ToString();
divGianHang.InnerHtml = content;
//content += int.Parse(dr["NguoiDungID"].ToString());
//switch (dr["LoaiCuaHang"].ToString())
//{
// case "1":
// stsGianHang.Href = "GianHang/VIP/css/style.css";
// LoadTinTuc();
// break;
// case "2":
// stsGianHang.Href = "GianHang/CN/css/style.css";
// LoadTinTuc();
// break;
// case "3":
// stsGianHang.Href = "GianHang/TT/css/style.css";
// break;
//}
//if ((dr["LoaiCuaHang"].ToString() == "1") ||
// (dr["LoaiCuaHang"].ToString() == "2"))
//{
// LoadTinTuc();
//}
}
}
private void LoadCuaHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(CuaHangID);
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("./message.aspx?msg=Failed in loading store");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
lblTenCuaHang.Text = "<a href=\"estore.aspx?sid=" + dr["CuaHangID"] + "\">" + dr["TenCuaHang"] + "</a>";
lblGioiThieu.Text = dr["GioiThieu"].ToString();
lblDiaChi.Text = dr["DiaChi"].ToString();
lblEmail.Text = dr["Email"].ToString();
lblCoDinh.Text = dr["DienThoaiCoDinh"].ToString();
lblDiDong.Text = dr["DienThoaiDiDong"].ToString();
lblFax.Text = dr["Fax"].ToString();
lblBack.Text = "<a href=\"estore.aspx?sid=" + dr["CuaHangID"] +
"\"><span style=\"color:blue;text-decoration:underline;\">QUAY LẠI TRANG TRƯỚC</span></a>";
}
}
private int LoadCuaHang(int ViTriCuaHang, int KhuVucID)
{
if (Common.LoaiNguoiDungID() == 3)
{
//For administrator
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectAllCuaHangAtViTriCuaHang(ViTriCuaHang);
ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String"));
ds.Tables[0].Columns["Selected"].DefaultValue = "false";
DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID);
for (int i = 0; i < selectedRows.Length; i++)
{
selectedRows[i]["Selected"] = "true";
}
grdStore.DataSource = ds;
grdStore.DataBind();
return selectedRows.Length;
}
else if (Common.LoaiNguoiDungID() == 2)
{
//For e-store manager
QuangCao qcao = new QuangCao();
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectAllCuaHangAtViTriCuaHangByNguoiDungID(Common.NguoiDungID(), ViTriCuaHang);
ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String"));
ds.Tables[0].Columns["Selected"].DefaultValue = "false";
DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID);
for (int i = 0; i < selectedRows.Length; i++)
{
selectedRows[i]["Selected"] = "true";
}
grdStore.DataSource = ds;
grdStore.DataBind();
return selectedRows.Length;
}
return 0;
}
private void LoadCuaHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(CuaHangID);
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("./message.aspx?msg=Failed in loading store");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
//lblTenCuaHang.Text = dr["TenCuaHang"].ToString();
//lblDiaChi.Text = dr["DiaChi"].ToString();
//lblDTCD.Text = dr["DienThoaiCoDinh"].ToString();
//lblDTDD.Text = dr["DienThoaiDiDong"].ToString();
ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString());
//imgLoGo.Src = dr["Anh"].ToString();
//switch (dr["LoaiCuaHang"].ToString())
//{
// case "1":
// stsGianHang.Href = "GianHang/VIP/css/style.css";
// //LoadTinTuc();
// break;
// case "2":
// stsGianHang.Href = "GianHang/CN/css/style.css";
// //LoadTinTuc();
// break;
// case "3":
// stsGianHang.Href = "GianHang/TT/css/style.css";
// break;
// default:
// stsGianHang.Href = "GianHang/TT/css/style.css";
// break;
//}
//if ((dr["LoaiCuaHang"].ToString() == "1") ||
// (dr["LoaiCuaHang"].ToString() == "2"))
//{
// LoadTinTuc();
//}
}
}
private void LoadCuaHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(CuaHangID);
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("./message.aspx?msg=Failed in loading store");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString());
}
}
private void LoadCuaHang()
{
if (Session["UserFullName"] != null)
{
tblchaomung.Visible = true;
divDangNhap.Visible = false;
}
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByCuaHangID(CuaHangID);
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("./message.aspx?msg=Failed in loading store");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
lblLienHe.Text = dr["TenCuaHang"].ToString() + " "
+ dr["DiaChi"].ToString() + " - " + dr["DienThoaiCoDinh"].ToString()
+ " - " + dr["DienThoaiDiDong"].ToString();
ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString());
ViewState["chucuahangid"] = ChuCuaHangID;
LoaiGianHangID = dr["LoaiCuaHangID"].ToString();
//switch (dr["LoaiCuaHangID"].ToString())
//{
// //case "1":
// // stsGianHang.Href = "GianHang/VIP/css/style.css";
// // //LoadTinTuc();
// // break;
// case "2":
// stsGianHang.Href = "GianHang/CN/css/style.css";
// //LoadTinTuc();
// break;
// case "3":
// stsGianHang.Href = "GianHang/TT/css/style.css";
// break;
// default:
// stsGianHang.Href = "GianHang/" + dr["TenLoaiCuaHang"].ToString() + "/css/style.css";
// break;
//}
//if ((dr["LoaiCuaHang"].ToString() == "1") ||
// (dr["LoaiCuaHang"].ToString() == "2"))
//{
// //LoadTinTuc();
//}
}
}
private void LoadCuaHang(int sid)
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(sid);
if (ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
txtTen.Text = dr["TenCuaHang"].ToString();
txtDiaChi.Text = dr["DiaChi"].ToString();
txtCoDinh.Text = dr["DienThoaiCoDinh"].ToString();
txtDiDong.Text = dr["DienThoaiDiDong"].ToString();
txtFax.Text = dr["Fax"].ToString();
txtEmail.Text = dr["Email"].ToString();
;
txtWebSite.Text = dr["WebSite"].ToString();
txtYahoo.Text = dr["YM"].ToString();
txtLienHe.Text = dr["ThongTinLienHe"].ToString();
txtGioiThieu.Text = dr["GioiThieu"].ToString();
imgStore.ImageUrl = "." + dr["Anh"];
}
else
{
Response.Redirect("../message.aspx?msg=Invalid parameter");
}
}
void Page_PreInit(Object sender, EventArgs e)
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByCuaHangID(int.Parse(Request["sid"]));
if ((ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0]["LoaiCuaHangID"].ToString() == "26"))
{
//ContentPlaceHolderID = "contentEstore";
this.MasterPageFile = "NewEstoreMaster.master";
}
if (Session["masterpage"] != null)
{
this.MasterPageFile = (String)Session["masterpage"];
}
}
//protected void grdSanPham_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)
//{
// e.Layout.Grid.Columns.FromKey("Command").AllowRowFiltering = false;
// e.Layout.Grid.Columns.FromKey("TenSanPham").FilterOperatorDefaultValue = FilterComparisionOperator.Contains;
// e.Layout.Grid.Columns.FromKey("Dates").FilterOperatorDefaultValue = FilterComparisionOperator.Contains;
// e.Layout.Grid.Columns.FromKey("TenNhomSanPham").FilterOperatorDefaultValue = FilterComparisionOperator.Contains;
// //if (rbtTatCa.Checked == true)
// //{
// // e.Layout.Pager.AllowPaging = false;
// //}
// //else
// //{
// // e.Layout.Pager.AllowPaging = true;
// //}
//}
//protected void rbtPhanTrang_CheckedChanged(object sender, EventArgs e)
//{
// LoadData();
//}
//protected void rbtTatCa_CheckedChanged(object sender, EventArgs e)
//{
// LoadData();
//}
private void LoadGianHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectAll();
ddlGianHang.DataSource = ds.Tables[0];
ddlGianHang.DataTextField = "TenCuaHang";
ddlGianHang.DataValueField = "CuaHangID";
ddlGianHang.DataBind();
ddlGianHang.Items.Insert(0, "Tất cả gian hàng");
ddlGianHang.SelectedIndex = 0;
}
private void RedirectToCuahangbyUrlName()
{
string url = Request.RawUrl.ToLower();
if (url.IndexOf("estore.aspx") == -1)
{
string[] urls = url.Split('/');
string tencuahang = urls[urls.Length - 1];
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByField("TenCuaHang", tencuahang, "nvarchar");
if (ds.Tables[0].Rows.Count > 0)
{
Response.Redirect("Estore.aspx?sid=" + ds.Tables[0].Rows[0]["CuaHangID"]);
}
}
}
private void LoadSanPhamTheoMau(int spmid)
{
try
{
SanPhamMau spm = new SanPhamMau();
DataSet ds = spm.SelectByID(spmid);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
int NhomSanPhamID = int.Parse(dr["NhomSanPhamID"].ToString());
CuaHang ch = new CuaHang();
DataSet dsch = ch.SelectByNguoiDungID(Common.NguoiDungID());
int CuaHangID = int.Parse(dsch.Tables[0].Rows[0]["CuaHangID"].ToString());
if (checkNhomSanPham(NhomSanPhamID, CuaHangID) == false)
{
AddNhomSanPhamToCuaHang(NhomSanPhamID, CuaHangID);
ddlNhomSanPham.Items.Clear();
LoadDanhMucConForDropDown(0, CuaHangID, 0);
ddlNhomSanPham.SelectedValue = NhomSanPhamID.ToString();
}
ddlNhomSanPham.SelectedValue = dr["NhomSanPhamID"].ToString();
txtTenSanPham.Text = dr["TenSanPham"].ToString();
//txtMaSoSanPham.Text = dr["MaSoSanPham"].ToString();
txtGiaSanPham.Text = dr["GiaSanPham"].ToString();
ddlHangSanXuat.SelectedValue = dr["HangSanXuatID"].ToString();
ddlKhuVuc.SelectedValue = dr["KhuVucID"].ToString();
chkKhuyenMai.Checked = dr["KhuyenMai"].ToString() != "" ? bool.Parse(dr["KhuyenMai"].ToString()) : false;
chkGiamGia.Checked = dr["GiamGia"].ToString() != "" ? bool.Parse(dr["GiamGia"].ToString()) : false;
//txtMoTaSanPham.Text = dr["MoTaSanPham"].ToString();
wheMoTaSanPham.Text = dr["MoTaSanPham"].ToString();
imgAnhChinh.ImageUrl = "." + dr["AnhSanPham"];
wheThongTinSanPham.Text = dr["ThongTinSanPham"].ToString();
hidAnhChinh.Value = dr["AnhSanPham"].ToString();
if (chkGiamGia.Checked)
{
cvGiaMoi.Enabled = true;
txtGiaMoi.Enabled = true;
txtGiaMoi.Text = dr["GiaKhuyenMai"].ToString();
}
else
{
txtGiaMoi.Enabled = false;
}
//txtDonViTienTe.Text = dr["DonViTienTe"].ToString();
//txtThongTinSanPham.Text = dr["ThongTinSanPham"].ToString();
LoadAnhPhuTheoMau(spmid);
LoadThuocTinhCha();
LoadThuocTinh();
if (chkKhuyenMai.Checked)
{
wdcBatDauKM.Enabled = true;
wdcBatDauKM.Value = DateTime.Parse(dr["BatDauKhuyenMai"].ToString());
wdcKetThucKM.Enabled = true;
wdcKetThucKM.Value = DateTime.Parse(dr["KetThucKhuyenMai"].ToString());
txtMoTaKhuyenMai.Enabled = true;
txtMoTaKhuyenMai.Text = dr["MoTaKhuyenMai"].ToString();
cvKhuyenMai.Enabled = true;
}
else
{
txtMoTaKhuyenMai.Enabled = false;
wdcBatDauKM.Enabled = false;
wdcKetThucKM.Enabled = false;
}
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void LoadCuaHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID());
if (ds.Tables[0].Rows.Count != 1)
{
Response.Redirect("../message.aspx?msg=You haven't got a store yet");
}
else
{
DataRow dr = ds.Tables[0].Rows[0];
//lblTenCuaHang.Text = dr["TenCuaHang"].ToString();
CuaHangID = int.Parse(dr["CuaHangID"].ToString());
imgLogo.Src = "." + dr["Anh"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (Common.LoaiNguoiDungID() == 2)
{
LoadCuaHang();
}
lbluser.Text = Page.User.Identity.Name;
if (Common.LoaiNguoiDungID() == 3)
{
//Administrator
mnuChoNet.Items[0].Hidden = false;
mnuChoNet.Items[7].Hidden = false;
//mnuChoNet.Items[1].Hidden = true;
//mnuChoNet.Items[7].Hidden = true;
mnuChoNet.Items[2].Items[1].Hidden = false;
//mnuChoNet.Items[2].Items[2].Hidden = false;
mnuChoNet.Items[2].Items[3].Hidden = false;
mnuChoNet.Items[6].Items[0].Hidden = false;
mnuChoNet.Items[6].Items[1].Hidden = false;
mnuChoNet.Items[6].Items[2].Hidden = true;
mnuChoNet.Items[6].Items[3].Hidden = false;
mnuChoNet.Items[6].Items[4].Hidden = true;
mnuChoNet.Items[6].Items[5].Hidden = true;
mnuChoNet.Items[6].Items[6].Hidden = true;
}
else if (Common.LoaiNguoiDungID() == 2)
{
//e-Store
mnuChoNet.Items[0].Hidden = true;
//mnuChoNet.Items[8].Hidden = true;
//mnuChoNet.Items[1].Hidden = false;
mnuChoNet.Items[7].Hidden = true;
mnuChoNet.Items[2].Items[1].Hidden = true;
//mnuChoNet.Items[2].Items[2].Hidden = true;
mnuChoNet.Items[2].Items[3].Hidden = true;
mnuChoNet.Items[6].Items[0].Hidden = true;
mnuChoNet.Items[6].Items[1].Hidden = true;
mnuChoNet.Items[6].Items[2].Hidden = true;
mnuChoNet.Items[6].Items[3].Hidden = true;
mnuChoNet.Items[6].Items[4].Hidden = false;
mnuChoNet.Items[6].Items[5].Hidden = false;
mnuChoNet.Items[6].Items[6].Hidden = false;
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID());
if ((ds.Tables[0].Rows.Count > 0) &&
((ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() == "1") ||
(ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() == "2")))
{
mnuChoNet.Items[3].Hidden = false;
}
else
{
mnuChoNet.Items[3].Hidden = true;
}
lblTenCongTy.Text = "<b>CÔNG TY TNHH TM quảng cáo trực tuyến CN</b><br/>TEL: 09808080808";
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
}
}
private void LoadCuaHang()
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByID(sid);
if (ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
imgStore.ImageUrl = "." + dr["Anh"];
}
else
{
Response.Redirect("../message.aspx?msg=Invalid parameter");
}
}
private string GetThongTinCuaHang(int NguoiDungID, out int chid, out string tench)
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(NguoiDungID);
string strThongTin = "";
chid = 0;
tench = "";
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
chid = int.Parse(dr["CuaHangID"].ToString());
tench = dr["TenCuaHang"].ToString();
strThongTin = "<p><b>Giỏ hàng của bạn tại công ty: <a class=pathway href='EStore.aspx?sid=" +
dr["CuaHangID"] + "'>" + dr["TenCuaHang"] + "</a><br>";
strThongTin += "Liên hệ theo số điện thoại: " + dr["DienThoaiCoDinh"] + ", " + dr["DienThoaiDiDong"] +
" </b></p>";
}
return strThongTin;
}
//loai cua hang = 1 -> VIP
//loai cua hang = 2 -> Chuyên nghiệp
//loai cua hang = 0 -> Binh Thuong
private void LoadGianHang(int LoaiCuaHang, int CurrentPage)
{
tblGianHang.Rows.Clear();
int RowStart = (CurrentPage - 1)*PageSize + 1;
CuaHang ch = new CuaHang();
DataSet ds = new DataSet();
int NhomSanPhamID = 0;
if (Request.QueryString["cid"] != null)
NhomSanPhamID = int.Parse(Request.QueryString["cid"]);
if (LoaiCuaHang != 0)
{
ds = ch.SelectCuaHangInLoaiCuaHangNhomSanPhamIDPaging(txtKeySearch.Text, LoaiCuaHang, NhomSanPhamID,
RowStart, PageSize);
}
else
{
if (NhomSanPhamID == 0)
ds = ch.SelectAllCuaHangPaging(txtKeySearch.Text, RowStart, PageSize);
else
ds = ch.SelectAllCuaHangByNhomSanPhamIDPaging(NhomSanPhamID, txtKeySearch.Text, RowStart, PageSize);
}
int n = ds.Tables[0].Rows.Count;
for (int j = 0; j < 10; j++)
{
TableRow tr = new TableRow();
for (int i = 0; i < 2; i++)
{
TableCell td = new TableCell();
string content = "";
if (j*2 + i < n)
{
DataRow dr = ds.Tables[0].Rows[j * 2 + i];
content += "<table width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">";
if (dr["LoaiCuaHangID"].ToString() == "26")
{
content += "<tr><td style=\"widht:110px\"><a href=\"Newestore.aspx?sid=" +
dr["CuaHangID"]
+ "\"><img src=\"" + dr["Anh"]
+ "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>";
content += "<td style=\"width:80%\"><a href=\"Newestore.aspx?sid=" +
dr["CuaHangID"]
+ "\"><b>" + dr["TenCuaHang"] + "</b><br> Đánh giá: ";
}
else
{
content += "<tr><td style=\"widht:110px\"><a href=\"estore.aspx?sid=" +
dr["CuaHangID"]
+ "\"><img src=\"" + dr["Anh"]
+ "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>";
content += "<td style=\"width:80%\"><a href=\"estore.aspx?sid=" +
dr["CuaHangID"]
+ "\"><b>" + dr["TenCuaHang"] + "</b><br> Đánh giá: ";
}
int sodiem = (int) decimal.Parse("0" + dr["diem"]);
for (int m = 0; m < sodiem; m++)
{
content += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star1.gif\">";
}
for (int m = 10; m > sodiem; m--)
{
content += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star0.gif\">";
}
content += string.Format("{0:0.0}", decimal.Parse("0" + dr["diem"]));
if (dr["LoaiCuaHang"].ToString() == "1")
{
content +=
"<br><img border=0 src=\"./images/store2.jpg\" /><img src=\"./images/vip.jpg\" border=0 />";
}
else
{
content += "<br><img border=0 src=\"./images/store1.jpg\" />";
}
content += "</a></td></tr></table>";
}
td.Text = content;
td.HorizontalAlign = HorizontalAlign.Left;
if (j == 0) td.Width = Unit.Percentage(50);
tr.Cells.Add(td);
}
tblGianHang.Rows.Add(tr);
}
int NumberOfRow = int.Parse(ds.Tables[1].Rows[0]["Total"].ToString());
int NumberOfPage = NumberOfRow/PageSize;
if (NumberOfPage*PageSize < NumberOfRow) NumberOfPage += 1;
string strPage = "Trang";
for (int i = 1; i <= NumberOfPage; i++)
{
if (i == CurrentPage)
{
strPage += " [" + i + "]";
}
else
{
strPage += " <a href=\"javascript:GoToPage(" + i + ")\">" + i + "</a>";
}
}
lblPage.Text = strPage;
ddlPage.Items.Clear();
for (int i = 1; i <= NumberOfPage; i++)
{
ListItem li = new ListItem(i.ToString(), i.ToString());
if (i == CurrentPage) li.Selected = true;
ddlPage.Items.Add(li);
}
}
private void LoadCuaHang()
{
try
{
CuaHang ch = new CuaHang();
DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID());
if (ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
Session["CuaHangID"] = dr["CuaHangID"].ToString();
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void LoadDropDownDaTa()
{
try
{
CuaHang ch = new CuaHang();
DataSet dsch;
string cacheCh = "ch" + Common.NguoiDungID();
if (Cache[cacheCh] == null)
{
dsch = ch.SelectByNguoiDungID(Common.NguoiDungID());
Cache.Insert(cacheCh, dsch);
}
else
{
dsch = (DataSet) Cache[cacheCh];
}
if (dsch.Tables[0].Rows.Count > 0)
{
LoadDanhMucConForDropDown(0, int.Parse(dsch.Tables[0].Rows[0]["CuaHangID"].ToString()), 0);
}
HangSanXuat hangsanxuat = new HangSanXuat();
DataSet dsHangSanXuat = hangsanxuat.SelectAll();
if (Cache["hsx"] == null)
{
dsHangSanXuat = hangsanxuat.SelectAll();
Cache.Insert("hsx", dsHangSanXuat);
}
else
{
dsHangSanXuat = (DataSet) Cache["hsx"];
}
DataTable dtHangSanXuat = dsHangSanXuat.Tables[0];
ddlHangSanXuat.DataSource = dtHangSanXuat;
ddlHangSanXuat.DataTextField = "TenHangSanXuat";
ddlHangSanXuat.DataValueField = "HangSanXuatID";
ddlHangSanXuat.DataBind();
KhuVuc khuvuc = new KhuVuc();
DataSet dsKhuVuc;
if (Cache["kv"] == null)
{
dsKhuVuc = khuvuc.SelectAll();
Cache.Insert("kv", dsKhuVuc);
}
else
{
dsKhuVuc = (DataSet) Cache["kv"];
}
DataTable dtKhuVuc = dsKhuVuc.Tables[0];
ddlKhuVuc.DataSource = dtKhuVuc;
ddlKhuVuc.DataTextField = "TenKhuVuc";
ddlKhuVuc.DataValueField = "KhuVucID";
ddlKhuVuc.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
