public DataTable getrooms(BALHotelBooking obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_hotelRates]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@action", obj.action); da.SelectCommand.Parameters.AddWithValue("@Accomid", obj.Accomid); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public DataTable GetHotelRates(BALHotelBooking obj) { DataTable dtReturnData = new DataTable(); try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); try { da.SelectCommand = new SqlCommand("[dbo].[sp_hotelRates]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@action", obj.action); da.SelectCommand.Parameters.AddWithValue("@Accomid", obj.Accomid); da.SelectCommand.Parameters.AddWithValue("@AgentId", obj.agentid); da.SelectCommand.Parameters.AddWithValue("@totpax", obj.TotPax); da.SelectCommand.Parameters.AddWithValue("@Reqnoofrooms", obj.Reqnoofrooms); da.SelectCommand.Parameters.AddWithValue("@startdate", obj.checkin); da.SelectCommand.Parameters.AddWithValue("@enddate", obj.Checkout); da.SelectCommand.Parameters.AddWithValue("@roomtypeId", obj.RoomTypeId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); cn.Close(); da.Fill(dtReturnData); } catch (Exception ex) { } if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception ex) { return(null); } //return dtReturnData; }
public DataTable GetRoomNosToBook(BALHotelBooking obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_hotelRates]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@action", obj.action); da.SelectCommand.Parameters.AddWithValue("@startdate", obj.checkin); da.SelectCommand.Parameters.AddWithValue("@enddate", obj.Checkout); da.SelectCommand.Parameters.AddWithValue("@Accomid", obj.Accomid); da.SelectCommand.Parameters.AddWithValue("@RoomCateId", obj.RoomCateId); da.SelectCommand.Parameters.AddWithValue("@RoomTypeId", obj.RoomTypeId); da.SelectCommand.Parameters.AddWithValue("@Reqnoofrooms", obj.Reqnoofrooms); da.SelectCommand.Parameters.AddWithValue("@Convertible_To_Double", obj.Convertible_To_Double); da.SelectCommand.Parameters.AddWithValue("@roomstring", obj.roomstring); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public int AddBookingMealRates(BALHotelBooking obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("[dbo].[up_Ins_BookingMealPlan]", cn); da.InsertCommand.Parameters.AddWithValue("@iBookingId", obj.iBookingId); da.InsertCommand.Parameters.AddWithValue("@iMealPlanId", obj.iMealPlanId); da.InsertCommand.Parameters.AddWithValue("@bBreakfast", obj.bBreakfast); da.InsertCommand.Parameters.AddWithValue("@bDinner", obj.bDinner); da.InsertCommand.Parameters.AddWithValue("@bEveSnacks", obj.bEveSnacks); da.InsertCommand.Parameters.AddWithValue("@bLunch", obj.bLunch); da.InsertCommand.Parameters.AddWithValue("@bWelcomeDrink", obj.bWelcomeDrink); da.InsertCommand.Parameters.AddWithValue("@dtMealDate", obj.dtMealDate); da.InsertCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.InsertCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }