public BookingRoomReportsDTO[] GetroomBookingDetailsmail(int BookingId) { BookingRoomReportsDTO[] oBRD = null; DatabaseManager oDB = null; try { oDB = new DatabaseManager(); string sProcName = "RoomBookingDetailsformail"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bookingid", DbType.Int32, BookingId); DataSet dsBRD = null; dsBRD = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; if (dsBRD != null) { oBRD = new BookingRoomReportsDTO[dsBRD.Tables[0].Rows.Count]; for (int i = 0; i < oBRD.Length; i++) { oBRD[i] = new BookingRoomReportsDTO(); oBRD[i].RoomCategory = dsBRD.Tables[0].Rows[i][0].ToString(); oBRD[i].RoomType = dsBRD.Tables[0].Rows[i][1].ToString(); oBRD[i].TotalBooked = Convert.ToInt32(dsBRD.Tables[0].Rows[i][2].ToString()); oBRD[i].TotalWaitlisted = Convert.ToInt32(dsBRD.Tables[0].Rows[i][3].ToString()); oBRD[i].Proposed = Convert.ToInt32(dsBRD.Tables[0].Rows[i][4].ToString()); } dsBRD = null; } } catch (Exception exp) { oDB = null; // GF.LogError("clsBookingRoomReportsHandler.GetDetailedBookingDetails", exp.Message); return(null); } finally { oDB = null; } return(oBRD); }
public BookingRoomReportsDTO[] GetOtherBookingsOfThisRoom(string RoomNo, DateTime StartDate, DateTime EndDate) { BookingRoomReportsDTO[] oBRD = null; DatabaseManager oDB = null; try { oDB = new DatabaseManager(); string sProcName = "up_GetOtherBookingsOfThisRoom"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sRoomNo", DbType.String, RoomNo); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@dtSD", DbType.DateTime, Convert.ToDateTime(StartDate.ToString())); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@dtED", DbType.DateTime, Convert.ToDateTime(EndDate.ToString())); DataSet dsBRD = null; dsBRD = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; if (dsBRD != null) { oBRD = new BookingRoomReportsDTO[dsBRD.Tables[0].Rows.Count]; for (int i = 0; i < oBRD.Length; i++) { oBRD[i] = new BookingRoomReportsDTO(); oBRD[i].BookingId = Convert.ToInt32(dsBRD.Tables[0].Rows[i][0].ToString()); oBRD[i].BookingRef = Convert.ToString(dsBRD.Tables[0].Rows[i][1].ToString()); } dsBRD = null; } } catch (Exception exp) { GF.LogError("clsBookingRoomReportsHandler.GetOtherBookingsOfThisRoom", exp.Message); return(null); } finally { oDB = null; } return(oBRD); }
public BookingRoomReportsDTO[] GetBookingWithinCurrentBookingDates(int BookingId) { BookingRoomReportsDTO[] oBRD = null; DatabaseManager oDB = null; try { oDB = new DatabaseManager(); string sProcName = "up_GetBookingsWithinDates"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iBookingID", DbType.Int32, BookingId); DataSet dsBRD = null; dsBRD = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; if (dsBRD != null) { oBRD = new BookingRoomReportsDTO[dsBRD.Tables[0].Rows.Count]; for (int i = 0; i < oBRD.Length; i++) { oBRD[i] = new BookingRoomReportsDTO(); oBRD[i].BookingId = Convert.ToInt32(dsBRD.Tables[0].Rows[i][0].ToString()); oBRD[i].BookingRef = Convert.ToString(dsBRD.Tables[0].Rows[i][1].ToString()); } dsBRD = null; } } catch (Exception exp) { GF.LogError("clsBookingRoomReportsHandler.GetDetailedBookingDetails", exp.Message); return(null); } finally { oDB = null; } return(oBRD); }