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