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