public int BookTour(clsBookingData objBooking)
{
int iBookingID;
try
{
if (oDB == null)
{
oDB = new clsDatabaseManager();
}
string sProcName = "up_BookTour";
SqlParameter[] p = new SqlParameter[7];
p[0] = new SqlParameter("@sGroupID", SqlDbType.VarChar, 50);
p[0].Value = objBooking.TourId;
p[1] = new SqlParameter("@dtStartDate", SqlDbType.DateTime);
p[1].Value = objBooking.ArrivalDate;
p[2] = new SqlParameter("@dtEndDate", SqlDbType.DateTime);
p[2].Value = objBooking.DepartureDate;
p[3] = new SqlParameter("@iAccomType", SqlDbType.Int);
p[3].Value = objBooking.AccomodationTypeId;
p[4] = new SqlParameter("@iAccomSubType", SqlDbType.Int);
p[4].Value = objBooking.AccomodationId;
p[5] = new SqlParameter("@iNights", SqlDbType.Int);
p[5].Value = objBooking.NoOfNights;
p[6] = new SqlParameter("@iPersons", SqlDbType.Int);
p[6].Value = objBooking.NoOfPersons;
iBookingID = oDB.ExecuteStoredProcedure(sProcName, p);
}
catch
{
throw new Exception("The method or operation is not implemented.");
}
return(iBookingID);
}
public int AddBooking(clsBookingData oBookingData)
{
int iBookingId = 0;
if (oBHandler == null)
{
oBHandler = new clsBookingHandler();
}
iBookingId = oBHandler.AddBooking(oBookingData);
return(iBookingId);
}
public bool UpdateBooking(clsBookingData oBookingData)
{
bool updated;
if (oBHandler == null)
{
oBHandler = new clsBookingHandler();
}
updated = oBHandler.UpdateBooking(oBookingData);
return(updated);
}
public bool UpdateBooking(clsBookingData objBooking)
{
try
{
if (oDB == null)
{
oDB = new clsDatabaseManager();
}
string sProcName = "up_Ins_Booking";
SqlParameter[] p = new SqlParameter[12];
p[0] = new SqlParameter("@iBookingID", SqlDbType.Int);
p[0].Value = objBooking.BookingId;
p[1] = new SqlParameter("@sBookingCode", SqlDbType.VarChar, 12);
p[1].Value = objBooking.BookingCode;
p[2] = new SqlParameter("@sTourID", SqlDbType.VarChar, 100);
p[2].Value = objBooking.TourId;
p[3] = new SqlParameter("@dtStartDate", SqlDbType.DateTime);
p[3].Value = objBooking.ArrivalDate;
p[4] = new SqlParameter("@dtEndDate", SqlDbType.DateTime);
p[4].Value = objBooking.DepartureDate;
p[5] = new SqlParameter("@iAccomTypeId", SqlDbType.Int);
p[5].Value = objBooking.AccomodationTypeId;
p[6] = new SqlParameter("@iAccomId", SqlDbType.Int);
p[6].Value = objBooking.AccomodationId;
p[7] = new SqlParameter("@iAgentId", SqlDbType.Int);
p[7].Value = objBooking.AgentId;
p[8] = new SqlParameter("@iNights", SqlDbType.Int);
p[8].Value = objBooking.NoOfNights;
p[9] = new SqlParameter("@iPersons", SqlDbType.Int);
p[9].Value = objBooking.NoOfPersons;
p[10] = new SqlParameter("@AgentId", SqlDbType.VarChar, 5);
p[10].Value = objBooking.AgentId;
p[11] = new SqlParameter("@BookingStatusId", SqlDbType.Int);
p[11].Value = objBooking.BookingStatus;
oDB.ExecuteStoredProcedure(sProcName, p);
}
catch
{
throw new Exception("The method or operation is not implemented.");
}
return(true);
}
public bool UpdateBooking(clsBookingData objBooking)
{
throw new Exception("The method or operation is not implemented.");
}
