public bool Delete(RoomRatePlan roomRatePlan) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_RoomRatePlanDelete"); db.AddInParameter(command, "@RoomRatePlanId", DbType.Int32, roomRatePlan.RoomRatePlanId); db.ExecuteNonQuery(command); return(true); }
public bool Delete(RoomRatePlan roomRatePlan) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_RoomRatePlanDelete"); db.AddInParameter(command, "@RoomRatePlanId", DbType.Int32, roomRatePlan.RoomRatePlanId); db.ExecuteNonQuery(command); return true; }
public bool Insert(RoomRatePlan roomRatePlan) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_RoomRatePlanInsert"); db.AddInParameter(command, "@RoomId", DbType.Int32, roomRatePlan.RoomId); db.AddInParameter(command, "@RatePlanId", DbType.Int32, roomRatePlan.RatePlanId); db.AddInParameter(command, "@Note", DbType.String, roomRatePlan.Note); db.AddInParameter(command, "@CreatedUser", DbType.Int32, roomRatePlan.CreatedUser); db.ExecuteNonQuery(command); return true; }
public bool Insert(RoomRatePlan roomRatePlan) { Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING); DbCommand command = db.GetStoredProcCommand("usp_RoomRatePlanInsert"); db.AddInParameter(command, "@RoomId", DbType.Int32, roomRatePlan.RoomId); db.AddInParameter(command, "@RatePlanId", DbType.Int32, roomRatePlan.RatePlanId); db.AddInParameter(command, "@Note", DbType.String, roomRatePlan.Note); db.AddInParameter(command, "@CreatedUser", DbType.Int32, roomRatePlan.CreatedUser); db.ExecuteNonQuery(command); return(true); }