private void LoadKH()
{
DataTable dt = kn.GetData("select * from KhachHang");
gvKhachhang.DataSource = dt;
gvKhachhang.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["tendn"] != null)
{
string sql = "select dh.*, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end as TrangThai "
+ " from KhachHang kh, DonDatHang dh where kh.MaKH=dh.MaKH and kh.SDT='" + Session["tendn"].ToString() +
"' and TinhTrang <> -1 order by MaDH desc";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
gvdonhang.DataSource = dt;
gvdonhang.DataBind();
}
if (Request.QueryString["id"] != null)
{
int madh = int.Parse(Request.QueryString["id"].ToString());
string s = "update DonDatHang set TinhTrang= -1 where MaDH=" + madh;
try
{
kn.Execute(s);
Response.Write("<script> alert('Hủy đơn hàng thành công.');window.location='donhuy.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
}
}
else
{
Response.Write("<script type='text/javascript' language='javascript'>alert('Bạn cần đăng nhập để xem thông tin đơn hàng.');window.location='../dangnhap.aspx';</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["manvien"] != null)
{
DataTable dt = kn.GetData("select MaNV,TenNV,NgaySinh,GioiTinh,DiaChi,SDT,Email from NhanVien where MaNV =" + int.Parse(Session["manvien"].ToString()));
if (dt.Rows.Count > 0)
{
txttendn.Text = dt.Rows[0][0].ToString();
txthoten.Text = dt.Rows[0][1].ToString();
DateTime date = Convert.ToDateTime(dt.Rows[0][2].ToString());
txtngsinh.Text = String.Format("{0:dd/MM/yyyy}", date);
cmbgtinh.Text = dt.Rows[0][3].ToString();
txtdiachi.Text = dt.Rows[0][4].ToString();
txtsdt.Text = dt.Rows[0][5].ToString();
txtemail.Text = dt.Rows[0][6].ToString();
lblemail.Text = txtemail.Text;
lblsdt.Text = txtsdt.Text;
}
else
{
lbltbao.Text = "Đã xảy ra lỗi. Vui lòng kiểm tra lại.";
}
}
else
{
Response.Redirect("dangnhap.aspx");
}
}
}
public void loadMaBG()
{
DataTable dt = kn.GetData("select * from Danhsachbuugui");
cmbmabg.DataSource = dt;
cmbmabg.DisplayMember = "Mabg";
cmbmabg.ValueMember = "Mabg";
}
protected void btndangki_Click(object sender, EventArgs e)
{
string sql = "select * from TaiKhoan where TenND='" + txttendn.Text.Trim() + "'";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
lbltbloi.Text = "Số điện thoại đã đăng ký.";
}
else
{
sql = "select MaKH from (select MaKH,Email from KhachHang union select MaNV,Email from NhanVien) DB where Email='" + txtemail.Text.Trim() + "'";
dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
lbltbloi.Text = "Email đã tồn tại.";
}
else
{
sql = "select MaKH from KhachHang where SDT='" + txttendn.Text.Trim() + "'";
dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
try
{
sql = "update KhachHang set TenKH= N'" + txthoten.Text.Trim() + "',Email='" + txtemail.Text.Trim() + "' where SDT='" + txttendn.Text.Trim() + "'";
kn.Execute(sql);
sql = "insert into TaiKhoan values(" + int.Parse(dt.Rows[0][0].ToString()) + ",'" + txttendn.Text.Trim() + "','" + MaHoaMatKhau(txtmk.Text.Trim()) + "',N'Khách hàng')";
kn.Execute(sql);
Response.Write("<script> alert('Đăng ký thành công.'); window.location='../dangnhap.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
}
else
{
try
{
sql = "insert into KhachHang values(N'" + txthoten.Text.Trim() + "','" + txttendn.Text.Trim() + "','" + txtemail.Text.Trim() + "')";
kn.Execute(sql);
dt = kn.GetData("select MaKH from KhachHang where SDT= '" + txttendn.Text.Trim() + "'");
if (dt.Rows.Count > 0)
{
sql = "insert into TaiKhoan values(" + int.Parse(dt.Rows[0][0].ToString()) + ",'" + txttendn.Text.Trim() + "','" + MaHoaMatKhau(txtmk.Text.Trim()) + "',N'Khách hàng')";
kn.Execute(sql);
}
Response.Write("<script> alert('Đăng ký thành công.'); window.location='../dangnhap.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
}
}
}
}
private void LayThongTinSP_ThemGio(int masp)
{
string s = "select TenSP,HinhAnh,DVT,GiaBan,SoLuong,KhuyenMai,ThanhTien from SanPham left join CTHoaDon on SanPham.MaSP=CTHoaDon.MaSP where SanPham.MaSP=" + masp;
DataTable dt = kn.GetData(s);
string tensp = dt.Rows[0][0].ToString();
string hinh = dt.Rows[0][1].ToString();
float dongia = float.Parse(dt.Rows[0][3].ToString());
string dvt = dt.Rows[0][2].ToString();
float khuyenmai = float.Parse(dt.Rows[0][5].ToString());
int soluong = 1;
ThemGioHang(masp, tensp, hinh, dvt, dongia, khuyenmai, soluong);
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
int soluongton;
string ktrsoluong = "Select SoLuongNhap-SoLuongBan as SLT from R_TonKho where TenSP= (select TenSP from SanPham where MaSP=" + Convert.ToInt32(Request.QueryString["maSo"].ToString()) + ")";
DataTable ktsl = kn.GetData(ktrsoluong);
if (ktsl.Rows.Count > 0)
{
Label slton = e.Item.FindControl("lblslc") as Label;
HyperLink hlmuahang = e.Item.FindControl("hlmuahang") as HyperLink;
HyperLink hldathang = e.Item.FindControl("hldathang") as HyperLink;
if (ktsl.Rows[0][0].ToString() != "")
{
soluongton = int.Parse(ktsl.Rows[0][0].ToString());
if (soluongton > 0)
{
slton.Text = "Số lượng còn: " + soluongton;
}
else
{
slton.Text = "Hết hàng tạm thời";
hlmuahang.Visible = false;
hldathang.Visible = false;
}
}
else
{
slton.Text = "Hết hàng tạm thời";
hlmuahang.Visible = false;
}
}
}
protected void btndoimk_Click(object sender, EventArgs e)
{
string sql;
sql = "select * from TaiKhoan where TenND=" + int.Parse(Session["tendn"].ToString()) + " and MatKhau='" + MaHoaMatKhau(txtmkcu.Text.Trim()) + "'";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
try
{
sql = "update TaiKhoan set MatKhau='" + MaHoaMatKhau(txtmkmoi.Text.Trim()) + "' where TenND=" + int.Parse(Session["tendn"].ToString());
kn.Execute(sql);
Response.Write("<script type='text/javascript'>alert('Đổi mật khẩu thành công.');window.location='../dangnhap.aspx';</script>");
}
catch
{
lbltbloi.Text = "Đã xảy ra lỗi. Vui lòng kiểm tra lại.";
}
}
else
{
lbltbloi.Text = "Mật khẩu cũ không đúng.";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["tendn"] != null)
{
string sql = "select MaKH from KhachHang where SDT='" + Session["tendn"].ToString() + "'";
DataTable dtMaKH = kn.GetData(sql);
if (dtMaKH.Rows.Count > 0)
{
makh = int.Parse(dtMaKH.Rows[0][0].ToString());
if (Session["giohang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["giohang"];
float tongtien = 0;
foreach (DataRow row in dt.Rows)
{
row["ThanhTien"] = int.Parse(row["SoLuong"].ToString()) * float.Parse(row["GiaBan"].ToString()) * (1 - float.Parse(row["KhuyenMai"].ToString()) / 100);
tongtien += float.Parse(row["ThanhTien"].ToString());
}
lbltongthanhtien.Text = String.Format("{0:#,##0}", float.Parse(tongtien.ToString())) + " đồng";
gvgiohang.DataSource = dt;
gvgiohang.DataBind();
lbltongcong.Visible = true;
lbltongthanhtien.Visible = true;
}
else
{
Response.Redirect("~/sieuthi/giohang.aspx");
}
}
}
else
{
Response.Write("<script type='text/javascript' language='javascript'>alert('Bạn cần đăng nhập để mua hàng.');window.location='../dangnhap.aspx';</script>");
}
if (!IsPostBack)
{
string laythongtin = "select TenKH,DDH.DiaChiNhan,KH.SDT from KHACHHANG KH, DonDatHang DDH where KH.MaKH=DDH.MaKH and KH.MaKH=" + makh;
DataTable dtKH = kn.GetData(laythongtin);
if (dtKH.Rows.Count > 0)
{
txthoten.Text = dtKH.Rows[0][0].ToString();
txtdiachi.Text = dtKH.Rows[0][1].ToString();
txtdt.Text = dtKH.Rows[0][2].ToString();
}
}
}
private void DanhMuc()
{
DataTable dt = kn.GetData("select MaLoai,TenLoai from LoaiSP");
if (dt.Rows.Count > 0)
{
DLDanhMuc.DataSource = dt;
DLDanhMuc.DataBind();
}
}
private void TenLoaiSP()
{
int maloai = int.Parse(Request.QueryString["maloai"].ToString());
DataTable dt = kn.GetData("select TenLoai from LoaiSP where MaLoai=" + maloai);
if (dt.Rows.Count > 0)
{
lbldanhmuc.Text = dt.Rows[0][0].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["tendn"] != null)
{
string sql = "select dh.*, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end as TrangThai "
+ " from KhachHang kh, DonDatHang dh where kh.MaKH=dh.MaKH and kh.SDT='" + Session["tendn"].ToString() +
"' and TinhTrang = -1 order by MaDH desc";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
gvdonhang.DataSource = dt;
gvdonhang.DataBind();
}
}
else
{
Response.Write("<script type='text/javascript' language='javascript'>alert('Bạn cần đăng nhập để xem thông tin đơn hàng.');window.location='../dangnhap.aspx';</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["tendn"] != null)
{
DataTable dt = kn.GetData("select TenKH,SDT,Email from KhachHang where SDT ='" + Session["tendn"].ToString() + "'");
if (dt.Rows.Count > 0)
{
txttendn.Text = dt.Rows[0][1].ToString();
txthoten.Text = dt.Rows[0][0].ToString();
txtemail.Text = dt.Rows[0][2].ToString();
lblemail.Text = txtemail.Text;
}
}
else
{
Response.Redirect("../dangnhap.aspx");
}
}
}
private void LoadNV(int manv)
{
DataTable dt = kn.GetData("select * from NhanVien where MaNV=" + manv);
gvTimKiem.DataSource = dt;
gvTimKiem.DataBind();
}
private void LoadNV()
{
DataTable dt = kn.GetData("select * from NhanVien");
gvNhanvien.DataSource = dt;
gvNhanvien.DataBind();
}
protected void btndangnhap_Click(object sender, EventArgs e)
{
try
{
string sql = "select LoaiND from TaiKhoan where TenND='" + txtusername.Text.Trim() + "' and MatKhau='" + MaHoaMatKhau(txtpassword.Text) + "'";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
Session["chucvu"] = dt.Rows[0][0].ToString();
if (Session["chucvu"].ToString() == "Khách hàng")
{
Session["tendn"] = txtusername.Text.Trim();
Response.Redirect("~/trangchu.aspx");
}
else
{
string sql1 = "select TenNV from NhanVien where MaNV=" + int.Parse(txtusername.Text.Trim());
DataTable dt1 = kn.GetData(sql1);
if (dt1.Rows.Count > 0)
{
Session["manvien"] = int.Parse(txtusername.Text.Trim());
Session["ten"] = dt1.Rows[0][0].ToString();
}
Response.Redirect("qlsieuthi.aspx");
}
}
else
{
lbltbloi.Text = "Username hoặc Password không đúng ";
txtpassword.Text = "";
}
}
catch
{
lbltbloi.Text = "Username hoặc Password không đúng ";
txtpassword.Text = "";
}
}
public void LoadDSBuuGui()
{
dsbuugui.Items.Clear();
DataTable dt = kn.GetData("select * from Danhsachbuugui");
for (int i = 0; i < dt.Rows.Count; i++)
{
ListViewItem it = new ListViewItem((i + 1).ToString());
it.SubItems.Add(dt.Rows[i][0].ToString());
it.SubItems.Add(dt.Rows[i][1].ToString());
it.SubItems.Add(dt.Rows[i][3].ToString());
it.SubItems.Add(dt.Rows[i][4].ToString());
it.SubItems.Add(dt.Rows[i][6].ToString());
it.SubItems.Add(dt.Rows[i][7].ToString());
it.SubItems.Add(String.Format("{0:dd/MM/yyyy}", dt.Rows[i][9]));
it.SubItems.Add(dt.Rows[i][10].ToString());
it.SubItems.Add(String.Format("{0:#,##0}", float.Parse(dt.Rows[i][15].ToString())));
it.SubItems.Add(String.Format("{0:#,##0}", float.Parse(dt.Rows[i][16].ToString())));
dsbuugui.Items.Add(it);
dsach = dsbuugui;
}
}
protected void txtmakh_TextChanged(object sender, EventArgs e)
{
string sql = "select TenKH from KhachHang where SDT='" + txtmakh.Text + "'";
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
txttenkh.Text = dt.Rows[0][0].ToString();
Session["sdt"] = txtmakh.Text;
Session["tenkh"] = txttenkh.Text;
}
else
{
txttenkh.Text = "";
}
}
protected void LoadCmb(string sql, string textfield, string valuefield, DropDownList cmb, string name)
{
DataTable dt = kn.GetData(sql);
DataTable dt1 = new DataTable();
dt1.Columns.Add(valuefield);
dt1.Columns.Add(textfield);
DataRow dr = dt1.NewRow();
dr[valuefield] = 1;
dr[textfield] = name;
dt1.Rows.Add(dr);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr1 = dt.Rows[i];
dt1.ImportRow(dr1);
}
cmb.DataSource = dt1;
cmb.DataTextField = textfield;
cmb.DataValueField = valuefield;
cmb.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Tendangnhap"] == null)
{
Response.Redirect("~/DangNhap.aspx");
}
if (Session["GioHang"] == null)
{
Response.Redirect("~/DatHang.aspx");
}
if (Session["TenDangNhap"] != null)
{
string s = "select Tendangnhap,Matkhau,Sodienthoai,Email,DiaChi from TAIKHOAN where Tendangnhap = '" + Session["Tendangnhap"].ToString() + "'";
DataTable dtkh = x.GetData(s);
if (dtkh.Rows.Count > 0)
{
//KhachHangID = int.Parse(dt.Rows[0][0].ToString());
lbHoTen.Text = dtkh.Rows[0]["Tendangnhap"].ToString();
lbDiaChi.Text = dtkh.Rows[0]["Diachi"].ToString();
lbDienThoai.Text = dtkh.Rows[0]["Sodienthoai"].ToString();
lbEmail.Text = dtkh.Rows[0]["Email"].ToString();
}
}
if (Session["GioHang"] != null)
{
DataTable dtgh = new DataTable();
dtgh = (DataTable)Session["GioHang"];
gvGioHang.DataSource = dtgh;
gvGioHang.DataBind();
}
if (Session["GioHang"] != null)
{
DataTable dtgh = new DataTable();
dtgh = (DataTable)Session["GioHang"];
System.String TongTien = "";
foreach (DataRow r in dtgh.Rows)
{
r["ThanhTien"] = r["Gia"];
TongTien = Convert.ToString(r["ThanhTien"]);
lbtongtien.Text = TongTien.ToString();
}
gvGioHang.DataSource = dtgh;
gvGioHang.DataBind();
}
if (!IsPostBack)
{
cldNgayGiaoHang.SelectedDate = DateTime.Today;
}
}
private string maTuTang()
{
string sql = "SELECT Mabg FROM Danhsachbuugui";
// Lấy DataTable từ câu truy vấn truyền vào (Apdapter Fill DataTable)
DataTable tb = kn.GetData(sql);
int[] arrCode = new int[tb.Rows.Count];
int code;
for (int i = 0; i < tb.Rows.Count; i++)
{
code = int.Parse(tb.Rows[i]["Mabg"].ToString().Remove(0, 2));
arrCode[i] = code;
}
code = arrCode.Max() + 1;
return("BK00" + code);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
if (Session["tendn"] == null)
{
Response.Redirect("dangnhap.aspx");
}
if (Request.QueryString["mapx"] != null)
{
int maso = int.Parse(Request.QueryString["mapx"].ToString());
DataTable dt = kn.GetData("select * from CTPhieuXuat where MaPhieu=" + maso);
if (dt.Rows.Count <= 0)
{
kn.Execute("delete from PhieuXuat where MaPhieu=" + maso);
xuathd.Visible = false;
}
}
}
private void btndoimk_Click(object sender, EventArgs e)
{
if (txtmkcu.Text != "" && txtmkmoi.Text != "" && txtnhaplaimk.Text != "")
{
DataTable dt = kn.GetData("select * from Dangnhap where MaND='" + DangNhap.mand + "' and MatKhau='" + txtmkcu.Text.Trim() + "'");
if (dt.Rows.Count > 0)
{
if (txtmkmoi.Text.Trim() == txtnhaplaimk.Text.Trim())
{
try
{
kn.Execute("update Dangnhap set MatKhau='" + txtmkmoi.Text.Trim() + "' where MaND='" + DangNhap.mand + "'");
MessageBox.Show("Đổi mật khẩu thành công", "Thông báo");
}
catch
{
MessageBox.Show("Đổi mật khẩu thất bại", "Thông báo");
}
}
else
{
MessageBox.Show("Mật khẩu nhập lại không khớp", "Thông báo");
txtnhaplaimk.Text = "";
txtnhaplaimk.Focus();
}
}
else
{
MessageBox.Show("Mật khẩu cũ không đúng", "Thông báo");
txtmkcu.SelectAll();
txtmkcu.Focus();
}
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin", "Thông báo");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["hc"] != null)
{
int Masp = int.Parse(Request.QueryString["hc"]);
DataTable dl = x.GetData("SELECT IDSanPham,TenSP,HinhSP,HinhSP2,HinhSP3,HinhSP4,HinhSP5,MoTa,Gia,PhienBan,XuatXu,KieuGiang,TinhTrang,NamSanXuat,NoiBan,Odo,HopSo,MauNgoaiThat,MauNoiThat,SoCua,SoGhe,DungTichXiLanh,DanDong,NhienLieu FROM SANPHAM where IDSanPham=" + Masp);
Masp = int.Parse(dl.Rows[0][0].ToString());
string Tensp = dl.Rows[0][1].ToString();
string Hinhsp1 = dl.Rows[0][2].ToString();
string Hinhsp2 = dl.Rows[0][3].ToString();
string Hinhsp3 = dl.Rows[0][4].ToString();
string Hinhsp4 = dl.Rows[0][5].ToString();
string Hinhsp5 = dl.Rows[0][6].ToString();
string Mota = dl.Rows[0][7].ToString();
string Giasp = dl.Rows[0][8].ToString();
string Phienban = dl.Rows[0][9].ToString();
string Xuatxu = dl.Rows[0][10].ToString();
string Kieugiang = dl.Rows[0][11].ToString();
string Tinhtrang = dl.Rows[0][12].ToString();
int Namsanxuat = Convert.ToInt32(dl.Rows[0][13].ToString());
string Noiban = dl.Rows[0][14].ToString();
int Odo = Convert.ToInt32(dl.Rows[0][15].ToString());
string Hopso = dl.Rows[0][16].ToString();
string Maungoaithat = dl.Rows[0][17].ToString();
string Maunoithat = dl.Rows[0][18].ToString();
int Socua = Convert.ToInt32(dl.Rows[0][19].ToString());
int Soghe = Convert.ToInt32(dl.Rows[0][20].ToString());
int Dungtichxilanh = Convert.ToInt32(dl.Rows[0][21].ToString());
string Dandong = dl.Rows[0][22].ToString();
string Nhienlieu = dl.Rows[0][23].ToString();
ThemVaodl(Masp, Tensp, Hinhsp1, Hinhsp2, Hinhsp3, Hinhsp4, Hinhsp5, Mota, Giasp, Phienban, Xuatxu, Kieugiang, Tinhtrang, Namsanxuat, Noiban, Odo, Hopso, Maungoaithat, Maunoithat, Socua, Soghe, Dungtichxilanh, Dandong, Nhienlieu);
dlSanPham.DataSource = dl;
dlSanPham.DataBind();
}
}
}
private void btndangnhap_Click(object sender, EventArgs e)
{
if (txttendn.Text != "" && txtmk.Text != "")
{
string s = "select MaND from Dangnhap where TenDN='" + txttendn.Text.Trim() + "' and MatKhau='" + txtmk.Text.Trim() + "'";
DataTable dt = kn.GetData(s);
if (dt.Rows.Count > 0)
{
mand = dt.Rows[0][0].ToString();
Form_main frm = new Form_main();
frm.Show();
this.Hide();
}
else
{
MessageBox.Show("Đăng nhập thất bại", "Thông báo");
}
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin", "Thông báo");
}
}
protected void Page_Load(object sender, EventArgs e)
{
CheckDN();
if (!IsPostBack)
{
if (Request.QueryString["hc"] != null)
{
int Masp = int.Parse(Request.QueryString["hc"]);
DataTable dt = x.GetData("SELECT TenSP,Gia,MauNgoaiThat,PhienBan,HinhSP FROM SANPHAM where IDSanPham=" + Masp);
string Tensp = dt.Rows[0][0].ToString();
string Giasp = dt.Rows[0][1].ToString();
string Maungoaithat = dt.Rows[0][2].ToString();
string Phienban = dt.Rows[0][3].ToString();
string Hinhsp = dt.Rows[0][4].ToString();
ThemVaoGioHang(Tensp, Giasp, Maungoaithat, Phienban, Hinhsp);
}
if (Session["GioHang"] != null)
{
DataTable dt = new DataTable();
dt = (DataTable)Session["GioHang"];
System.String TongTien = "";
foreach (DataRow r in dt.Rows)
{
r["ThanhTien"] = r["Gia"];
TongTien = Convert.ToString(r["ThanhTien"]);
lbtongtien.Text = TongTien.ToString();
}
gvGioHang.DataSource = dt;
gvGioHang.DataBind();
}
if (Session["GioHang"] == null)
{
Response.Write("<script> alert('Giỏ hàng rỗng !')</script>");
}
}
}
protected void LoadNguoiDung()
{
gvNguoiDung.DataSource = kn.GetData("select * from TaiKhoan");
gvNguoiDung.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["malh"] != null)
{
gvLH.Visible = false;
Label1.Text = "Nội Dung";
int malh = int.Parse(Request.QueryString["malh"].ToString());
string sql = "select * from LienHe where MaLH=" + malh;
DataTable dt = kn.GetData(sql);
if (dt.Rows.Count > 0)
{
lblhoten.Text = dt.Rows[0]["HoTen"].ToString();
lblemail.Text = dt.Rows[0]["Email"].ToString();
lblcauhoi.Text = dt.Rows[0]["NoiDung"].ToString();
if (dt.Rows[0]["TrangThai"].ToString() == "True")
{
traloi.Visible = false;
btngui.Visible = false;
txtnoidung.Visible = false;
}
}
}
else if (Request.QueryString["timkiemlh"] != null)
{
gvLH.Visible = false;
lblcauhoi.Visible = false;
lblemail.Visible = false;
lblhoten.Visible = false;
email.Visible = false;
cauhoi.Visible = false;
hoten.Visible = false;
traloi.Visible = false;
txtnoidung.Visible = false;
btngui.Visible = false;
Label1.Text = "Tìm kiếm";
string ngay = Request.QueryString["timkiemlh"].ToString();
string[] chuoi = ngay.Split('-');
string[] str = chuoi[0].Split('/');
string[] str1 = chuoi[1].Split('/');
string date = str[2] + "-" + str[1] + "-" + str[0];
string date1 = str1[2] + "-" + str1[1] + "-" + str1[0];
string sql = "";
sql = "SELECT *, case when TrangThai=0 then N'Chưa phản hồi' else N'Đã phản hồi' end as TT from LienHe where NgayGui between '" + date + "' and '" + date1 + " 23:59:59' order by NgayGui desc";
DataTable dt = kn.GetData(sql);
gvLHTK.DataSource = dt;
gvLHTK.DataBind();
if (gvLHTK.Rows.Count == 0)
{
Label1.Text = "Tìm kiếm: Không tìm thấy";
}
}
else if (Request.QueryString["tim_malh"] != null)
{
int malh = int.Parse(Request.QueryString["tim_malh"].ToString());
gvLH.Visible = false;
lblcauhoi.Visible = false;
lblemail.Visible = false;
lblhoten.Visible = false;
email.Visible = false;
cauhoi.Visible = false;
hoten.Visible = false;
traloi.Visible = false;
txtnoidung.Visible = false;
btngui.Visible = false;
Label1.Text = "Tìm kiếm";
string sql = "SELECT *, case when TrangThai=0 then N'Chưa phản hồi' else N'Đã phản hồi' end as TT from LienHe where MaLH=" + malh + " order by NgayGui desc";
DataTable dt = kn.GetData(sql);
gvLHTK.DataSource = dt;
gvLHTK.DataBind();
if (gvLHTK.Rows.Count == 0)
{
Label1.Text = "Tìm kiếm: Không tìm thấy";
}
}
else if (Request.QueryString["tim_email"] != null)
{
string txtemail = Request.QueryString["tim_email"].ToString();
gvLH.Visible = false;
lblcauhoi.Visible = false;
lblemail.Visible = false;
lblhoten.Visible = false;
email.Visible = false;
cauhoi.Visible = false;
hoten.Visible = false;
traloi.Visible = false;
txtnoidung.Visible = false;
btngui.Visible = false;
Label1.Text = "Tìm kiếm";
string sql = "SELECT *, case when TrangThai=0 then N'Chưa phản hồi' else N'Đã phản hồi' end as TT from LienHe where Email like '%" + txtemail + "%' order by NgayGui desc";
DataTable dt = kn.GetData(sql);
gvLHTK.DataSource = dt;
gvLHTK.DataBind();
if (gvLHTK.Rows.Count == 0)
{
Label1.Text = "Tìm kiếm: Không tìm thấy";
}
}
else
{
lblcauhoi.Visible = false;
lblemail.Visible = false;
lblhoten.Visible = false;
email.Visible = false;
cauhoi.Visible = false;
hoten.Visible = false;
traloi.Visible = false;
txtnoidung.Visible = false;
btngui.Visible = false;
}
if (Request.QueryString["id"] != null)
{
int ma = int.Parse(Request.QueryString["id"].ToString());
string s = "delete from LienHe where MaLH=" + ma;
try
{
kn.Execute(s);
Response.Write("<script> alert('Xóa thành công.');window.location='lienhe.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["madh"] != null)
{
gvDDH.Visible = false;
lblten.Text = "Chi Tiết Đơn Đặt Hàng";
int madh = int.Parse(Request.QueryString["madh"].ToString());
DataTable dt = kn.GetData("select TinhTrang from DonDatHang where MaDH=" + madh);
if (dt.Rows[0][0].ToString() == "0")
{
btnxacnhan.Visible = true;
}
}
else if (Request.QueryString["id"] != null)
{
int ma = int.Parse(Request.QueryString["id"].ToString());
string s = "delete from DonDatHang where MaDH=" + ma;
try
{
kn.Execute(s);
Response.Write("<script> alert('Xóa thành công.');window.location='dondathang.aspx'; </script>");
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
}
else if (Request.QueryString["timkiemdh"] != null)
{
string ngay = Request.QueryString["timkiemdh"].ToString();
string[] chuoi = ngay.Split('-');
string[] str = chuoi[0].Split('/');
string[] str1 = chuoi[1].Split('/');
string date = str[2] + "-" + str[1] + "-" + str[0];
string date1 = str1[2] + "-" + str1[1] + "-" + str1[0];
string sql = "";
sql = "SELECT *, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end as TrangThai from DonDatHang where NgayDH between '" + date + "' and '" + date1 + " 23:59:59' order by NgayDH desc";
DataTable dt = kn.GetData(sql);
gvDDH.DataSource = dt;
gvDDH.DataBind();
if (gvDDH.Rows.Count == 0)
{
lblten.Text = "Kết quả tìm kiếm: Không tìm thấy";
}
else
{
lblten.Text = "Kết quả tìm kiếm: " + gvDDH.Rows.Count;
}
}
else if (Request.QueryString["tim_madon"] != null)
{
int madon = int.Parse(Request.QueryString["tim_madon"].ToString());
string sql = "SELECT *, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end as TrangThai from DonDatHang where MaDH=" + madon + " order by NgayDH desc";
DataTable dt = kn.GetData(sql);
gvDDH.DataSource = dt;
gvDDH.DataBind();
if (gvDDH.Rows.Count == 0)
{
lblten.Text = "Kết quả tìm kiếm: Không tìm thấy";
}
else
{
lblten.Text = "Kết quả tìm kiếm: " + gvDDH.Rows.Count;
}
}
else if (Request.QueryString["tim_sdt"] != null)
{
string sdt = Request.QueryString["tim_sdt"].ToString();
string sql = "SELECT *, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end as TrangThai from DonDatHang where SDT='" + sdt + "' order by NgayDH desc";
DataTable dt = kn.GetData(sql);
gvDDH.DataSource = dt;
gvDDH.DataBind();
if (gvDDH.Rows.Count == 0)
{
lblten.Text = "Kết quả tìm kiếm: Không tìm thấy";
}
else
{
lblten.Text = "Kết quả tìm kiếm: " + gvDDH.Rows.Count;
}
}
else
{
lblten.Text = "Danh Sách Đơn Đặt Hàng";
string sql = "select *, case when TinhTrang=0 then N'Chưa giao' when TinhTrang=1 then N'Đã giao' else N'Đã hủy' end TrangThai from DonDatHang";
DataTable dt = kn.GetData(sql);
gvDDH.DataSource = dt;
gvDDH.DataBind();
gvCTDH.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["manvien"] != null)
{
txtmanv.Text = Session["manvien"].ToString();
txtngnhap.Text = String.Format("{0:dd/MM/yyyy HH:mm:ss}", DateTime.Now);
LoadCmb("select MaSP,TenSP from SanPham", "TenSP", "MaSP", cmbmasp, "--- Sản phẩm ---");
if (Request.QueryString["sp"] != null)
{
try
{
int masp = int.Parse(Request.QueryString["sp"].ToString());
string sql = "select TenSP from SanPham where MaSP=" + masp;
DataTable dt1 = kn.GetData(sql);
string tensp = dt1.Rows[0][0].ToString();
float dongia = float.Parse(Session["dongia"].ToString());
int soluong = int.Parse(Session["soluong"].ToString());
string ghichu = Session["ghichu"].ToString();
ThemCTPN(masp, tensp, dongia, soluong, ghichu);
}
catch
{
Response.Write("<script> alert('Đã xảy ra lỗi. Vui lòng kiểm tra lại.') </script>");
}
Session["soluong"] = 0;
Session["dongia"] = 0;
}
if (Session["ctpn"] != null)
{
float tongtien = 0;
DataTable dt = new DataTable();
dt = (DataTable)Session["ctpn"];
foreach (DataRow row in dt.Rows)
{
row["ThanhTien"] = float.Parse(row["SoLuong"].ToString()) * float.Parse(row["DonGia"].ToString());
tongtien += float.Parse(row["ThanhTien"].ToString());
lblthanhtien.Text = String.Format("{0:#,##0}", tongtien) + " đồng";
}
gvCTPN.DataSource = dt;
gvCTPN.DataBind();
btnHuy.Visible = true;
btninphieu.Visible = true;
lbltc.Visible = true;
lblthanhtien.Visible = true;
btncapnhat.Visible = true;
}
else
{
Session["soluong"] = null;
Session["ghichu"] = null;
Session["dongia"] = null;
btnHuy.Visible = false;
btninphieu.Visible = false;
lbltc.Visible = false;
lblthanhtien.Visible = false;
btncapnhat.Visible = false;
}
}
else
{
Response.Redirect("dangnhap.aspx");
}
}
}
