public int InsertHotel(HotelBDto objHotelBDto, ref int hotelId)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_HOTEL_INSERT);
db.AddInParameter(dbCmd, "@HOTEL_NAME", DbType.String, objHotelBDto.HotelName);
db.AddInParameter(dbCmd, "@HOTEL_RATING", DbType.Int32, objHotelBDto.Rating);
db.AddInParameter(dbCmd, "@ADDRESS_LINE1", DbType.String, objHotelBDto.Address.AddressLine1);
db.AddInParameter(dbCmd, "@ADDRESS_LINE2", DbType.String, objHotelBDto.Address.AddressLine2);
db.AddInParameter(dbCmd, "@COUNTRY_ID", DbType.Int32, objHotelBDto.Address.CountryId);
db.AddInParameter(dbCmd, "@STATE_ID", DbType.Int32, objHotelBDto.Address.StateId);
db.AddInParameter(dbCmd, "@CITY_ID", DbType.Int32, objHotelBDto.Address.CityId);
db.AddInParameter(dbCmd, "@PINCODE", DbType.String, objHotelBDto.Address.PinCodeNo);
db.AddInParameter(dbCmd, "@EMAIL", DbType.String, objHotelBDto.Contact.EmailId);
db.AddInParameter(dbCmd, "@PHONE", DbType.String, objHotelBDto.Contact.PhoneNo);
db.AddInParameter(dbCmd, "@FAX", DbType.String, objHotelBDto.Contact.FaxNo);
db.AddInParameter(dbCmd, "@HOTEL_WEBSITE", DbType.String, objHotelBDto.HotelWebsite);
db.AddInParameter(dbCmd, "@CREATED_BY", DbType.Int32, objHotelBDto.UserId);
db.AddOutParameter(dbCmd, "@HOTEL_ID", DbType.Int32, 10);
Result = db.ExecuteNonQuery(dbCmd);
hotelId = Convert.ToInt32(db.GetParameterValue(dbCmd, "@HOTEL_ID"));
return Result;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return 0;
}
public int UpdateRoomCurrencyPriceDetails(HotelBDto objHotelBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_HOTEL_CURRENCY_PRICE_UPDATE);
db.AddInParameter(dbCmd, "@CURRENCY_PRICE_ID", DbType.Int32, objHotelBDto.CurrancyPriceId);
db.AddInParameter(dbCmd, "@HOTEL_ID", DbType.Int32, objHotelBDto.HotelId);
db.AddInParameter(dbCmd, "@ROOM_TYPE_ID", DbType.Int32, objHotelBDto.RoomTypeId);
db.AddInParameter(dbCmd, "@HOTEL_CURRENCY", DbType.Int32, objHotelBDto.Currancy);
if (objHotelBDto.Rate != 0)
db.AddInParameter(dbCmd, "@AMOUNT", DbType.Decimal, objHotelBDto.Rate);
else
db.AddInParameter(dbCmd, "@AMOUNT", DbType.Decimal, DBNull.Value);
if (objHotelBDto.Tax != 0)
db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, objHotelBDto.Tax);
else
db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, DBNull.Value);
if (objHotelBDto.GST != 0)
db.AddInParameter(dbCmd, "@GST", DbType.Decimal, objHotelBDto.GST);
else
db.AddInParameter(dbCmd, "@GST", DbType.Decimal, DBNull.Value);
db.AddOutParameter(dbCmd, "@ISEXIST", DbType.Int32, 1);
int r = db.ExecuteNonQuery(dbCmd);
Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@ISEXIST"));
return Result;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return 0;
}
public int DeleteRoomCurrencyPriceDetails(HotelBDto objHotelBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_HOTEL_CURRENCY_PRICE_DELETE);
db.AddInParameter(dbCmd, "@HOTEL_ID", DbType.Int32, objHotelBDto.HotelId);
db.AddInParameter(dbCmd, "@ROOM_TYPE_ID", DbType.Int32, objHotelBDto.RoomTypeId);
Result = db.ExecuteNonQuery(dbCmd);
return Result;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return 0;
}
public int UpdateRoom(HotelBDto objHotelBDto)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_FARE_HOTEL_ROOM_DETAILS_UPDATE);
db.AddInParameter(dbCmd, "@SR_NO", DbType.Int32, objHotelBDto.SrNo);
db.AddInParameter(dbCmd, "@ROOM_NO", DbType.String, objHotelBDto.RoomNo);
db.AddInParameter(dbCmd, "@ROOM_TYPE_ID", DbType.Int32, objHotelBDto.RoomTypeId);
db.AddInParameter(dbCmd, "@ROOM_DESC", DbType.String, objHotelBDto.RoomDesc);
db.AddInParameter(dbCmd, "@RATE", DbType.Decimal, objHotelBDto.Rate);
db.AddInParameter(dbCmd, "@CURRANCY", DbType.Int32, objHotelBDto.Currancy);
if (objHotelBDto.Discount != 0)
db.AddInParameter(dbCmd, "@DISCOUNT", DbType.Decimal, objHotelBDto.Discount);
else
db.AddInParameter(dbCmd, "@DISCOUNT", DbType.Decimal, DBNull.Value);
db.AddInParameter(dbCmd, "@TAX", DbType.Decimal, objHotelBDto.Tax);
db.AddInParameter(dbCmd, "@GST", DbType.Decimal, objHotelBDto.GST);
db.AddInParameter(dbCmd, "@PHOTO", DbType.Binary, objHotelBDto.RoomPhoto);
db.AddInParameter(dbCmd, "@PHOTO_CONTENT_TYPE", DbType.String, objHotelBDto.RoomPhotoType);
db.AddInParameter(dbCmd, "@IsPhotoChange", DbType.Boolean, objHotelBDto.IsRoomPhotoUpdate);
db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, objHotelBDto.UserId);
Result = db.ExecuteNonQuery(dbCmd);
return Result;
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return Result;
}
