public static int AddNewStaff(string name, string user, string pass, DateTime birthday, bool sex, string addr, string phone, string idNo, bool position, DateTime startDate, int salary, string note) { string EncryptPass = Account.Encrypt(pass); return(ExecuteQuery.ExecuteNoneQuery("QLKS_AddNewStaff @Name , @Username , @Password , @Birthday , @Sex , @Addr , @PhoneNumber , @IdentityNumber , @Position , @StartingDate , @Salary , @Note", new object[] { name, user, EncryptPass, birthday, sex, addr, phone, idNo, position, startDate, salary, note })); }
public static int InsertNewRoomReservation(DateTime ArrivalDate, int CustomerID, string Username, int DownPayment = 0, string Note = null) { string query = "QLKS_InsertNewRoomReservation @ArrivalDate , @CustomerID , @Username , @DownPayment , @Note"; return(ExecuteQuery.ExecuteNoneQuery(query, new object[] { ArrivalDate, CustomerID, Username, DownPayment, Note })); }
public static int InsertRoomReservationDetail(int RoomReservationID, int RoomID) { string query = "QLKS_InsertRoomReservationDetail @RoomReservationID , @RoomID"; return(ExecuteQuery.ExecuteNoneQuery(query, new object[] { RoomReservationID, RoomID })); }
public static int InsertNewCustomer(string Name, DateTime Birthday, string IdeNum, string Passport, string Addr, string Phone, Sex sex) { string query = "QLKS_InsertNewCustomer @Name , @Birthday , @IdentityNumber , @Passport , @Addr , @PhoneNumber , @Sex"; return(ExecuteQuery.ExecuteNoneQuery(query, new object[] { Name, Birthday, IdeNum, Passport, Addr, Phone, sex })); }
public static int ChangePassword(string Username, string oldPass, string newPass) { string EncryptedOldPass = Encrypt(oldPass); string EncryptedNewPass = Encrypt(newPass); return(ExecuteQuery.ExecuteNoneQuery("QLKS_ChangePassword @Username , @OldPassword , @NewPassword", new object[] { Username, EncryptedOldPass, EncryptedNewPass })); }
public static int ChangeReservationInfo(int RoomID, string Name, DateTime Birthday, string Phone, Sex sex, string IdeNum, string Passport, string Addr, DateTime ArrivalDate, string Note = null) { string query = "QLKS_ChangeReservationInfo @RoomID , @Name , @Birthday , @Phone , @Sex , @IdeNum , @Passport , @Addr , @Note , @ArrivalDate"; return(ExecuteQuery.ExecuteNoneQuery(query, new object[] { RoomID, Name, Birthday, Phone, sex, IdeNum, Passport, Addr, Note, ArrivalDate })); }
public static int RemoveService(int id) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_RemoveService @ID", new object[] { id })); }
public static int AddNewService(ServiceType serviceTypeID, string name, int price) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_AddNewService @ServiceTypeID , @Name , @Price", new object[] { serviceTypeID, name, price })); }
public static int InsertServiceToServicesBillOnlyDetail(int ServiceID, int Count) { string Query = "QLKS_InsertServiceIntoServicesBillOnlyDetail @ServiceID , @ServiceCount"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { ServiceID, Count })); }
public static int Payment(int BillID, int RoomReservation, int RoomID, string Username) { string Query = "QLKS_Payment @BillID , @RoomeReservationID , @RoomID , @Username"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { BillID, RoomReservation, RoomID, Username })); }
public static int AddNewRoom(RoomType roomType, int area) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_AddNewRoom @RoomTypeID , @Area", new object[] { roomType, area })); }
public static int SetRoomStatus(int RoomID, RoomStatus status) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_SetRoomStatus @ID , @Status_", new object[] { RoomID, status })); }
public static int EditRoomInfo(int RoomID, RoomType roomType, int Area, int Price) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_EditRoom @RoomID , @RoomTypeID , @Area , @Price", new object[] { RoomID, roomType, Area, Price })); }
public static int PayForServicesOnly() { string Query = "QLKS_PayForServices"; return(ExecuteQuery.ExecuteNoneQuery(Query)); }
public static int InsertNewServicesBillOnly(string Username) { string Query = "QLKS_InsertNewServicesBillOnly @Username"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { Username })); }
public static int SetStaffInfo(int ID, string name, DateTime birthday, bool sex, string addr, string phone, string idNo, bool position, DateTime startDate, int salary, string note) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_SetStaffInfo @ID , @Password , @Birthday , @Sex , @Addr , @PhoneNumber , @IdentityNumber , @Position , @StartingDate , @Salary , @Note", new object[] { ID, name, birthday, sex, addr, phone, idNo, position, startDate, salary, note })); }
public static int RemoveStaff(int ID) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_RemoveStaff @StaffID", new object[] { ID })); }
public static int InsertNewBill(int RoomReservationID, string Username) { string Query = "QLKS_InsertNewBill @RoomReservationID , @Username"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { RoomReservationID, Username })); }
public static int SetServiceInfo(int id, string name, int price) { return(ExecuteQuery.ExecuteNoneQuery("QLKS_SetServiceInfo @ID , @Name , @Price", new object[] { id, name, price })); }
public static int SetRoomReservationStatus(int BillID, int RoomReservation, int RoomID) { string Query = "QLKS_SetRoomReservationStatus @BillID , @RoomeReservationID , @RoomID"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { BillID, RoomReservation, RoomID })); }
public static int InsertServicetoBillDetail(int RoomID, int ServiceID, int Count) { string Query = "QLKS_InsertServiceIntoBillDetail @RoomID , @ServiceID , @ServiceCount"; return(ExecuteQuery.ExecuteNoneQuery(Query, new object[] { RoomID, ServiceID, Count })); }