public static bool Login(string Username, string Password) { string EncryptedPass = Encrypt(Password); DataTable data = ExecuteQuery.ExecuteReader("QLKS_SearchAccount @Username , @Password", new object[] { Username, EncryptedPass }); return(data.Rows.Count == 1); }
public static DataTable GetBillDetailInfo(int BillID, int RoomReservation, int RoomID) { string Query = "QLKS_GetBillDetailInfo @BillID , @RoomeReservationID , @RoomID"; return(ExecuteQuery.ExecuteReader(Query, new object[] { BillID, RoomReservation, RoomID })); }
public static DataTable GetCustomerInfo(int RoomID) { ///return Name, birthday, PhoneNumber, Sex, IdentityNumber, Passport, Addr, Note, ArrivalDate return(ExecuteQuery.ExecuteReader("QLKS_GetCustomerInfo @ID", new object[] { RoomID })); }
public static DataTable GetStaffInfor(string Username) { return(ExecuteQuery.ExecuteReader("QLKS_GetStaffInfo @Username", new object[] { Username })); }
public static DataTable GetAllStaffInfo(int sortIndex) { return(ExecuteQuery.ExecuteReader("QLKS_GetAllStaffInfo @Sort", new object[] { sortIndex })); }
public static DataTable GetLaudryServiceRevenue(int RevenueType, DateTime FromDate, DateTime ToDate) { return(ExecuteQuery.ExecuteReader("QLKS_GetLaudryServiceRevenue @RevenueType , @FromDate , @ToDate", new object[] { RevenueType, FromDate, ToDate })); }
public static DataTable GetAllServicesBillOnlyInfo(DateTime FromDate, DateTime ToDate, int staffID, int sort) { return(ExecuteQuery.ExecuteReader("QLKS_GetAllServicesBillOnlyInfo @FromDate , @ToDate , @StaffID , @Sort", new object[] { FromDate, ToDate, staffID, sort })); }
public static DataTable GetBillInfoOfCustomer(int customerID) { return(ExecuteQuery.ExecuteReader("QLKS_GetBillInfoOfCustomer @CustomerID", new object[] { customerID })); }
public static DataTable GetServiceIdOfNewService() { return(ExecuteQuery.ExecuteReader("QLKS_GetServiceIdOfNewService")); }
public static DataTable GetStaffIdOfNewStaff() { return(ExecuteQuery.ExecuteReader("QLKS_GetStaffIdOfNewStaff")); }
public static DataTable GetAllCustomer(int sort) { return(ExecuteQuery.ExecuteReader("QLKS_GetAllCustomer @Sort", new object[] { sort })); }
public static DataTable GetData(int BillID) { return(ExecuteQuery.ExecuteReader("QLKS_GetAdditionalInfoForBillViewing @BillID", new object[] { BillID })); }
public static DataTable GetRoomInfo(int IDRoom) { return(ExecuteQuery.ExecuteReader("QLKS_GetRoomInfo @ID", new object[] { IDRoom })); }
public static DataTable GetRoomIdOfNewRoom() { return(ExecuteQuery.ExecuteReader("QLKS_GetRoomIdOfNewRoom")); }
public static DataTable GetServicesInfo(ServiceType type) { return(ExecuteQuery.ExecuteReader("QLKS_GetServiceInfo @SeviceType", new object[] { type })); }
public static DataTable GetServiceBillOnlyDetail(int SvcBillID) { return(ExecuteQuery.ExecuteReader("QLKS_GetServicesBillOnlyDetailInfo @ServiceBillID", new object[] { SvcBillID })); }