public String AddEmployeesToHotel(UserTypes.Employee emp) { if (hotelInstance == null) { return("hotel instance not initiated"); } else { return(runQuery(constructQuery(emp))); } }
private void Button_Add_HotelEmp_Click(object sender, EventArgs e) { UserTypes.Employee Emp = new UserTypes.Employee(); Emp.Addr = Hotel_Staff_Address.Text; Emp.Date_Of_Birth = Hotel_Staff_DOB.Text; Emp.Email = Hotel_Staff_EmailAddresss.Text; Emp.First_Name = Hotel_Staff_First_Name.Text; Emp.Last_name = Hotel_Staff_LastName.Text; Emp.Hotel_ID = Int32.Parse(Hotel_id.Text); Emp.Staff_Id = Int32.Parse(Hotel_Staff_ID.Text); Emp.Phone_Num = Int32.Parse(Hotel_Staff_PhoneNum.Text); AdminHotelListManipulationClass HMInstance = new AdminHotelListManipulationClass(); string log = HMInstance.AddEmployeesToHotel(Emp); MessageBox.Show(log); }
private string constructQuery(object queryObject) { if (queryObject is TableTypes.Hotel) { TableTypes.Hotel hotel = (TableTypes.Hotel)queryObject; return("insert into Hotel(Hotel_Id, HotelName, Addrs, City, Phone_no)" + "values('" + hotelInstance.Hotel_Id + "', '" + hotelInstance.Name + "', '" + hotelInstance.Addr + "', '" + hotelInstance.Addr + "'," + hotelInstance.Phone_Num + ");"); } if (queryObject is UserTypes.Employee) { UserTypes.Employee employee = (UserTypes.Employee)queryObject; return("insert into Employee( Staff_Id,First_name , Last_name , DOB , Addrs , Phone_no , Email , Pass , Hotel_Id )" + "values('" + employee.Staff_Id + "','" + employee.First_Name + "', '" + employee.Last_name + "', '" + employee.Date_Of_Birth + "', '" + employee.Addr + "', '" + employee.Phone_Num + "', '" + employee.Email + "', '" + employee.Pass + "'," + hotelInstance.Hotel_Id + ")"); } if (queryObject is TableTypes.Room) { TableTypes.Room room = (TableTypes.Room)queryObject; return("insert into Room (Room_Id ,Hotel_ID ,Room_Type ,Room_Description)" + "values(" + room.Room_Id + "," + hotelInstance.Hotel_Id + ", '" + room.Room_Type + "', '" + room.Room_Description + "')"); } return(""); }