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));
}
