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