private void FrmTaiKhoan_Load(object sender, EventArgs e)
{
dgvDanhSachTK.AutoGenerateColumns = false;
TaiKhoanBUS bus = new TaiKhoanBUS();
List <TaiKhoanDTO> dto = bus.LayDSTaiKhoan();
dgvDanhSachTK.DataSource = dto;
LoadDSLoaiTK();
}
public IActionResult GetThongTinDiaChi(string tendangnhap, string diachi)
{
DiaChiBUS dcbus = new DiaChiBUS();
TaiKhoanBUS tk = new TaiKhoanBUS();
DiaChi dc = dcbus.GetThongTinDiaChi(tendangnhap, diachi);
ViewBag.TinhThanh = tk.GetTinhThanhs();
return(PartialView("SuaDiaChiPartialView", dc));
}
public IActionResult ResetPassword(string key)
{
TaiKhoanBUS taikhoanbus = new TaiKhoanBUS();
TaiKhoan taikhoan = taikhoanbus.CheckTaiKhoanResetPassword(key);
List <HangSanPham> hang = ctx.HangSanPham.ToList();
ViewBag.Hang = hang;
return(View(taikhoan));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
gvDanhSach.DataSource = TaiKhoanBUS.LayDSTK();
gvDanhSach.DataBind();
gvDanhSach.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
public void Test_Login_Sai_Pass()
{
uBUS = new TaiKhoanBUS();
int expected = -2;
int actual = uBUS.DangNhapBUS("Long", "321");
Assert.AreEqual(expected, actual);
}
private void FrmDangNhap_Load(object sender, EventArgs e)
{
cmbTaiKhoan.DataSource = TaiKhoanBUS.LayDanhSachTaiKhoan();
cmbTaiKhoan.DisplayMember = "HoTen";
cmbTaiKhoan.ValueMember = "MaTaiKhoan";
txtMatKhau.Text = "123";
txtMatKhau.Select();
}
public void Test_Login_Sai_ID()
{
uBUS = new TaiKhoanBUS();
int expected = -1;
int actual = uBUS.DangNhapBUS("LongLong", "123");
Assert.AreEqual(expected, actual);
}
public void Test_LoginByQuanLy()
{
uBUS = new TaiKhoanBUS();
// 1 là Quản lý
int expected = 1;
int actual = uBUS.DangNhapBUS("Long", "123");
Assert.AreEqual(expected, actual);
}
public void Test_LoginByNhanVien()
{
uBUS = new TaiKhoanBUS();
// 2 là Nhân viên
int expected = 2;
int actual = uBUS.DangNhapBUS("Trai", "123");
Assert.AreEqual(expected, actual);
}
public void LoadDanhSachTK()
{
TaiKhoanBUS bus = new TaiKhoanBUS();
List <TaiKhoanDTO> tk = bus.LayDSTaiKhoan();
rpvBaoCao.LocalReport.ReportEmbeddedResource = "QuanLiCuaHangDoChoi.rptTheoDanhSachTK.rdlc";
rpvBaoCao.LocalReport.DataSources.Add(new ReportDataSource("dsTaiKhoan", tk));
rpvBaoCao.RefreshReport();
}
private void LoadDSNhanVien()
{
TaiKhoanBUS tk = new TaiKhoanBUS();
List <TaiKhoanDTO> lstk = tk.LayDSTaiKhoan();
cboTenDN.DataSource = lstk;
cboTenDN.DisplayMember = "TenDangNhap";
cboTenDN.ValueMember = "TenDangNhap";
}
private void FrmLichSuHoaDon_Load(object sender, EventArgs e)
{
dgvHoaDon.AutoGenerateColumns = false;
dgvCTHoaDon.AutoGenerateColumns = false;
lblNhanVienLap.Text += TaiKhoanBUS.LayThongTinTaiKhoan(TaiKhoanBUS.LayTaiKhoanDangNhap()).HoTen;
lblNgayLap.Text += DateTime.Now.ToShortDateString();
LoadDanhSachHoaDon();
}
public IActionResult GetDiaChi(string tendangnhap)
{
DiaChiBUS diachi = new DiaChiBUS();
TaiKhoanBUS tk = new TaiKhoanBUS();
List <DiaChi> list = diachi.GetDiaChis(tendangnhap);
ViewBag.TenDangNhap = tendangnhap;
ViewBag.TinhThanh = tk.GetTinhThanhs();
return(PartialView("DiaChiPartialView", list));
}
void XoaTaiKhoan()
{
TaiKhoanBUS.XoaTaiKhoan(taikhoan);
MessageBox.Show(TaiKhoanBUS.Message);
if (TaiKhoanBUS.isSucess)
{
LoadData();
ResetControls();
}
}
public void AddQuantity(string tendangnhap, string idsizesanpham, int quantity)
{
if (tendangnhap != null && tendangnhap != "")
{
TaiKhoanBUS taikhoanbus = new TaiKhoanBUS();
TaiKhoan taikhoan = taikhoanbus.CheckTaiKhoan(tendangnhap);
GioHangBUS giohangbus = new GioHangBUS();
giohangbus.AddQuantity(taikhoan.Id.ToString(), idsizesanpham, quantity);
}
}
bool check_email(string email)
{
if (TaiKhoanBUS.get_email_byEmail(txtEmail.Text).Rows.Count == 0)
{
return(true);
}
else
{
return(false);
}
}
public IActionResult DonMua(string tinhtrang)
{
if (tinhtrang == null || tinhtrang == "")
{
tinhtrang = "Chưa xử lý";
}
else
{
switch (tinhtrang)
{
case "danggiao":
tinhtrang = "Đang giao";
break;
case "dangxuly":
tinhtrang = "Đang xử lý";
break;
case "daxuly":
tinhtrang = "Đã xử lý";
break;
case "dahuy":
tinhtrang = "Đã huỷ";
break;
}
}
string sessionval = HttpContext.Session.GetString("TenDangNhap");
TaiKhoanBUS taikhoanbus = new TaiKhoanBUS();
TaiKhoan taikhoan = new TaiKhoan();
DonHangBUS donhangbus = new DonHangBUS();
List <DonHang> listdonhang = new List <DonHang>();
List <ChiTietDonHang> listchitietdonhang = new List <ChiTietDonHang>();
if (sessionval != "" && sessionval != null)
{
taikhoan = taikhoanbus.CheckTaiKhoan(sessionval);
listdonhang = donhangbus.GetDonHang(taikhoan.TenDangNhap, tinhtrang);
listchitietdonhang = donhangbus.GetChiTietDonHang(taikhoan.TenDangNhap, tinhtrang);
}
else
{
taikhoan = null;
listdonhang = null;
}
HangSanPhamBUS hangsanphambus = new HangSanPhamBUS();
List <HangSanPham> hang = hangsanphambus.GetHangSanPhams();
ViewBag.Hang = hang;
ViewBag.TaiKhoan = taikhoan;
ViewBag.ChiTietDonHang = listchitietdonhang;
return(View(listdonhang));
}
private void gridControlNhanVien_Load(object sender, EventArgs e)
{
gridControlTaiKhoan.DataSource = TaiKhoanBUS.getAll();
DataTable ds = new DataTable();
ds = TaiKhoanBUS.get_loainhanvien();
cboLoaiNV.DisplayMember = "TenLoaiNhanVien";
cboLoaiNV.ValueMember = "MaLoaiNV";
cboLoaiNV.DataSource = ds;
}
private void btn_dangnhap_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_tk.Text) || string.IsNullOrEmpty(txt_mk.Text))
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin");
return;
}
try
{
TaiKhoanDTO us = new TaiKhoanDTO();
us.TaiKhoan1 = txt_tk.Text;
us.MatKhau1 = txt_mk.Text;
if (txt_tk.Text == "1" && txt_mk.Text == "1")
{
MessageBox.Show("Tài khoản mật khẩu bị từ chối");
return;
}
TaiKhoanBUS bus = new TaiKhoanBUS();
DataTable k = bus.dangNhap(us);
if (k.Rows.Count > 0)
{
//gán các thông tin của người đăng nhập cho user
us.MaTK1 = k.Rows[0][1].ToString();
NhanVienBUS busNV = new NhanVienBUS();
DataTable nv = busNV.loadNhanViewDangNhap(us.MaTK1);
if (nv != null)
{
MessageBox.Show("Đăng nhập thành công");
frmGui f = new frmGui(new NhanVienDTO()
{
MaNV1 = nv.Rows[0][1].ToString(),
TenNV1 = nv.Rows[0][2].ToString(),
NgaySinh1 = DateTime.Parse(nv.Rows[0][3].ToString()),
GioiTinh1 = nv.Rows[0][4].ToString(),
DiaChi1 = nv.Rows[0][5].ToString(),
SDT1 = nv.Rows[0][6].ToString(),
Email1 = nv.Rows[0][7].ToString(),
MaTK1 = us.MaTK1,
GhiChu1 = nv.Rows[0][9].ToString()
});
this.Hide();
f.ShowDialog();//hiển thị form chính
}
}
else
{
MessageBox.Show("Tài khoản hoặc mật khẩu không chính xác");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
bool check_username(string username)
{
if (TaiKhoanBUS.get_user_byUsername(username).Rows.Count == 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnXoa_Click(object sender, EventArgs e)
{
if (TaiKhoanBUS.XoaTK(txtTenTK.Text))
{
load();
Response.Write("<script>alert('Xóa thành công')</script>");
}
else
{
Response.Write("<script>alert('Xóa thất bại')</script>");
}
}
//private string MaHoaMatKhau(string matKhau)
//{
// MD5 mh = MD5.Create();
// byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(matKhau);
// byte[] hash = mh.ComputeHash(inputBytes);
// StringBuilder sb = new StringBuilder();
// for (int i = 0; i < hash.Length; i++)
// {
// sb.Append(hash[i].ToString("x2"));
// }
// return sb.ToString();
//}
private void KiemTraDangNhap()
{
if (TaiKhoanBUS.KiemTraDangNhap((int)cmbTaiKhoan.SelectedValue, /*MaHoaMatKhau*/ (txtMatKhau.Text)))
{
((FrmMain)this.ParentForm).XuLyDangNhapThanhCong((int)cmbTaiKhoan.SelectedValue);
this.Close();
}
else
{
MessageBox.Show("Sai mật khẩu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
//
// Phương thức event khi nhấn In hoá đơn ở tab hoá đơn
//
private void BtnIn4_Click(object sender, EventArgs e)
{
int maNV = new TaiKhoanBUS().GetMaNV(_tenDN);
Khach kh = new Khach(-1, txtK4.Text, txtDC4.Text, txtSDT4.Text);
new KhachBUS().Add(kh);
int maKH = new KhachBUS().GetMaKH(txtK4.Text);
HDBan hdb = new HDBan(-1, maKH, maNV, dtNgTT4.Value, Convert.ToInt32(txtThanhTien4.Text));
new HDBanBUS().Add(hdb);
int maHDB = new ChiTietHDBanBUS().GetMaHDB(maKH, maNV);
try
{
for (int i = 0; i < gridData4.Rows.Count - 1; i++)
{
int maSP = new SanPhamBUS().GetMaSP(gridData4.Rows[i].Cells[0].Value.ToString());
int soLuong = Convert.ToInt32(gridData4.Rows[i].Cells[1].Value.ToString());
int tong = Convert.ToInt32(gridData4.Rows[i].Cells[3].Value.ToString());
ChiTietHDBan cthdb = new ChiTietHDBan(maHDB, maSP, soLuong, tong);
new ChiTietHDBanBUS().Add(cthdb);
}
MessageBox.Show("Đã lưu hoá đơn vào ổ đĩa D");
frmCryReport f = new frmCryReport
{
_tenKH = txtK4.Text,
_maHDB = maHDB,
_tenNV = new TaiKhoanBUS().GetTenNV(_tenDN),
_ngLap = dtNgTT4.Value,
_tongTien = txtThanhTien4.Text
};
f.Show();
}
catch
{
MessageBox.Show("Kiểm tra lại thông tin");
new HDBanBUS().Delete(maHDB.ToString());
new KhachBUS().Delete(kh);
int i = Convert.ToInt32(gridData2.Rows[gridData2.RowCount - 1].Cells[0].Value.ToString());
new KhachBUS().Reset(i);
gridData4.DataSource = new HDBanBUS().LoadHD();
gridData4.Refresh();
i = Convert.ToInt32(gridData3.Rows[gridData3.RowCount - 1].Cells[0].Value.ToString());
new SanPhamBUS().Reset(i);
}
}
public IActionResult EditTaiKhoan(string tendangnhap, string ten, string email, string dienthoai)
{
string checktendangnhap = HttpContext.Session.GetString("TenDangNhap");
if (checktendangnhap != null && checktendangnhap != "")
{
TaiKhoanBUS taikhoanbus = new TaiKhoanBUS();
string thongbao = taikhoanbus.EditTaiKhoan(tendangnhap, null, ten, null, email, dienthoai, null);
return(RedirectToAction("Index", "Home", new { thongbao = thongbao }));
}
return(RedirectToAction("Index", "Home"));
}
public string EditThongTin(string tendangnhap, string email, string sdt)
{
string checktendangnhap = HttpContext.Session.GetString("TenDangNhap");
if (checktendangnhap != null && checktendangnhap != "")
{
TaiKhoanBUS taikhoanbus = new TaiKhoanBUS();
string thongbao = taikhoanbus.EditTaiKhoan(tendangnhap, null, null, null, email, sdt, null);
return(thongbao);
}
return("");
}
private void btnLamMoi_Click(object sender, EventArgs e)
{
tkDTO = null;
XuLyAnHienButton(true);
DuaDuLieuChoThongTinTaiKhoan();
string tenTK = ((frmMain)this.ParentForm).getTenTK();
if (tenTK == TaiKhoanBUS.PhanQuyenQuanLyTK(1))
{
radQuanLy.Checked = true;
}
}
private void LoadDSTaiKhoan()
{
if (chkTaiKhoanBiXoa.Checked == false)
{
dgvDSTaiKhoan.DataSource = TaiKhoanBUS.LayDSTaiKhoan();
}
else
{
dgvDSTaiKhoan.DataSource = TaiKhoanBUS.LayDSTaiKhoanBiXoa();
}
dgvDSTaiKhoan.CurrentCell = null;
}
private void txtTimKiemTK_TextChanged(object sender, EventArgs e)
{
if (txtTimKiemTK.Text == "")
{
LoadDSTaiKhoan();
}
else
{
string tKiem = "%" + txtTimKiemTK.Text + "%";
dgvDSTaiKhoan.DataSource = TaiKhoanBUS.TimKiemTaiKhoan(tKiem);
}
}
public void Test_AddUser_Suscess()
{
userBUS = new TaiKhoanBUS();
user = new TaiKhoan();
user.TenTaiKhoan = "Hoa";
user.MatKhau = "123";
user.ChucVu = "Nhân viên";
user.MaNV = 13;
userBUS.AddUserBUS(user);
Assert.AreEqual(8, userBUS.LoadUserBUS().Count);
}
void LoadTK()
{
taiKhoanBindingSource.DataSource = TaiKhoanBUS.GetAllTK();
comboBoxUser.DataSource = TaiKhoanBUS.GetAllTK();
comboBoxUser.DisplayMember = "UserName";
comboBoxUser.ValueMember = "UserName";
comboBoxMaCHUser.DataSource = CuaHangBUS.GetAllCuaHang();
comboBoxMaCHUser.DisplayMember = "TenCuaHang";
comboBoxMaCHUser.ValueMember = "MaCuaHang";
comboBoxLoaiTK.DataSource = LoaiTaiKhoanBUS.GetAllLoaiTaiKhoan();
comboBoxLoaiTK.DisplayMember = "TenLoaiTK";
comboBoxLoaiTK.ValueMember = "MaLoaiTK";
}
