public bool ThemLichSuNguoiDung(LichSuNguoiDungDTO ls) { string insert = "INSERT INTO LICHSUNGUOIDUNGHETHONG" + " (MAHD" + " ,MAND" + " ,MANV" + " ,THOIGIAN" + " ,SUKIEN)" + " VALUES" + " (@MAHD" + ",@MAND" + ",@MANV" + " ,@THOIGIAN" + " ,@SUKIEN)"; ls.MAHD = MaHanhDongMoi(); List <SqlParameter> lsparams = new List <SqlParameter>(); lsparams.Add(new SqlParameter("@MAHD", ls.MAHD)); lsparams.Add(new SqlParameter("@MAND", ls.MAND)); lsparams.Add(new SqlParameter("@MANV", ls.MANV)); lsparams.Add(new SqlParameter("@THOIGIAN", ls.THOIGIAN)); lsparams.Add(new SqlParameter("@SUKIEN", ls.SUKIEN)); SqlConnection con = DataProvider.TaoKetNoi(); bool thucthi = DataProvider.ThucThi(insert, lsparams.ToArray(), con); return(thucthi); }
private void nHÂNVIÊNToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Quản Lý Nhân Viên" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); DongFrmCon(); f1 = new FrmQLNhanVien(); f1.MdiParent = this; f1.Dock = DockStyle.Fill; f1.Show(); }
private void hOAĐƠNToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Đặt Phòng" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); DongFrmCon(); f9 = new FrmQLHoaDon(); f9.MdiParent = this; f9.Dock = DockStyle.Fill; f9.Show(); }
private void bAOCAOToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Báo Cáo Thống Kê" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); DongFrmCon(); f6 = new FrmThongKe(); f6.MdiParent = this; f6.Dock = DockStyle.Fill; f6.Show(); }
private void kHACHHANGToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Quản Lý Khách Hàng" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); DongFrmCon(); f8 = new FrmQLKHACHHANG(); f8.MdiParent = this; f8.Dock = DockStyle.Fill; f8.Show(); }
public void XetTruyCap(int lOAIND) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Đăng nhập hệ thống" }; lsNDBUS = new LichSuNguoiDungBUS(); bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); menuStrip1.Enabled = true; tAIKHOANCUATÔIToolStripMenuItem.Text = nvDangNhap.TAIKHOAN.Trim(); if (lOAIND == 2) { kHACHHANGToolStripMenuItem.Enabled = true; hOAĐƠNToolStripMenuItem.Enabled = true; tHƯCĐƠNToolStripMenuItem.Enabled = true; pHONGToolStripMenuItem.Enabled = true; nHÂNVIÊNToolStripMenuItem.Enabled = false; tAIKHOANNGƯƠIDUNGToolStripMenuItem.Enabled = false; bAOCAOToolStripMenuItem.Enabled = false; lịchSửHoạtĐộngToolStripMenuItem.Enabled = false; } else if (lOAIND == 1) { kHACHHANGToolStripMenuItem.Enabled = true; hOAĐƠNToolStripMenuItem.Enabled = true; tHƯCĐƠNToolStripMenuItem.Enabled = true; pHONGToolStripMenuItem.Enabled = true; nHÂNVIÊNToolStripMenuItem.Enabled = true; tAIKHOANNGƯƠIDUNGToolStripMenuItem.Enabled = true; bAOCAOToolStripMenuItem.Enabled = true; } else { menuStrip1.Enabled = true; } đĂNGNHÂPToolStripMenuItem.Visible = false; đĂNGXUÂTToolStripMenuItem.Visible = true; }
private void tAIKHOANNGƯƠIDUNGToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Quản Lý Tài Khoản" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); lsNDBUS = new LichSuNguoiDungBUS(); DongFrmCon(); f2 = new FrmQLTaiKhoan(); f2.MdiParent = this; f2.Dock = DockStyle.Fill; f2.Show(); }
private void pHONGToolStripMenuItem_Click(object sender, EventArgs e) { lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Quản Lý Phòng" }; bool kt = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); DongFrmCon(); f5 = new FrmQLPhong(); f5.MdiParent = this; f5.Dock = DockStyle.Fill; f5.FormBorderStyle = FormBorderStyle.None; f5.StartPosition = FormStartPosition.CenterScreen; f5.Show(); }
private void đĂNGXUÂTToolStripMenuItem_Click(object sender, EventArgs e) { DongFrmCon(); lsNDDTO = new LichSuNguoiDungDTO() { MAND = nvDangNhap.MAND, MANV = nvDangNhap.MANV, THOIGIAN = DateTime.Parse(DateTime.Now.ToString("dd/MM/yyy HH:mm")), SUKIEN = "Đăng Xuất Khỏi Hệ Thống" }; try { List <LichSuNguoiDungDTO> LichSuSauMotNgay = lsNDBUS.DSLichSuHoatDong().FindAll(o => o.THOIGIAN.Day < lsNDDTO.THOIGIAN.Day); if (LichSuSauMotNgay != null) { lsNDBUS.GhiFile(LichSuSauMotNgay, Utils.MaHoaMD5(LichSuSauMotNgay[LichSuSauMotNgay.Count() - 1].THOIGIAN.ToString())); } bool ktls = lsNDBUS.ThemLichSuNguoiDung(lsNDDTO); } catch { } dn = null; f1 = null; FrmDangNhap fdn = new FrmDangNhap(); fdn.MdiParent = this; fdn.Dock = DockStyle.Fill; fdn.FormBorderStyle = FormBorderStyle.None; fdn.StartPosition = FormStartPosition.CenterScreen; fdn.Show(); đĂNGXUÂTToolStripMenuItem.Visible = false; menuStrip1.Enabled = false; tAIKHOANCUATÔIToolStripMenuItem.Text = "TÀI KHOẢN CỦA TÔI"; }
public List <LichSuNguoiDungDTO> DanhSachLichSuNguoiDung() { List <LichSuNguoiDungDTO> ds = new List <LichSuNguoiDungDTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); string sql = "select * from LICHSUNGUOIDUNGHETHONG"; SqlDataReader sdr = DataProvider.TruyVanDuLieu(sql, conn); while (sdr.Read()) { LichSuNguoiDungDTO a = new LichSuNguoiDungDTO() { MAHD = sdr.GetInt32(0), MAND = sdr.GetString(1), MANV = sdr.GetString(2), THOIGIAN = DateTime.Parse(sdr.GetDateTime(3).ToString("dd/MM/yyyy HH:mm")), SUKIEN = sdr.GetString(4), }; ds.Add(a); } sdr.Close(); conn.Close(); return(ds); }
public bool ThemLichSuNguoiDung(LichSuNguoiDungDTO ls) { LichSuNguoiDungDAO a = new LichSuNguoiDungDAO(); return(a.ThemLichSuNguoiDung(ls)); }