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