public static bool kt_dangnhap(string ten, string matkhau) { //Lnhanvien nv = new Lnhanvien(); try { KTdangnhap P = new KTdangnhap(); DataSet ds1 = P.ds; ketnoi.ThietlapketNoi(); laydulieu dl = new laydulieu(); ds1 = dl.getdata("select * from nhanvien where matkhau = '" + matkhau + "' and tendangnhap = '" + ten + "'"); if (ds1.Tables[0].Rows.Count == 0) { ketnoi.HuyKetNoi(); return(false); } else { strmanhanvien = ds1.Tables[0].Rows[0]["manhanvien"].ToString(); strhoten = ds1.Tables[0].Rows[0]["hoten"].ToString(); strdiachi = ds1.Tables[0].Rows[0]["diachi"].ToString(); strnguoidung = ds1.Tables[0].Rows[0]["tendangnhap"].ToString(); strquyenhan = ds1.Tables[0].Rows[0]["quyenhan"].ToString(); strmatkhau = ds1.Tables[0].Rows[0]["matkhau"].ToString(); ketnoi.HuyKetNoi(); return(true); } } catch { return(false); } }
public bool kt_dangnhap(string ten, string matkhau, string tenserver) { //Lnhanvien nv = new Lnhanvien(); try { if (tenserver != "") { ketnoi.strcon = ketnoi.strcon + "; server= " + tenserver; } ketnoi.ThietlapketNoi(); laydulieu dl = new laydulieu(); ds = dl.getdata("select * from nhanvien where matkhau = '" + matkhau + "' and tendangnhap = '" + ten + "'"); if (ds.Tables[0].Rows.Count == 0) { ketnoi.HuyKetNoi(); return(false); } else { strmanhanvien = ds.Tables[0].Rows[0]["manhanvien"].ToString(); strhoten = ds.Tables[0].Rows[0]["hoten"].ToString(); strdiachi = ds.Tables[0].Rows[0]["diachi"].ToString(); strnguoidung = ds.Tables[0].Rows[0]["tendangnhap"].ToString(); strquyenhan = ds.Tables[0].Rows[0]["quyenhan"].ToString(); strmatkhau = ds.Tables[0].Rows[0]["matkhau"].ToString(); ketnoi.HuyKetNoi(); return(true); } } catch { return(false); } }
public static bool kt_nhapSoPhongDoi(string SoPhongDoi) { try { if (SoPhongDoi == "") { return(true); } DataSet ds1 = new DataSet(); ketnoi.ThietlapketNoi(); laydulieu dl = new laydulieu(); ds1 = dl.getdata("insert into khachhang(phongdon)values('" + SoPhongDoi + "')"); return(false); } catch { return(true); } }
public static bool kt_nhapTGThue(string TGThue) { try { if (TGThue == "") { return(true); } DataSet ds1 = new DataSet(); ketnoi.ThietlapketNoi(); laydulieu dl = new laydulieu(); ds1 = dl.getdata("insert into khachhang(songay)values('" + TGThue + "')"); return(false); } catch { return(true); } }
public static bool kt_trungmacheckin(string macheckin) { try { DataSet ds1 = new DataSet(); ketnoi.ThietlapketNoi(); laydulieu dl = new laydulieu(); ds1 = dl.getdata("select * from checkin where macheckin = '" + macheckin + "' "); if (ds1.Tables[0].Rows.Count == 0) { ketnoi.HuyKetNoi(); return(true); } else { MessageBox.Show("Mã check in đã tồn tại!", "Chú ý"); ketnoi.HuyKetNoi(); return(false); } } catch { return(true); } }