private void LoadData(int CurrentPage)
{
try
{
string KeySearch = GetKeySearch();
int RowStart = (CurrentPage - 1)*PageSize + 1;
SanPhamMau sanpham = new SanPhamMau();
DataSet ds;
if (CurrentPage == 0)
{
ds = sanpham.SelectAllSanPhamMau();
}
else
{
ds = sanpham.SelectAllSanPhamMauPaging(KeySearch, RowStart, PageSize);
int NoOfPage = (int) Math.Ceiling(double.Parse(ds.Tables[1].Rows[0][0].ToString())/PageSize);
grdSanPhamMau.DisplayLayout.Pager.PageCount = NoOfPage;
grdSanPhamMau.DisplayLayout.Pager.Pattern = "Trang [prev] [default] [next]";
if (CurrentPage + 100 < NoOfPage)
grdSanPhamMau.DisplayLayout.Pager.Pattern += " [page:" + (CurrentPage + 100) +
": Thêm 100 trang] Tổng số [pagecount] trang";
//grdSanPhamMau.DisplayLayout.Pager.
//int TotalShowPage = NoOfPage > 10 ? 11 : NoOfPage;
//string[] custompages = new string[TotalShowPage];
//int StartPage = CurrentPage > 10 ? CurrentPage - 5 : 1;
//int EndPage = CurrentPage > 10 ? 11 : TotalShowPage;
//if (NoOfPage > 10)
//{
// custompages[0] = StartPage;
// for (int i = 0; i < NoOfPage; i++)
// {
// custompages[i] = (i + 1).ToString();
// }
// custompages[
//}
//else
//{
// for (int i = 0; i < NoOfPage; i++)
// {
// custompages[i] = (i + 1).ToString();
// }
//}
//grdSanPhamMau.DisplayLayout.Pager.CustomLabels = custompages;
}
//}
DataTable dt = ds.Tables[0];
grdSanPhamMau.DataSource = dt;
grdSanPhamMau.DataBind();
}
catch (Exception ex)
{
Response.Redirect("../message.aspx?msg=" + ex.ToString().Replace("\r\n", " "));
}
}
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 LoadData()
{
try
{
SanPhamMau sanpham = new SanPhamMau();
DataSet ds = sanpham.SelectByID(int.Parse(ViewState["ID"].ToString()));
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
txtTenSanPham.Text = dr["TenSanPham"].ToString();
//txtMaSoSanPham.Text = dr["MaSoSanPham"].ToString();
txtGiaSanPham.Text = dr["GiaSanPham"].ToString();
ddlNhomSanPham.SelectedValue = dr["NhomSanPhamID"].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();
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();
LoadAnhPhu();
LoadThuocTinhCha();
//LoadThuocTinh();
LoadThuocTinhSanPham(int.Parse(ViewState["ID"].ToString()));
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 bool LuuSanPham()
{
if (Page.IsValid)
{
SanPhamMau sanpham = new SanPhamMau();
try
{
string relativePath = "";
DateTime? NgayBDKM = null;
DateTime? NgayKTKM = null;
string strMoTaKhuyenMai = null;
string path = Server.MapPath("../Upload/ProdImages");
decimal? giamoi = null;
string MaSoSanPham = null;
if (chkKhuyenMai.Checked)
{
NgayBDKM = DateTime.Parse(wdcBatDauKM.Value.ToString());
NgayKTKM = DateTime.Parse(wdcKetThucKM.Value.ToString());
txtMoTaKhuyenMai.Enabled = true;
strMoTaKhuyenMai = txtMoTaKhuyenMai.Text;
}
if (chkGiamGia.Checked)
{
txtGiaMoi.Enabled = true;
cvGiaMoi.Enabled = true;
giamoi = decimal.Parse(txtGiaMoi.Text);
}
if (fileAnhChinh.PostedFile.FileName != "")
{
try
{
//if (fileAnhChinh.PostedFile.ContentLength <= 100000)
//{
string randomString = "";
path += "\\" + Common.NguoiDungID();
relativePath = "./Upload/ProdImages" + "/" + Common.NguoiDungID() + "/";
int pos = fileAnhChinh.PostedFile.FileName.LastIndexOf('\\');
string absolutePath = path + "\\" + fileAnhChinh.PostedFile.FileName.Remove(0, pos + 1);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
if (File.Exists(absolutePath))
{
randomString = DateTime.Now.Ticks + "_";
absolutePath = path + "\\" + randomString +
fileAnhChinh.PostedFile.FileName.Remove(0, pos + 1);
}
//fileAnhChinh.PostedFile.SaveAs(absolutePath);
Common.ResizeFromStream(absolutePath, 320, fileAnhChinh.PostedFile.InputStream);
relativePath += randomString + fileAnhChinh.PostedFile.FileName.Remove(0, pos + 1);
if (ViewState["Action"].ToString() == "ADD")
{
ViewState["ID"] = sanpham.InsertFields(txtTenSanPham.Text, MaSoSanPham,
decimal.Parse(txtGiaSanPham.Text), "VNĐ",
wheMoTaSanPham.Text,
wheThongTinSanPham.Text,
int.Parse(ddlNhomSanPham.SelectedValue),
int.Parse(ddlHangSanXuat.SelectedValue),
Common.NguoiDungID(), relativePath,
chkKhuyenMai.Checked, strMoTaKhuyenMai, giamoi,
NgayBDKM, NgayKTKM,
null, int.Parse(ddlKhuVuc.SelectedValue), null, null,
chkGiamGia.Checked, null, DateTime.Now, null, null,
null, 0, null, null, null, null);
}
else if (ViewState["Action"].ToString() == "EDIT")
{
sanpham.UpdateFields(int.Parse(ViewState["ID"].ToString()), txtTenSanPham.Text, null,
decimal.Parse(txtGiaSanPham.Text), null, wheMoTaSanPham.Text,
wheThongTinSanPham.Text, int.Parse(ddlNhomSanPham.SelectedValue),
int.Parse(ddlHangSanXuat.SelectedValue),
Common.NguoiDungID(), relativePath, chkKhuyenMai.Checked,
strMoTaKhuyenMai, giamoi, NgayBDKM, NgayKTKM,
null, int.Parse(ddlKhuVuc.SelectedValue), null, null,
chkGiamGia.Checked, null, DateTime.Now, null, null,
null, null, null, null, null, null);
}
imgAnhChinh.ImageUrl = "." + relativePath;
//}
//else
//{
// lblAnhChinhErr.Text = "Kích cỡ ảnh quá lớn!";
// return false;
//}
}
catch (Exception ex)
{
Response.Redirect("../message.aspx?msg=" + ex.Message.Replace("\r\n", ""), false);
}
}
else
{
if (ViewState["Action"].ToString() == "ADD")
{
ViewState["ID"] = sanpham.InsertFields(txtTenSanPham.Text, MaSoSanPham,
decimal.Parse(txtGiaSanPham.Text), "VNĐ",
wheMoTaSanPham.Text,
wheThongTinSanPham.Text,
int.Parse(ddlNhomSanPham.SelectedValue),
int.Parse(ddlHangSanXuat.SelectedValue),
Common.NguoiDungID(), null, chkKhuyenMai.Checked,
strMoTaKhuyenMai, giamoi, NgayBDKM, NgayKTKM,
null, int.Parse(ddlKhuVuc.SelectedValue), null, null,
chkGiamGia.Checked, null, DateTime.Now, null, null,
null, 0, null, null, null, null);
}
else if (ViewState["Action"].ToString() == "EDIT")
{
sanpham.UpdateFields(int.Parse(ViewState["ID"].ToString()), txtTenSanPham.Text, null,
decimal.Parse(txtGiaSanPham.Text), null, wheMoTaSanPham.Text,
wheThongTinSanPham.Text, int.Parse(ddlNhomSanPham.SelectedValue),
int.Parse(ddlHangSanXuat.SelectedValue),
Common.NguoiDungID(), null, chkKhuyenMai.Checked, strMoTaKhuyenMai, giamoi,
NgayBDKM, NgayKTKM,
null, int.Parse(ddlKhuVuc.SelectedValue), null, null, chkGiamGia.Checked,
null, DateTime.Now, null, null,
null, null, null, null, null, null);
}
}
LuuThuocTinhSanPham();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
return true;
}
else
{
return false;
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
try
{
switch (ViewState["TYPE"].ToString())
{
case "thuoctinh":
if (Common.LoaiNguoiDungID() == 3)
{
ThuocTinh tt = new ThuocTinh();
tt.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "nhomsanpham":
if (Common.LoaiNguoiDungID() == 3)
{
NhomSanPham nhomsanpham = new NhomSanPham();
nhomsanpham.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "vitrisanpham":
if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2))
{
ViTriSanPham vtsp = new ViTriSanPham();
vtsp.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "cuahangnhomsanpham":
if (Common.LoaiNguoiDungID() == 2)
{
deleteCuaHangNhomSanPham(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "nhomsanphamcuahang":
if (Common.LoaiNguoiDungID() == 2)
{
deleteNhomSanPhamCuaHang(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "nhanxetsanpham":
if (Common.LoaiNguoiDungID() != 1)
{
NhanXetSanPham nhanxet = new NhanXetSanPham();
nhanxet.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "tintuc":
if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2))
{
TinTuc tt = new TinTuc();
tt.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "hotrotructuyen":
if ((Common.LoaiNguoiDungID() == 3) || (Common.LoaiNguoiDungID() == 2))
{
HoTroTrucTuyen ht = new HoTroTrucTuyen();
ht.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "hoidapsanpham":
if (Common.LoaiNguoiDungID() != 1)
{
HoiDapSanPham hoidap = new HoiDapSanPham();
hoidap.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "nguoidung":
if (Common.LoaiNguoiDungID() == 3)
{
if (CheckExistCuaHang(id) != true)
{
NguoiDung nguoidung = new NguoiDung();
nguoidung.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Không thể xóa người dùng đã có cửa hàng", false);
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "hangsanxuat":
if (Common.LoaiNguoiDungID() == 3)
{
HangSanXuat hsx = new HangSanXuat();
hsx.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "khuvuc":
if (Common.LoaiNguoiDungID() == 3)
{
KhuVuc kv = new KhuVuc();
kv.Delete(id);
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "quangcao":
if (Common.LoaiNguoiDungID() == 2 || Common.LoaiNguoiDungID() == 3)
{
QuangCao qcao = new QuangCao();
DataSet ds = qcao.SelectByQuangCaoID(id);
if (ds.Tables[0].Rows.Count == 1)
{
if (Common.LoaiNguoiDungID() == 3)
{
//Administrator
if (ds.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() == "3") qcao.Delete(id);
}
else
{
//e-Store
if (ds.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() == "2"
&& ds.Tables[0].Rows[0]["NguoiDungID"].ToString() == Common.NguoiDungID().ToString())
qcao.Delete(id);
}
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
case "sanpham":
{
SanPham sanpham = new SanPham();
DataSet dssp = sanpham.SelectBySanPhamID(id);
if (Common.LoaiNguoiDungID() == 2)
{
if (dssp.Tables[0].Rows.Count == 1)
{
//e-Store
if (dssp.Tables[0].Rows[0]["LoaiNguoiDungID"].ToString() ==
Common.LoaiNguoiDungID().ToString()
&&
dssp.Tables[0].Rows[0]["NguoiDungID"].ToString() == Common.NguoiDungID().ToString())
{
sanpham.Delete(id);
}
}
}
else if (Common.LoaiNguoiDungID() == 3)
{
if (dssp.Tables[0].Rows.Count == 1)
{
sanpham.Delete(id);
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
}
break;
case "sanphammau":
{
SanPhamMau sanpham = new SanPhamMau();
DataSet dssp = sanpham.SelectByID(id);
if (Common.LoaiNguoiDungID() == 3)
{
if (dssp.Tables[0].Rows.Count == 1)
{
sanpham.Delete(id);
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
}
break;
case "anhsanpham":
if ((Common.LoaiNguoiDungID() == 2) || (Common.LoaiNguoiDungID() == 3))
{
Anh anhsanpham = new Anh();
DataSet dssp = anhsanpham.SelectByID(id);
if (dssp.Tables[0].Rows.Count == 1)
{
anhsanpham.Delete(id);
if (File.Exists(Server.MapPath(Request.QueryString["src"])))
{
File.Delete(Server.MapPath(Request.QueryString["src"]));
}
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
break;
}
string strScript = "<script language='JavaScript'>" + "window.parent.Refresh();</script>";
ClientScript.RegisterStartupScript(Type.GetType("System.String"), "Refresh", strScript);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}