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."); }