public static Booking RetriveBookingByCustomer(string CustomerId) { Booking B_details = new Booking(); B_details = HRSData.GetBookingDetailsCustomer(CustomerId); return(B_details); }
public static Booking RetriveBooking(string BookingId) { Booking B_details = new Booking(); B_details = HRSData.GetBookingDetails(BookingId); return(B_details); }
public static string AddCustomer(string C_Name, long C_Contact, string C_email, DateTime C_Dob, int C_PinCode, string C_State, string C_City, string C_Pwd) { Customer CustAdd = new Customer(); CustAdd.name = C_Name; CustAdd.c_contact = C_Contact; CustAdd.c_email = C_email; CustAdd.Dob = C_Dob; CustAdd.pincode = C_PinCode; PinCode pin = new PinCode(); pin.city = C_City; pin.state = C_State; pin.pin = C_PinCode; CustAdd.PinCode1 = pin; CustAdd.password = C_Pwd; string AddCust_res = HRSData.AddCustomer(CustAdd); string alert; if (AddCust_res.CompareTo("no_C_Id") == 0) { alert = "Customer Not Added"; } else { alert = AddCust_res.ToString(); } return(alert); }
public static Customer RetriveCustomer(string cus_id) { Customer cus = new Customer(); cus = HRSData.GetCustomer(cus_id); return(cus); }
public static string UpdateBooking(string BookingId, int No_Of_Ac_Rooms, int No_Of_Non_Ac_Rooms, int No_Of_Adults, int No_Of_Children, DateTime Date_Of_ChekInn, DateTime Date_Of_CheckOut) { string result; result = HRSData.UpdateBookingDetails(BookingId, No_Of_Ac_Rooms, No_Of_Non_Ac_Rooms, No_Of_Adults, No_Of_Children, Date_Of_ChekInn, Date_Of_CheckOut); return(result); }
public static string AddHotel(string name, string hotelDesrp, int pincode, string country, string city, string ManagerId, int No_AC_Rooms, int No_Non_AC_Rooms, int price_ac_adult, int price_ac_child, int price_nonac_adult, int price_nonac_child) { string HotelID = HRSData.AddHoteldataLayer(name, hotelDesrp, pincode, country, city, ManagerId, No_AC_Rooms, No_Non_AC_Rooms); HRSData.acroom(HotelID, price_ac_adult, price_ac_child); HRSData.nonacroom(HotelID, price_nonac_adult, price_nonac_child); return(HotelID); }
public static Hotel RetriveHotel(string hotel_id, out int cost_ac_adult, out int cost_ac_child, out int cost_non_ac_adult, out int cost_non_ac_child) { Hotel R_id = new Hotel(); R_id = HRSData.RetriveHotels(hotel_id); DataLayer.HRSData.FindPrice(hotel_id, out cost_ac_adult, out cost_ac_child, out cost_non_ac_adult, out cost_non_ac_child); return(R_id); }
public static int EmailVerify(string Email) { int result = 1; int a = HRSData.AuthorizeCustomerEmail(Email); int b = HRSData.AuthorizeManagerEmail(Email); if (a == 0 && b == 0) { result = 0; } return(result); }
public static string AddPayment(string hotel_id, string customer_id, string booking_name, int cost, int ccn, string type) { Payment p = new Payment(); p.customer_Id = customer_id; p.Hotel_id = hotel_id; p.booking_name = booking_name; p.total_Cost = cost; p.card_number = ccn; p.card_type = type; string res = HRSData.savepaymentdetails(p); return(res); }
public static string UpdateManger(string M_id, string M_Name, string M_Pwd, long M_Contact, string M_email) { Manager ManAdd = new Manager(); ManAdd.id = M_id; ManAdd.name = M_Name; ManAdd.password = M_Pwd; ManAdd.m_contact = M_Contact; ManAdd.m_email = M_email; string UpMan_res = HRSData.UpdateManager(ManAdd); return(UpMan_res); }
public static string AuthrizeCard(string bankid, int ccn, string ctype, string name, DateTime date, int cvc, int ano, int pin) { Card_details Cd = new Card_details(); Cd.Bank_id = bankid; Cd.card_no = ccn; Cd.card_type = ctype; Cd.name_on_card = name; Cd.exp_date = date; Cd.cvc_no = cvc; Cd.account_no = ano; Cd.pin = pin; string pay = HRSData.Authorizepin(Cd); return(pay); }
public static string AddBooking(string c_id, string h_id, int ac, int nonac, string t_id, DateTime book, DateTime cin, DateTime cout, int adult, int child) { Booking b = new Booking(); b.Customer_id = c_id; b.Hotel_id = h_id; b.no_adult = adult; b.no_child = child; b.No_Of_AC_Rooms = ac; b.No_Of_Non_AC_Rooms = nonac; b.T_id = t_id; b.Date_booking = book; b.Date_checkin = cin; b.Date_checkout = cout; string s = HRSData.AddBooking(b); return(s); }
public static string AddManger(string M_Name, string M_Pwd, long M_Contact, string M_email) { Manager ManAdd = new Manager(); ManAdd.name = M_Name; ManAdd.password = M_Pwd; ManAdd.m_contact = M_Contact; ManAdd.m_email = M_email; string alert; string AddMan_res = HRSData.AddManager(ManAdd); if (AddMan_res.CompareTo("no_M_Id") == 0) { alert = "Manager Not Added"; } else { alert = AddMan_res; } return(alert); }
public static string UpdateHotel(string ManagerId, string HotelId, string HotelName, string HotelDsrrp, int pincode, string Country, string City, int No_Of_Ac_Rooms, int No_Of_Non_Ac_Rooms, int price_ac_adult, int price_ac_child, int price_nonac_adult, int price_nonac_child) { Hotel update = new Hotel(); update.hotel_description = HotelDsrrp; update.id = HotelId; update.name = HotelName; update.manager_id = ManagerId; update.pincode = pincode; PinCode pin = new PinCode(); pin.pin = pincode; pin.state = Country; pin.city = City; update.PinCode1 = pin; update.no_of_ac_rooms = No_Of_Ac_Rooms; update.no_of_non_ac_rooms = No_Of_Non_Ac_Rooms; return(HRSData.UpdateHoteldata(update, price_ac_adult, price_ac_child, price_nonac_adult, price_nonac_child)); }
public static string UpdateCustomer(string C_ID, string C_Name, long C_Contact, string C_email, DateTime C_Dob, int C_PinCode, string C_Country, string C_City, string C_Pwd) { Customer CustAdd = new Customer(); CustAdd.id = C_ID; CustAdd.name = C_Name; CustAdd.c_contact = C_Contact; CustAdd.c_email = C_email; CustAdd.Dob = C_Dob; CustAdd.pincode = C_PinCode; PinCode pin = new PinCode(); pin.city = C_City; pin.state = C_Country; pin.pin = C_PinCode; CustAdd.PinCode1 = pin; CustAdd.password = C_Pwd; string AddCust_res = HRSData.UpdateCustomer(CustAdd); return(AddCust_res); }
public static DataSet FilteredHotel(string city, string country, DateTime indate, DateTime outdate) { return(HRSData.FilterHotel(city, country, indate, outdate)); }
public static DataSet AllStates() { return(HRSData.GetStates()); }
public static DataSet AllCities() { return(HRSData.GetCities()); }
public static DataSet AllManagedHotel(string managerid) { return(HRSData.MangerHotel(managerid)); }
public static DataSet AllAvilableHotel() { return(HRSData.AvilabeHotels()); }
public static int CusLogin(string name, string pass) { return(HRSData.AuthorizeCustomer(name, pass)); }
public static int ManLogin(string name, string pass) { return(HRSData.AuthorizeManager(name, pass)); }