public System.Data.Linq.Table <EmployeeType> LoadEmployeeType()
{
DataSet ds = new DataSet();
HotelManagementDataContext hm = new HotelManagementDataContext();
return(hm.EmployeeTypes);
}
public bool Checkout(int RoomID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_CheckOut(RoomID);
return(true);
}
catch
{
return(false);
}
}
public bool Checkin(string CustomerID, string RoomID, string EmployeeID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_CheckIn(Convert.ToInt32(CustomerID), Convert.ToInt32(RoomID), Convert.ToInt32(EmployeeID));
return(true);
}
catch
{
return(false);
}
}
public bool UpdateRoom(int RoomID, string RoomTypeID, string OnFloor, int Status)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateRooms(RoomID, Convert.ToByte(RoomTypeID), Convert.ToInt32(OnFloor), Status);
db.Rooms.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteCustomer(string CustomerID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteCustomers(Convert.ToInt32(CustomerID));
db.Customers.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateCustomer(string CustomerID, string CustomerName, string IdentityCard, string PhoneNumber, string CustomerAddress)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateCustomers(Convert.ToInt32(CustomerID), CustomerName, IdentityCard, PhoneNumber, CustomerAddress);
db.Customers.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateInvoice(string InvoiceID, string CustomerID, string RoomID, string EmployeeID, string InvoiceTotal, string CheckInDate, string CheckOutDate, bool HasPaid)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateInvoices(Convert.ToInt32(InvoiceID), Convert.ToInt32(CustomerID), Convert.ToInt32(RoomID), Convert.ToInt32(EmployeeID), Convert.ToDecimal(InvoiceTotal), Convert.ToDateTime(CheckInDate), Convert.ToDateTime(CheckOutDate), HasPaid);
db.Invoices.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteRoom(int RoomID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteRooms(RoomID);
db.Rooms.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteInvoice_Service(int Invoices_Services_ID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteInvoices_Services(Invoices_Services_ID);
db.Invoices_Services.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateEmployee(int EmployeeID, string EmployeeName, string EmployeeTypeID, string PhoneNumber, string IdentityCard, string PassWord)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateEmployees(EmployeeID, EmployeeName, Convert.ToByte(EmployeeTypeID), PhoneNumber, IdentityCard, PassWord);
db.Employees.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateEmployeeType(int EmployeeTypeID, string Name)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateEmployeeTypes(Convert.ToByte(EmployeeTypeID), Name);
db.EmployeeTypes.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool CreateRoomType(string Name, string Price)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_CreateRoomTypes(Name, Convert.ToDecimal(Price));
db.RoomTypes.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateRoomType(int RoomTypeID, string Name, string Price)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateRoomTypes(Convert.ToByte(RoomTypeID), Name, Convert.ToDecimal(Price));
db.RoomTypes.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteBooking(string BookingID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteBooking(Convert.ToInt32(BookingID));
db.Bookings.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool CreateEmployeeType(string Name)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_CreateEmployeeTypes(Name);
db.EmployeeTypes.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateBooking(string BookingID, string CustomerID, string RoomID, string AppointmentDate)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateBooking(Convert.ToInt32(BookingID), Convert.ToInt32(CustomerID), Convert.ToByte(RoomID), Convert.ToDateTime(AppointmentDate));
db.Bookings.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteRoomType(string RoomTypeID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteRoomTypes(Convert.ToByte(RoomTypeID));
db.RoomTypes.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteHotelService(string ServiceID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteHotelServices(Convert.ToInt32(ServiceID));
db.HotelServices.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateInvoice_Service(int Invoices_Services_ID, string InvoiceID, string ServiceID, string Times)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateInvoices_Services(Invoices_Services_ID, Convert.ToInt32(InvoiceID), Convert.ToInt32(ServiceID), Convert.ToInt32(Times));
db.Invoices_Services.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateHotelService(string ServiceID, string ServiceName, string Price)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_UpdateHotelServices(Convert.ToInt32(ServiceID), ServiceName, Convert.ToDecimal(Price));
db.HotelServices.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool DeleteEmployee(int EmployeeID)
{
try
{
HotelManagementDataContext db = new HotelManagementDataContext();
db.sp_DeleteEmployees(EmployeeID);
db.Employees.Context.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
private void btn_Redo_Click(object sender, EventArgs e)
{
HotelManagementDataContext db = new HotelManagementDataContext();
if (TabControl_Main.SelectedTab == TabPage_Room)
{
db.sp_Redo_Rooms();
db.Rooms.Context.SubmitChanges();
btn_Room_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_RoomType)
{
db.sp_Redo_RoomTypes();
db.RoomTypes.Context.SubmitChanges();
btn_RoomType_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_Customer)
{
db.sp_Redo_Customers();
db.Customers.Context.SubmitChanges();
btn_Customer_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_Employee)
{
db.sp_Redo_Employees();
db.Employees.Context.SubmitChanges();
btn_Employee_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_EmployeeType)
{
db.sp_Redo_EmployeeTypes();
db.EmployeeTypes.Context.SubmitChanges();
btn_EmployeeType_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_Service)
{
db.sp_Redo_HotelServices();
db.HotelServices.Context.SubmitChanges();
btn_Service_Click(null, null);
}
if (TabControl_Main.SelectedTab == TabPage_Invoice_Service)
{
db.sp_Redo_Invoices_Services();
db.Invoices_Services.Context.SubmitChanges();
btn_InvoiceService_Click(null, null);
}
}
public System.Data.Linq.Table <Invoices_Service> LoadInvoice_Service()
{
HotelManagementDataContext hm = new HotelManagementDataContext();
return(hm.Invoices_Services);
}
public System.Collections.Generic.List <sp_OutDateBookingResult> OutdateBooking()
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.sp_OutDateBooking().ToList());
}
public System.Collections.Generic.List <fn_FindBookingResult> FindBooking(int roomid)
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.fn_FindBooking(roomid).ToList());
}
public System.Data.Linq.Table <Booking> LoadBooking()
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.Bookings);
}
public System.Data.Linq.Table <RoomType> LoadRoomType()
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.RoomTypes);
}
public System.Data.Linq.Table <HotelService> LoadHotelService()
{
HotelManagementDataContext hm = new HotelManagementDataContext();
return(hm.HotelServices);
}
public System.Collections.Generic.List <sp_FindInvoiceServicePriceResult> LoadCheckOutInvoiceService(int RoomID)
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.sp_FindInvoiceServicePrice(RoomID).ToList());
}
public System.Collections.Generic.List <HotelManagement.Data_Layer.sp_FindRoomResult> FindRoom(int RoomID)
{
HotelManagementDataContext db = new HotelManagementDataContext();
return(db.sp_FindRoom(RoomID).ToList());
}
