protected void bt_up_Click(object sender, EventArgs e)
{
object[] obj4 = new object[6];
obj4[0] = Session["masanpham1"];
obj4[1] = txt_tensp.Text;
obj4[2] = Convert.ToInt32(drp_nhomhang.SelectedValue);
obj4[3] = Convert.ToInt32(txt_soluong.Text);
obj4[4] = txt_chitiet.Text;
obj4[5] = Convert.ToDouble(txt_dongia.Text);
SupportDb.ExecuteProcdure("capnhatsanpham1", obj4);
lbl_thongbao.Text = "Cập nhật thành công !";
txt_tensp.Text = "";
txt_soluong.Text = "";
txt_chitiet.Text = "";
txt_dongia.Text = "";
ful_anhsp.Enabled = true;
bt_them.Enabled = true;
bt_up.Visible = false;
object[] obj011 = new object[1];
obj011[0] = Session["manh01"];
DataSet dsa = new DataSet();
dsa = SupportDb.ReturnDataSet("timsptheomanh", obj011);
grv_sp.DataSource = dsa;
grv_sp.DataBind();
Panel2.Visible = false;
Panel1.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["quyen"].ToString() != "1")
{
Response.Redirect("~/Dangnhap.aspx");
}
else
{
lbl_xinchao.Text = "Xin chào: " + Session["hoten"].ToString();
}
if (!IsPostBack)
{
Hienthisanpham();
}
object[] objlh = new object[0];
DataSet dsnh = new DataSet();
dsnh = SupportDb.ReturnDataSet("hienthinhomhang", objlh);
if (dsnh.Tables[0].Rows.Count > 0)
{
SupportDb.BindFromDataSetToCombo(dsnh, drp_nhomhang, "MANH", "TENNH");
}
object[] objlh1 = new object[0];
DataSet dsnh1 = new DataSet();
dsnh1 = SupportDb.ReturnDataSet("hienthinhomhang", objlh1);
if (dsnh1.Tables[0].Rows.Count > 0)
{
SupportDb.BindFromDataSetToCombo(dsnh1, drp_manh, "MANH", "TENNH");
}
}
protected void bt_sua_Click(object sender, EventArgs e)
{
string mnh = "";
string maloai = "";
string tennhom = "";
foreach (GridViewRow row in grv_nhomhang.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("chk_Check");
if (chk != null && chk.Checked)
{
int manhom = Convert.ToInt32(grv_nhomhang.DataKeys[row.RowIndex].Value);
Session["manhomh"] = manhom;
object[] obj3 = new object[1];
obj3[0] = manhom;
DataSet dsnhm = new DataSet();
dsnhm = SupportDb.ReturnDataSet("timnhomhangtheoma", obj3);
for (int i = 0; i < dsnhm.Tables[0].Rows.Count; i++)
{
DataRow dr = dsnhm.Tables[0].Rows[i];
mnh = dr["MANH"].ToString();
maloai = dr["MALOAI"].ToString();
tennhom = dr["TENNH"].ToString();
}
}
}
txt_tennhomhang.Text = tennhom;
drp_loaihang.SelectedValue = maloai;
bt_capnhat.Visible = true;
lbl_thanhcong.Text = "";
Hienthinhomhang();
}
protected void Page_Load(object sender, EventArgs e)
{
Title = "Sản phẩm";
Session["TenNSX"] = "";
if (!IsPostBack)
{
if (Request.QueryString["TenLoai"] != null)
{
string loai = Request.QueryString["TenLoai"].ToString();
Global.Currentpage = 0;
object[] obj = new object[1];
obj[0] = loai;
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("HienThiSanPhamTheoLoai", obj);
DataList1.DataSource = ds;
DataList1.DataBind();
ViewState["ds"] = ds;
//BindList();
//
string str = (string)Session["TenNSX"];
if (str == "")
{
m.Edit_DataList(DataList1, "HienThiSanPhamTheoLoai N'" + loai + "'");
}
else
{
m.Edit_DataList(DataList1, "HienThiSanPhamTheoNSX" + str + "");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Title = "Thêm sản phẩm";
if (!Page.IsPostBack)
{
//goi thu tuc lay tat ca kenh du lieu
object[] obj = new object[0];
DataSet dsloai = new DataSet();
dsloai = SupportDb.ReturnDataSet("HienThiLoai", obj);
if (dsloai.Tables[0].Rows.Count > 0)
{
//goi ham de nap du lieu vao dropdownlist
SupportDb.BindFromDataSetToCombo(dsloai, drpLoai, "IDLoai", "TenLoai");
}
//goi thu tuc lay tat ca kenh du lieu
object[] obj1 = new object[0];
DataSet dsnsx = new DataSet();
dsnsx = SupportDb.ReturnDataSet("HienThiNSX", obj);
if (dsnsx.Tables[0].Rows.Count > 0)
{
//goi ham de nap du lieu vao dropdownlist
SupportDb.BindFromDataSetToCombo(dsnsx, drpNSX, "IDNhaSX", "TenNSX");
}
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
object[] obj = new object[2];
obj[0] = txtUser.Text;
obj[1] = md5.maHoa(txtPass.Text);
DataSet dsuser = new DataSet();
dsuser = SupportDb.ReturnDataSet("KiemtraDangNhap", obj);
if (dsuser.Tables[0].Rows.Count > 0)
{
DataRow dr = dsuser.Tables[0].Rows[0];
//dang nhap thanh cong
lbl_thongbao.Visible = false;
Session["TenDangNhap"] = dr["TenDangNhap"].ToString();
Session["MatKhau"] = dr["MatKhau"].ToString();
Session["Quyen"] = dr["TenQuyen"].ToString();
Session["HoTen"] = dr["HoTen"].ToString();
Session["IDKhachHang"] = dr["IDKhachHang"].ToString();
Session["DiaChi"] = dr["DiaChi"].ToString();
Session["Email"] = dr["Email"].ToString();
Session["SDT"] = dr["SDT"].ToString();
DangNhap.Visible = false;
//lbl_tennguoidung.Text = "Chào " + Session["TenNguoiDung"].ToString();
Response.Redirect(Request.ApplicationPath + "/Default.aspx");
}
else
{
lbl_thongbao.Visible = true;
lbl_thongbao.Text = "Vui lòng kiểm tra lại tên đăng nhập hoặc mật khẩu!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Title = "Tìm kiếm";
Session["TenNSX"] = "";
if (!Page.IsPostBack)
{
if (Request.QueryString["TenSP"] != null)
{
string tukhoa = Request.QueryString["TenSP"].ToString();
object[] obj = new object[1];
obj[0] = tukhoa;
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("TimTheoTenSP", obj);
DataList1.DataSource = ds;
DataList1.DataBind();
string str = (string)Session["TenNSX"];
if (str == "")
{
m.Edit_DataList(DataList1, "TimTheoTenSP N'" + tukhoa + "' ");
}
else
{
m.Edit_DataList(DataList1, "HienThiSanPhamTheoNSX" + str + "");
}
}
}
}
protected void bt_capnhat_Click(object sender, EventArgs e)
{
if (txt_mkmoi.Text.Length >= 6)
{
try
{
DataSet dsNd = new DataSet();
object[] obj = new object[2];
obj[0] = Session["taikhoan"].ToString();
obj[1] = md5.hmweb_Encrypt("thuy", txt_mkcu.Text);
dsNd = SupportDb.ReturnDataSet("kiemtramatkhau", obj);
if (dsNd.Tables[0].Rows.Count > 0)
{
obj[0] = Session["taikhoan"].ToString();
obj[1] = md5.hmweb_Encrypt("thuy", txt_mkmoi.Text);
SupportDb.ExecuteProcdure("capnhatmatkhau", obj);
lbl_thanhcong.Text = "Cập nhật Thành công!";
txt_mkcu.Text = "";
txt_mkmoi.Text = "";
txt_ktramkmoi.Text = "";
}
}
catch
{
lbl_thanhcong.Text = "Đã xảy ra lỗi trong quá trình đổi mật khẩu!";
}
}
else
{
lbl_thanhcong.Text = "Mật khẩu mới của bạn quá ngắn (< 6 kí tự)";
}
}
protected void bt_dangky_Click(object sender, EventArgs e)
{
if (chk_dongy.Checked == true)
{
if (txt_matkhau.Text.Length >= 6)
{
try
{
object[] obj2 = new object[2];
obj2[0] = txt_tendangnhap.Text;
obj2[1] = txt_email.Text;
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("ktratendangnhapvaemail", obj2);
if (ds.Tables[0].Rows.Count > 0)
{
lbl_thongbao.Text = "Tên tài khoản đã có người đăng kí.Vui lòng nhập vào tên khác !";
}
else
{
if (ds.Tables[1].Rows.Count > 0)
{
lbl_thongbao.Text = "Email này đã đăng kí. Vui lòng nhập email khác ! ";
}
else
{
object[] obj5 = new object[7];
obj5[0] = Convert.ToInt32(drp_quyen.SelectedValue);
obj5[1] = txt_tendangnhap.Text;
obj5[2] = md5.hmweb_Encrypt("thuy", txt_matkhau.Text);
obj5[3] = txt_hoten.Text;
obj5[4] = txt_diachi.Text;
obj5[5] = txt_dienthoai.Text;
obj5[6] = txt_email.Text;
SupportDb.ExecuteProcdure("nguoidungdangky", obj5);
lbl_thongbao.Text = "Thêm người dùng thành công !";
txt_tendangnhap.Text = "";
txt_matkhau.Text = "";
txt_hoten.Text = "";
txt_diachi.Text = "";
txt_dienthoai.Text = "";
txt_email.Text = "";
}
}
}
catch
{
lbl_thongbao.Text = "Có lỗi trong quá trình thêm người dùng. Bạn vui lòng kiểm tra lại !";
}
}
else
{
lbl_thongbao.Text = "Mật khẩu quá ngắn (< 6 kí tự)";
}
}
Hienthinguoidung();
Panel1.Visible = true;
Panel2.Visible = false;
txt_ten.Text = "";
}
protected void btCapnhat_Click(object sender, EventArgs e)
{
object[] obj = new object[2];
obj[0] = lblIDHoaDon.Text;
obj[1] = drpTinhtrang.SelectedValue.ToString();
SupportDb.ExecuteProcdure("CapNhatHoaDonChuaGiao", obj);
Response.Redirect(Request.ApplicationPath + "/Admin/HoaDonChuaGiao.aspx");
}
protected void btThem_Click(object sender, EventArgs e)
{
object[] obj1 = new object[1];
obj1[0] = txtNSX.Text;
SupportDb.ExecuteProcdure("ThemNSX", obj1);
Response.Write("<script>alert('Thêm NSX thành công!');</script>");
Response.Redirect(Request.ApplicationPath + "/Admin/QLNSX.aspx");
}
protected void btCapnhat_Click(object sender, EventArgs e)
{
object[] objq = new object[2];
objq[0] = txtKhachang.Text;
objq[1] = drpQuyen.SelectedValue;
SupportDb.ExecuteProcdure("CapNhatQuyenKH", objq);
Response.Write("<script>alert('Cập nhật khách hàng thành công!');</script>");
}
protected void bt_s1_Click(object sender, EventArgs e)
{
bt_capnhat.Enabled = true;
string tenkhach = "";
string diachi = "";
string sdt = "";
string email = "";
string ngaydathang = "";
string chuky = "";
string tongtien = "";
string pttt = "";
string ptvc = "";
string tinhtrang = "";
string ghichu = "";
foreach (GridViewRow row in grv_timkiem.Rows)
{
CheckBox chk = (CheckBox)row.FindControl("chk_Check0");
if (chk != null && chk.Checked)
{
int madonhang1 = Convert.ToInt32(grv_timkiem.DataKeys[row.RowIndex].Value);
Session["madonhang"] = madonhang1;
object[] obj33 = new object[1];
obj33[0] = madonhang1;
DataSet dsdh = new DataSet();
dsdh = SupportDb.ReturnDataSet("timdonhangtheoma", obj33);
for (int i = 0; i < dsdh.Tables[0].Rows.Count; i++)
{
DataRow dr = dsdh.Tables[0].Rows[i];
tenkhach = dr["HOTEN"].ToString();
diachi = dr["DIACHI"].ToString();
sdt = dr["SDT"].ToString();
email = dr["EMAIL"].ToString();
ngaydathang = dr["NGAYDATHANG"].ToString();
chuky = dr["CHUKY"].ToString();
tongtien = dr["TONGTIEN"].ToString();
pttt = dr["PTTT"].ToString();
ptvc = dr["PTVC"].ToString();
tinhtrang = dr["TINHTRANG"].ToString();
ghichu = dr["GHICHU"].ToString();
}
}
}
txt_tenkhach.Text = tenkhach;
txt_diachi.Text = diachi;
txt_sdt.Text = sdt;
txt_email.Text = email;
txt_ngaydathang.Text = ngaydathang;
txt_chuky.Text = chuky;
txt_tongtien.Text = tongtien;
txt_pttt.Text = pttt;
txt_ptvc.Text = ptvc;
drp_tinhtrang.SelectedValue = tinhtrang;
drp_ghichu.SelectedValue = ghichu;
hienthitimkiem();
Panel1.Visible = false;
Panel2.Visible = true;
}
private void Hienthisoluongban()
{
object[] objtt = new object[0];
DataSet dssl = new DataSet();
dssl = SupportDb.ReturnDataSet("thongkesoluonghangban", objtt);
grv_slban.DataSource = dssl;
grv_slban.DataBind();
}
private void Hienthiquangcao()
{
object[] obj0 = new object[0];
DataSet dsqc = new DataSet();
dsqc = SupportDb.ReturnDataSet("hienthiquangcao", obj0);
grv_quangcao.DataSource = dsqc;
grv_quangcao.DataBind();
}
private void Hienthisanpham()
{
object[] obj0 = new object[0];
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("laytatcasp", obj0);
grv_sanpham.DataSource = ds;
grv_sanpham.DataBind();
}
private void Hienthihoadon()
{
object[] objtt = new object[0];
DataSet dsa = new DataSet();
dsa = SupportDb.ReturnDataSet("hienthichitietdonhang", objtt);
grv_chitietdh.DataSource = dsa;
grv_chitietdh.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
object[] obj = new object[0];
ds = SupportDb.ReturnDataSet("SanPhamMoi", obj);
DataList1.DataSource = ds;
DataList1.DataBind();
}
private void Hienthihangcon()
{
object[] obj0 = new object[0];
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("thongkehangcontheonhom", obj0);
grv_hangcon.DataSource = ds;
grv_hangcon.DataBind();
}
private void Hienthinguoidung()
{
object[] obj0 = new object[0];
DataSet dsnd = new DataSet();
dsnd = SupportDb.ReturnDataSet("hienthinguoidung", obj0);
grv_nguoidung.DataSource = dsnd;
grv_nguoidung.DataBind();
}
private void Hienthidonhang()
{
object[] obj0 = new object[0];
DataSet ds = new DataSet();
ds = SupportDb.ReturnDataSet("hienthidonhang2", obj0);
grv_donhang.DataSource = ds;
grv_donhang.DataBind();
}
private void Hienthichitietdh()
{
object[] obj3 = new object[1];
obj3[0] = Convert.ToInt32(Session["madh1"]);
DataSet dsctdh = new DataSet();
dsctdh = SupportDb.ReturnDataSet("hienthichitietdonhang2", obj3);
grv_chitietdh.DataSource = dsctdh;
grv_chitietdh.DataBind();
}
protected void bt_them_Click(object sender, EventArgs e)
{
object[] obj1 = new object[2];
obj1[0] = txt_tennhomhang.Text;
obj1[1] = Convert.ToInt32(drp_loaihang.SelectedValue);
SupportDb.ExecuteProcdure("themnhomhang", obj1);
lbl_thanhcong.Text = "Thêm nhóm hàng thành công !";
txt_tennhomhang.Text = "";
Hienthinhomhang();
}
private void timnguoidungtheoten()
{
object[] objtim = new object[1];
objtim[0] = txt_ten.Text;
DataSet dskqnd = new DataSet();
dskqnd = SupportDb.ReturnDataSet("timnguoidungtheoten", objtim);
grv_kqnguoidung.DataSource = dskqnd;
grv_kqnguoidung.DataBind();
}
void PhanTrangDataList_CollectionPaper()
{
object[] objPrint = new object[0];
DataSet dsPrint = new DataSet();
dsPrint = SupportDb.ReturnDataSet("HienThiTatCaSanPham", objPrint);
clpPhantrang.DataSource = dsPrint.Tables[0].DefaultView;
clpPhantrang.BindToControl = DataList1;
DataList1.DataSource = clpPhantrang.DataSourcePaged;
}
private void hienthitimkiem()
{
object[] obja = new object[2];
obja[0] = txt_tenkhach1.Text;
obja[1] = Convert.ToInt32(drp_thang.SelectedValue);
DataSet ds1 = new DataSet();
ds1 = SupportDb.ReturnDataSet("timdonhangtheotenkhachvathang", obja);
grv_timkiem.DataSource = ds1;
grv_timkiem.DataBind();
}
protected void grv_ctdh_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grv_ctdh.PageIndex = e.NewPageIndex;
object[] obj02 = new object[1];
obj02[0] = Session["dhthang"];
DataSet ds11 = new DataSet();
ds11 = SupportDb.ReturnDataSet("layhoadontrongthang", obj02);
grv_ctdh.DataSource = ds11;
grv_ctdh.DataBind();
}
private void laydhthang()
{
object[] obj0 = new object[1];
obj0[0] = Convert.ToInt32(drp_thang.SelectedValue);
Session["dhthang"] = Convert.ToInt32(drp_thang.SelectedValue);
DataSet ds1 = new DataSet();
ds1 = SupportDb.ReturnDataSet("layhoadontrongthang", obj0);
grv_ctdh.DataSource = ds1;
grv_ctdh.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
object[] obj4 = new object[3];
obj4[0] = Session["manhomh"];
obj4[1] = txt_tennhomhang.Text;
obj4[2] = Convert.ToInt32(drp_loaihang.SelectedValue);
SupportDb.ExecuteProcdure("capnhatnhomhang", obj4);
lbl_thanhcong.Text = "Cập nhật thành công !";
txt_tennhomhang.Text = "";
Hienthinhomhang();
}
protected void grv_sp_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grv_sp.PageIndex = e.NewPageIndex;
object[] obj011 = new object[1];
obj011[0] = Session["manh01"];
DataSet dsa = new DataSet();
dsa = SupportDb.ReturnDataSet("timsptheomanh", obj011);
grv_sp.DataSource = dsa;
grv_sp.DataBind();
}
