public static bool Login(string tenDangNhap, string matKhau) { int user = 0; NHAN_VIEN tmp; try { user = Convert.ToInt32(tenDangNhap); } catch (Exception) { user = 0; } try { tmp = NHAN_VIEN.select(" where MSNV = " + user + " and TRANG_THAI > 0 ")[0]; } catch (Exception) { tmp = null; } if (tmp != null && tmp.MAT_KHAU == matKhau) { Init.nhanVien = tmp; return(true); } return(false); }
// Employee leave public static bool SaThaiNhanVien(int msnv, string ghiChu) { LichSuNhanVien.SaThaiNhanVien(msnv, ghiChu); NHAN_VIEN nv = NHAN_VIEN.select(" where MSNV = " + msnv)[0]; nv.TRANG_THAI = 0; NHAN_VIEN.update(nv); return(true); }
// Get Position of Employee public static int getChucVu(int user) { try { return(NHAN_VIEN.select(" where MSNV = " + user + " ")[0].MSNV); } catch (Exception) { return(0); } }
public static NHAN_VIEN LayNhanVien(int msnv) { try { return(NHAN_VIEN.select(" where MSNV = " + msnv + " and TRANG_THAI = 1 ")[0]); } catch (Exception) { return(null); } }
public static string LayHoTen(int MSNV) { try { return(NHAN_VIEN.select(" where MSNV = " + MSNV + " ")[0].HO_TEN); } catch (Exception) { return(""); } }
public static List <NHAN_VIEN> LayNhanVien() { return(NHAN_VIEN.select(" where TRANG_THAI = 1 ")); }