public BookingChartDTO[] GetRoomDetailsNew(int RegionId, int AccomodationTypeId, int AccomodationId, DateTime sdate)
{
DataSet dsBookingChartData;
DataRow dr;
BookingChartDTO[] oBookingChartDTO;
string sProcName;
DatabaseManager oDB;
dsBookingChartData = null;
oBookingChartDTO = null;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_BookingChart";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iRegionId", DbType.Int32, RegionId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationTypeId", DbType.Int32, AccomodationTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iAccomodationId", DbType.Int32, AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@sdate", DbType.Date, sdate);
dsBookingChartData = oDB.ExecuteDataSet(oDB.DbCmd);
if (dsBookingChartData != null)
{
oBookingChartDTO = new BookingChartDTO[dsBookingChartData.Tables[0].Rows.Count];
for (int i = 0; i < dsBookingChartData.Tables[0].Rows.Count; i++)
{
oBookingChartDTO[i] = new BookingChartDTO();
dr = dsBookingChartData.Tables[0].Rows[i];
if (dr.ItemArray.GetValue(0) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationTypeId = Convert.ToInt32(dr.ItemArray.GetValue(0));
}
if (dr.ItemArray.GetValue(1) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationType = Convert.ToString(dr.ItemArray.GetValue(1));
}
if (dr.ItemArray.GetValue(2) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(2));
}
if (dr.ItemArray.GetValue(3) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationName = Convert.ToString(dr.ItemArray.GetValue(3));
}
if (dr.ItemArray.GetValue(4) != DBNull.Value)
{
oBookingChartDTO[i].RegionId = Convert.ToInt32(dr.ItemArray.GetValue(4));
}
if (dr.ItemArray.GetValue(5) != DBNull.Value)
{
oBookingChartDTO[i].RegionName = Convert.ToString(dr.ItemArray.GetValue(5));
}
if (dr.ItemArray.GetValue(6) != DBNull.Value)
{
oBookingChartDTO[i].RoomNo = Convert.ToString(dr.ItemArray.GetValue(6));
}
if (dr.ItemArray.GetValue(7) != DBNull.Value)
{
oBookingChartDTO[i].AccomInitial = Convert.ToString(dr.ItemArray.GetValue(7));
}
if (dr.ItemArray.GetValue(8) != DBNull.Value)
{
oBookingChartDTO[i].RoomCategoryAlias = Convert.ToString(dr.ItemArray.GetValue(8));
}
}
}
}
catch (Exception exp)
{
oDB = null;
dsBookingChartData = null;
throw exp;
}
finally
{
oDB = null;
}
return(oBookingChartDTO);
}
public BookingChartDTO[] GetRoomDetmaintenance(int AccomodationTypeId, int RegionId, int AccomodationId, string RoomNo, DateTime FromDate, DateTime ToDate)
{
DataSet dsBookingChartData;
DataRow dr;
BookingChartDTO[] oBookingChartDTO;
string sProcName;
DatabaseManager oDB;
dsBookingChartData = null;
oBookingChartDTO = null;
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_BookingChartMaintenance";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomodationTypeId", DbType.Int32, AccomodationTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RegionId", DbType.Int32, RegionId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomodationId", DbType.Int32, AccomodationId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@RoomNo", DbType.String, RoomNo);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromDate", DbType.Date, GF.HandleMaxMinDates(FromDate, false));
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ToDate", DbType.Date, GF.HandleMaxMinDates(ToDate, false));
dsBookingChartData = oDB.ExecuteDataSet(oDB.DbCmd);
if (dsBookingChartData != null)
{
oBookingChartDTO = new BookingChartDTO[dsBookingChartData.Tables[0].Rows.Count];
for (int i = 0; i < dsBookingChartData.Tables[0].Rows.Count; i++)
{
oBookingChartDTO[i] = new BookingChartDTO();
dr = dsBookingChartData.Tables[0].Rows[i];
if (dr.ItemArray.GetValue(0) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationTypeId = Convert.ToInt32(dr.ItemArray.GetValue(0));
}
if (dr.ItemArray.GetValue(1) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationType = Convert.ToString(dr.ItemArray.GetValue(1));
}
if (dr.ItemArray.GetValue(2) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(2));
}
if (dr.ItemArray.GetValue(3) != DBNull.Value)
{
oBookingChartDTO[i].AccomodationName = Convert.ToString(dr.ItemArray.GetValue(3));
}
if (dr.ItemArray.GetValue(4) != DBNull.Value)
{
oBookingChartDTO[i].RegionId = Convert.ToInt32(dr.ItemArray.GetValue(4));
}
if (dr.ItemArray.GetValue(5) != DBNull.Value)
{
oBookingChartDTO[i].RegionName = Convert.ToString(dr.ItemArray.GetValue(5));
}
if (dr.ItemArray.GetValue(6) != DBNull.Value)
{
oBookingChartDTO[i].RoomNo = Convert.ToString(dr.ItemArray.GetValue(6));
}
if (dr.ItemArray.GetValue(7) != DBNull.Value)
{
oBookingChartDTO[i].AccomInitial = Convert.ToString(dr.ItemArray.GetValue(7));
}
if (dr.ItemArray.GetValue(8) != DBNull.Value)
{
oBookingChartDTO[i].RoomCategoryAlias = Convert.ToString(dr.ItemArray.GetValue(8));
}
if (dr.ItemArray.GetValue(9) != DBNull.Value)
{
oBookingChartDTO[i].FromDt = Convert.ToDateTime(dr.ItemArray.GetValue(9));
}
if (dr.ItemArray.GetValue(10) != DBNull.Value)
{
oBookingChartDTO[i].Todt = Convert.ToDateTime(dr.ItemArray.GetValue(10));
}
if (dr.ItemArray.GetValue(11) != DBNull.Value)
{
oBookingChartDTO[i].Reason = Convert.ToString(dr.ItemArray.GetValue(11));
}
}
}
}
catch (Exception exp)
{
oDB = null;
dsBookingChartData = null;
throw exp;
}
finally
{
oDB = null;
}
return(oBookingChartDTO);
}
